PHP DB_test::execute方法代碼示例

 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 static function getpaymerinfo($authorid)
 {
     $db = new DB_test();
     $ErrorReponse = new ErrorReponse();
     $query = "select fd_sdcr_merid as merid,fd_sdcr_securitykey as securitykey,fd_sdcr_id as sdcrid," . "fd_sdcr_payfee as \t\t  sdcrpayfee,fd_sdcr_tradeurl as tradeurl,fd_sdcr_queryurl as queryurl," . "fd_sdcr_minpayfee as minsdcrpayfee," . "fd_sdcr_agentfee as sdcragentfee from tb_author join tb_sendcenter " . "on fd_sdcr_id = fd_author_sdcrid where fd_author_id = '{$authorid}'";
     if ($db->execute($query)) {
         $arr_merinfo = $db->get_one($query);
         return $arr_merinfo;
     } else {
         $Error = array('rettype' => '100', 'retcode' => '100', 'retmsg' => '商戶未審核，不允許操作該功能。');
         $ErrorReponse->reponError($Error);
         exit;
     }
 }

 public function readQQhasRechamoney($qq)
 {
     //計算QQ當前刷卡金額
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = $arr_channelinfo['authorid'];
     $now = date('Y-m-d');
     $query = "select  sum(fd_mrclist_rechamoney) as remoney from tb_qqrechargelist\n               where fd_mrclist_qq = '{$qq}' and fd_mrclist_payrq= '00' and fd_mrclist_paydate = '{$now}'";
     if ($db->execute($query)) {
         $arr_merinfo = $db->get_one($query);
     }
     return $arr_merinfo['remoney'];
 }

 public function readRechacostmoney($money)
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = $arr_channelinfo['authorid'];
     $query = "select   (fd_recham_paymoney-fd_recham_costmoney) as payfee from tb_mobilerechamoney\n        where fd_recham_money = '{$money}'";
     $db->query($query);
     if ($db->execute($query)) {
         $arr_merinfo = $db->get_one($query);
         $payfee = $arr_merinfo['payfee'] - $money * 0.44 / 100;
     } else {
         $payfee = 0;
     }
     return $payfee;
 }

 public function AddKuaibkcard()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $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));
     $query = "select 1 from tb_author_quickpaycard where fd_bkauthorid = {$authorid} AND fd_bkcardno = '{$bkcardno}'";
     if ($db->execute($query)) {
         ErrorReponse::reponError(array('retcode' => '200', 'retmsg' => '該卡已經綁定過'));
     }
     if ($bkcardisdefault == 1) {
         $query = "UPDATE tb_author_quickpaycard SET fd_bkcardisdefault = 0 WHERE fd_bkauthorid = " . $authorid;
         $db->query($query);
     }
     $query = "insert into tb_author_quickpaycard(\n\t\t\t\t\t\t\tfd_bkauthorid\t\t\t,fd_bkcardno\t\t,fd_bkcardbankid\t,\n\t\t\t\t            fd_bkcardbankcode\t\t,fd_bkcardbank\t\t,fd_bkcardbankman\t,\n\t\t\t\t            fd_bkcardbankphone\t\t,fd_bkcardyxmonth          ,fd_bkcardyxyear     ,\n\t\t\t\t            fd_bkcardcvv\t\t,fd_bkcardidcard\t\t,fd_bkcardisdefault\t\t ,\n\t\t\t\t            fd_bkcardcardtype)values\n\t\t\t\t\t\t   ('{$authorid}'\t\t,'{$bkcardno}'\t,'{$bkcardbankid}'\t\t,\n\t\t\t\t\t\t   '{$bkcardbankcode}'\t\t,'{$bkcardbank}'\t,'{$bkcardbankman}'\t\t,\n\t\t\t\t\t\t   '{$bkcardbankphone}'\t\t,'{$bkcardyxmonth}'\t,'{$bkcardyxyear}'\t\t\t,\n\t\t\t\t\t\t   '{$bkcardcvv}'\t\t\t,'{$bkcardidcard}','{$bkcardisdefault}'\t\t,\n\t\t\t\t\t\t   '{$bkcardcardtype}')";
     $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;
 }

 function getappnav($req_version, $req_appenv, $req_appevn)
 {
     $db = new DB_test();
     if ($req_appevn != '') {
         $req_appenv = $req_appevn;
     }
     if ($req_version == '') {
         return true;
     }
     if ($req_appenv < 3) {
         $query = "select * from tb_version where fd_version_apptype= '1' and fd_version_no <= '{$req_version}'";
         if ($db->execute($query)) {
             return true;
         } else {
             $Error = array('result' => 'failure', 'retcode' => '200', 'retmsg' => '您使用的是舊版本程序，請下載【通過菜單-》更多-》版本更新】最新本！');
             $this->ErrorReponse->reponError($Error);
             //出錯反饋
             exit;
         }
     }
 }

 public static function get_cusfenrun($cusid, $appmenuno, $paymoney, $payfee, $feelirun = 0)
 {
     $db = new DB_test();
     $query = "select * from tb_appmenu where fd_appmnu_no = '{$appmenuno}'";
     if ($db->execute($query)) {
         $arr_menuval = $db->get_one($query);
         $appmenuid = $arr_menuval['fd_appmnu_id'];
     } else {
         $appmenuid = 0;
         //所有功能 ；
     }
     $query = "select fd_cus_fenrunid  as fenrunid from tb_customer where fd_cus_id = '{$cusid}'  ";
     if ($db->execute($query)) {
         $arr_cus = $db->get_one($query);
         $fenrunid = $arr_cus['fenrunid'];
     }
     $query = "select * from tb_cus_fenrunset where fd_fenrun_id = '{$fenrunid}'  ";
     if ($db->execute($query)) {
         $arr_fenrun = $db->get_one($query);
     }
     $query = "select * from tb_cus_fenrunsetappmenu where fd_frmset_fenrunid = '{$fenrunid}' group by fd_frmset_appmnuid  ";
     if ($db->execute($query)) {
         $arr_fenrunappmenu = $db->get_all_key($query, fd_frmset_appmnuid);
     }
     $arr_lirunset = $arr_fenrunappmenu[$appmenuid];
     //獲取到功能分潤設置
     if (is_array($arr_lirunset)) {
         $jsmoneytype = $arr_lirunset['fd_frmset_jsmoneytype'];
         switch ($jsmoneytype) {
             case "paymoney":
                 $paycardmoney = $paymoney;
                 //交易金額
                 break;
             case "payfee":
                 $paycardmoney = $payfee;
                 break;
             case "feelirun":
                 $paycardmoney = $feelirun;
                 break;
         }
         $mode = $arr_lirunset['fd_frmset_mode'];
         //潤分方式 固定還是%
         $fixfee = $arr_lirunset['fd_frmset_fee'];
         //固定分潤金額
         $minfee = $arr_lirunset['fd_frmset_minfee'];
         //最小分潤金額
         $maxfee = $arr_lirunset['fd_frmset_maxfee'];
         //最大分潤金額
         $fee = $arr_lirunset['fd_frmset_sqfee'];
         //浮動費率
         $fee = substr($fee, 0, -1);
         switch ($mode) {
             case "fix":
                 $return_feemoney = $fixfee;
                 break;
             default:
                 $return_feemoney = round($fee / 100 * $paycardmoney, 2);
                 $return_feemoney = $return_feemoney < $minfee ? $minfee : $return_feemoney;
                 $return_feemoney = $return_feemoney > $maxfee ? $maxfee : $return_feemoney;
                 break;
         }
     } else {
         $return_feemoney = 0;
         //為設置分潤方案
     }
     return $return_feemoney;
 }

 public static function getauthorusername($authorid)
 {
     $db = new DB_test();
     $query = "select fd_author_state as state,fd_author_truename as truename,fd_author_username as username," . " fd_author_memid as memid,fd_author_shoucardno as shoucardno,fd_author_shoucardman as shoucardman," . " fd_author_shoucardphone as shoucardmobile,fd_author_shoucardbank as shoucardbank from" . " tb_author where fd_author_id  = '{$authorid}' ";
     if ($db->execute($query)) {
         $arr_author = $db->get_one($query);
         $authortruename = g2u($arr_author['username']);
     }
     return $arr_author;
 }

 public function PayFeedback($payResult, $orderId)
 {
     $now = time();
     $logger = Logger::getLogger('mobilerecharge');
     $logger->info("開始處理手機充值支付後返回數據({$now}) : 訂單號({$orderId}), 返回的支付信息" . print_r($payResult, true));
     if ($payResult['orderId'] != "" && $orderId != "" && $payResult['orderId'] != $orderId || $payResult['orderId'] == "" && $orderId == "") {
         $logger->error("處理手機充值支付後返回數據出錯({$now}) : 訂單號有錯誤(" . $payResult['orderId'] . "不等於" . $orderId . ")");
         return;
     }
     $orderId = $orderId != "" ? $orderId : $payResult['orderId'];
     $logger->debug("正在處理手機充值支付後返回數據({$now}) : 通付寶訂單號({$orderId})");
     if ($payResult['returnCode'] != "1" && $payResult['transNumber'] == "") {
         return;
     }
     $db = new DB_test();
     if ($payResult['returnCode'] == "1") {
         $query = "SELECT fd_mrclist_rechaphone, fd_mrclist_rechamoney, fd_mrclist_authorid, fd_mrclist_cusid, fd_mrclist_paycardid, fd_mrclist_bkmoney, fd_mrclist_payfee, fd_mrclist_cusfee, fd_mrclist_sdcrid FROM tb_mobilerechargelist \n\t\t\tWHERE fd_mrclist_bkordernumber = '" . $orderId . "' AND fd_mrclist_payrq != '00'";
         $dataInDB = $db->get_all($query);
         if (is_array($dataInDB) && count($dataInDB) == 1) {
             $logger->debug("正在處理手機充值支付後返回數據({$now}) : 通過通付寶訂單號({$orderId})獲取數據" . print_r($dataInDB, true));
             // 給代理商分潤
             $query = "SELECT 1 FROM tb_cus_fenrunglist WHERE fd_frlist_bkordernumber = '" . $orderId . "' LIMIT 1";
             $logger->debug("正在處理手機充值支付後返回數據({$now}) : 判斷是否需要添加數據到tb_cus_fenrunglist表 " . $query);
             $hasShareInterest = $db->execute($query);
             if (!$hasShareInterest) {
                 $logger->debug("正在處理手機充值支付後返回數據({$now}) : 需要添加數據到tb_cus_fenrunglist表");
                 $query = "INSERT INTO tb_cus_fenrunglist (fd_frlist_authorid, fd_frlist_cusid, fd_frlist_paycardid, fd_frlist_paydate, fd_frlist_paymoney, fd_frlist_payfee, fd_frlist_cusfee, fd_frlist_bkordernumber, fd_frlist_payrq, fd_frlist_paytype, fd_frlist_datetime, fd_frlist_ifjsfenrun, fd_frlist_sdcrid) VALUES (" . $dataInDB[0]['fd_mrclist_authorid'] . ", " . $dataInDB[0]['fd_mrclist_cusid'] . ", '" . $dataInDB[0]['fd_mrclist_paycardid'] . "', NOW(), " . $dataInDB[0]['fd_mrclist_bkmoney'] . ", " . $dataInDB[0]['fd_mrclist_payfee'] . ", " . $dataInDB[0]['fd_mrclist_cusfee'] . ", '" . $orderId . "', '00', 'mobilerecharge', NOW(), 0, '" . $dataInDB[0]['fd_mrclist_sdcrid'] . "');";
                 $db->query($query);
                 $logger->debug("正在處理手機充值支付後返回數據({$now}) : 代理商分潤時執行的SQL語句" . $query);
             } else {
                 $logger->debug("正在處理手機充值支付後返回數據({$now}) : 代理商分潤時執行的SQL語句");
             }
             $data = array('FUNC' => 'MOBILE_RECHARGE', 'phone' => $dataInDB[0]['fd_mrclist_rechaphone'], 'money' => $dataInDB[0]['fd_mrclist_rechamoney'], 'orderId' => $orderId);
             $logger->info("完成處理手機充值支付後返回數據({$now}) : 發起充值 : " . print_r($data, true));
             AsyncCall($data);
         } else {
             $logger->error("完成處理手機充值支付後返回數據({$now}) : 通過通付寶訂單號({$orderId})獲取的數據有誤 : " . print_r($dataInDB, true));
         }
     }
     // 返回的數據回寫進通付寶數據庫
     if ($payResult['returnCode'] == "1") {
         if ($payResult['transNumber'] != "") {
             // 支付成功，易寶交易號不為空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_bkntno = '" . $payResult['transNumber'] . "', fd_mrclist_payrq = '00' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         } else {
             // 支付成功，易寶交易號為空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_payrq = '00' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         }
     } else {
         if ($payResult['transNumber'] != "") {
             // 支付不成功，易寶交易號不為空
             $query = "UPDATE tb_mobilerechargelist SET fd_mrclist_bkntno = '" . $payResult['transNumber'] . "' WHERE fd_mrclist_bkordernumber = '" . $orderId . "'";
         }
     }
     $logger->debug("正在處理手機充值支付後返回數據({$now}) : query({$query})");
     if ($query != "") {
         $db->query($query);
     }
     $logger->debug("正在處理手機充值支付後返回數據({$now}) : 通付寶訂單號({$orderId})回寫進通付寶數據庫");
 }

 public function activePayCard()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $paycardkey = $arr_body['paycardkey'];
     $authorid = $arr_channelinfo['authorid'];
     $paycardkey = strtolower($paycardkey);
     $paycardkey = str_replace("fff", "", $paycardkey);
     $query = "select fd_paycard_id,fd_paycard_active from tb_paycard where  fd_paycard_key = '{$paycardkey}' ";
     //首頁廣告顯示
     $db->query($query);
     if (!$db->nf()) {
         $arr_message = array("result" => "failure", "message" => "激活失敗,刷卡器設備號碼不存在，請聯係客服!");
         $retcode = "200";
         //反饋狀態 0 成功 200 自定義錯誤
     } else {
         $query = "select fd_paycard_id,fd_paycard_active from tb_paycard where " . " (fd_paycard_authorid ='0' or fd_paycard_authorid is NULL) \n\t\t\t      and fd_paycard_key = '{$paycardkey}' ";
         //首頁廣告顯示
         $db->query($query);
         if ($db->nf()) {
             $db->next_record();
             $paycardid = $db->f(fd_paycard_id);
             $query = "update tb_paycard set fd_paycard_active = '1' ,fd_paycard_activetime = now()," . "fd_paycard_authorid = '{$authorid}',fd_paycard_posstate='2' where fd_paycard_id = '{$paycardid}'";
             $db->query($query);
             $arr_message = array("result" => "success", "message" => "恭喜您，刷卡器已經激活成功!");
             $retcode = "0";
             //反饋狀態 0 成功 200 自定義錯誤
         } else {
             $query = "select fd_paycard_id,fd_paycard_active from tb_paycard where " . " 1\n\t\t\t      and fd_paycard_key = '{$paycardkey}' and fd_paycard_authorid <>'{$authorid}'";
             //首頁廣告顯示
             if ($db->execute($query)) {
                 $retmessage = "該刷卡器已被其他商戶激活";
             } else {
                 $retmessage = "你已激活刷卡器,可以直接使用了!";
             }
             $arr_message = array("result" => "failure", "message" => $retmessage);
             $retcode = "200";
             //反饋狀態 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 getmoreFileimg($scatid, $dateid, $limitnum = 6)
 {
     global $g_showpic;
     $db = new DB_test();
     if ($dateid) {
         $querywhere = " and fd_cat_dateid='{$dateid}'";
     } else {
         $queryorder = " limit 0,{$limitnum}";
     }
     $query = "select fd_cat_thumurl as thumrul,fd_cat_urllink as urllink,fd_cat_no as no,fd_cat_id as id,fd_cat_url as url,fd_cat_id as id,fd_cat_name as content,fd_cat_display as display from tb_upload_category_list where fd_cat_scatid='{$scatid}' {$querywhere}  order by fd_cat_no asc {$queryorder}";
     if ($db->execute($query)) {
         $arr_yewuval = $db->get_all($query);
     }
     // echo $query;
     return $arr_yewuval;
 }

 public static function readpmreqmoney($authorid)
 {
     $db = new DB_test();
     $query = "select sum(fd_pmreq_repmoney) as repmoney,month(fd_pmreq_reqdatetime) as months," . "year(fd_pmreq_reqdatetime) as years " . "from tb_slotcardmoneyreq where fd_pmreq_authorid = '{$authorid}' and fd_pmreq_state = '9' " . "group by years,months ";
     if ($db->execute($query)) {
         $arr_monthreqmoney = $db->get_one($query);
     }
     return $arr_monthreqmoney;
 }

 public static function get_cusfenrun($cusid, $appmenuno, $paymoney, $payfee, $feelirun = 0, $paydate = '', $payprice = '', $paynum = '')
 {
     $db = new DB_test();
     $query = "select * from tb_appmenu where fd_appmnu_no = '{$appmenuno}'";
     if ($db->execute($query)) {
         $arr_menuval = $db->get_one($query);
         $appmenuid = $arr_menuval['fd_appmnu_id'];
     } else {
         $appmenuid = 0;
         //所有功能 ；
     }
     $query = "select fd_cus_fenrunid  as fenrunid\n       from tb_customer where fd_cus_id = '{$cusid}' and fd_cus_state = 9 and\n        fd_cus_active = '1'   ";
     if ($db->execute($query)) {
         $arr_cus = $db->get_one($query);
         $fenrunid = $arr_cus['fenrunid'];
     } else {
         return 0;
         exit;
     }
     $query = "select *,fd_fenrun_orderbuycz as orderbuycz,fd_fenrun_agentprice as agentprice\n        from tb_cus_fenrunset where fd_fenrun_id = '{$fenrunid}'  ";
     if ($db->execute($query)) {
         $arr_fenrun = $db->get_one($query);
     }
     $agentprice = $arr_fenrun['agentprice'];
     $orderbuycz = $arr_fenrun['orderbuycz'];
     if ($appmenuno == 'orderbuy') {
         $cusfee = ($payprice - $orderbuycz - $agentprice) * $paynum;
         return $cusfee;
         exit;
     }
     if ($arr_fenrun['fd_fenrun_lirunset'] == 'all') {
         $appmenuid = 0;
     }
     $query = "select * from tb_cus_fenrunsetappmenu where fd_frmset_fenrunid = '{$fenrunid}' group by fd_frmset_appmnuid  ";
     if ($db->execute($query)) {
         $arr_fenrunappmenu = $db->get_all_key($query, "fd_frmset_appmnuid");
     }
     $arr_lirunset = $arr_fenrunappmenu[$appmenuid];
     //獲取到功能分潤設置
     if (is_array($arr_lirunset)) {
         $jsmoneytype = $arr_lirunset['fd_frmset_jsmoneytype'];
         switch ($jsmoneytype) {
             case "paymoney":
                 $paycardmoney = $paymoney;
                 //交易金額
                 break;
             case "payfee":
                 $paycardmoney = $payfee;
                 break;
             case "feelirun":
                 $paycardmoney = $feelirun;
                 break;
         }
         $mode = $arr_lirunset['fd_frmset_mode'];
         //潤分方式 固定還是%
         $fixfee = $arr_lirunset['fd_frmset_fee'];
         //固定分潤金額
         $minfee = $arr_lirunset['fd_frmset_minfee'];
         //最小分潤金額
         $maxfee = $arr_lirunset['fd_frmset_maxfee'];
         //最大分潤金額
         $fee = $arr_lirunset['fd_frmset_sqfee'];
         //浮動費率
         $fee = substr($fee, 0, -1);
         switch ($mode) {
             case "fix":
                 $return_feemoney = $fixfee;
                 break;
             default:
                 $return_feemoney = round($fee / 100 * $paycardmoney, 2);
                 $return_feemoney = $return_feemoney < $minfee ? $minfee : $return_feemoney;
                 $return_feemoney = $return_feemoney > $maxfee ? $maxfee : $return_feemoney;
                 break;
         }
     } else {
         $return_feemoney = 0;
         //為設置分潤方案
     }
     return $return_feemoney;
 }

 public function payagentfenrunlist()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     //$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //插卡器
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     $agentid = trim($arr_channelinfo['agentid']);
     //代理商id
     $querytype = trim($arr_body['querytype']);
     //收益條件
     $querywhere = trim($arr_body['querywhere']);
     //充值金額
     $appfunid = trim($arr_body['appfunid']);
     //充值金額
     switch ($querytype) {
         case "year":
             break;
         case "month":
             break;
         case "date":
             break;
     }
     $querywhere1 = " and fd_frlist_paydate like '%{$querywhere}%'";
     $query = "select fd_frlist_cusid,sum(fd_frlist_cusfee) as totalfenrun\n             from tb_cus_fenrunglist\n               where fd_frlist_payrq = '00' and fd_frlist_sdcrid<100\n              {$querywhere1} and fd_frlist_cusid = '{$agentid}'   group by fd_frlist_cusid\n     ";
     if ($db->execute($query)) {
         $arr_money = $db->get_one($query);
     }
     $query = "select fd_amtype_id as appfunid, fd_amtype_name as appfunname,\n               sum(fd_frlist_paymoney) as paymoney,sum(fd_frlist_payfee) as payfee,sum(fd_frlist_cusfee) as allfenrun\n               from tb_cus_fenrunglist left  join tb_appmenu on fd_appmnu_no = fd_frlist_paytype\n               left join tb_appmenutype on fd_amtype_id = fd_appmnu_amtypeid\n               where fd_frlist_payrq = '00' and fd_frlist_sdcrid<100\n              {$querywhere1} and fd_frlist_cusid = '{$agentid}'   group by fd_amtype_id order by\n              fd_amtype_no     ";
     $db->query($query);
     $msgdiscount = $db->nf();
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "沒有數據!");
         $retcode = "200";
         //反饋狀態 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']['totalfenrun'] = $arr_money['totalfenrun'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

 public static function readsuptfmgcount($authorid, $paytype)
 {
     $db = new DB_test();
     $datetime = date("Y-m-d");
     $query = "select count(1) as count " . "from tb_agentpaymoneylist  where fd_agpm_authorid = '{$authorid}' and fd_agpm_paytype  = '{$paytype}' and " . "fd_agpm_paydate = '{$datetime}' and fd_agpm_payrq = '00'  ";
     if ($db->execute($query)) {
         $arr_count = $db->get_one($query);
     }
     return $arr_count['count'];
 }