PHP DB_test::getFiledData方法代碼示例

 public function chaxunKuaiDiNo()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $com = $arr_body['com'];
     $nu = $arr_body['nu'];
     $query = "select fd_kdcompany_id as comid,fd_kdcompany_no as com,\n\t\t         fd_kdcompany_api as api,fd_kdcompany_name as comname from \n\t       tb_kdcompany where fd_kdcompany_no = '{$com}'";
     //隻顯示激活的列表
     $db->query($query);
     $arr_v = auto_charset($db->getFiledData(''), 'gbk', 'utf-8');
     $a = new Express();
     switch ($arr_v['api']) {
         case 'gethtmlorder':
             //echo $arr_v ['api'];
             $result = $a->gethtmlorder($com, $nu);
             $arr_msg['msgbody']['apiurl'] = $result;
             $arr_msg['msgbody']['apitype'] = $arr_v['api'];
             break;
         default:
             $result = $a->getorder($com, $nu);
             $arr_msg['msgbody'] = $result;
             $arr_msg['msgbody']['apitype'] = $arr_v['api'];
             break;
     }
     $arr_message = array("result" => "success", "message" => "讀取成功!");
     $retcode = "0";
     //反饋狀態 0 成功 200 自定義錯誤
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }

function getauthorset($tabname, $filename)
{
    $db = new DB_test();
    $query = "select * from {$tabname} left join tb_arrive on fd_arrive_id=fd_" . $filename . "_arriveid left join  tb_authorindustry on fd_auindustry_id=fd_" . $filename . "_auindustryid";
    $db->query($query);
    $arr_data = $db->getFiledData();
    foreach ($arr_data as $value) {
        foreach ($value as $key => $v) {
            $id = $value['fd_' . $filename . '_id'];
            if ($key != "fd_" . $filename . "_id") {
                $arr_newdata[$id][$key] = $v;
            }
        }
    }
    return $arr_newdata;
}

function getsalepaycardbackstate()
{
    $db = new DB_test();
    $query = "select fd_selt_state as state,fd_stdetail_paycardid as paycardid,fd_selt_date as date,fd_stdetail_memo as memo   from tb_salelistbackdetail\n\tleft join tb_salelistback on fd_selt_id=fd_stdetail_seltid";
    $db->query($query);
    $arr_data = $db->getFiledData();
    foreach ($arr_data as $value) {
        $arr_pacardid = explode(",", $value['paycardid']);
        foreach ($arr_pacardid as $v1) {
            $arr_state[$v1]['state'] = $value['state'];
            $arr_state[$v1]['date'] = $value['date'];
            $arr_state[$v1]['memo'] = $value['memo'];
        }
    }
    return $arr_state;
}

if (!empty($typekind)) {
    switch ($typekind) {
        case "pay":
            $thname = "支付額";
            break;
        case "cost":
            $thname = "成本";
            break;
        case "fee":
            $thname = "手續費";
            break;
    }
}
$query = "select  case\n                 when fd_agpm_paytype ='coupon' then '購買抵用券'\n                 when fd_agpm_paytype ='creditcard' then '信用卡還款'" . "when fd_agpm_paytype ='recharge' then        '充值'" . "when fd_agpm_paytype ='pay' then       '還貸款'" . "when fd_agpm_paytype ='order' then '訂單付款'" . "when fd_agpm_paytype ='tfmg' then '轉賬匯款'\n                 else '其他業務' END  paytype,\n\t\t\t\tfd_agpm_id               as agpmid,\n                fd_agpm_agentmoney  as money,\n\t\t\t\tfd_agpm_payfee  as payfee,\n\t\t\t\tfd_agpm_sdcragentfeemoney  as costmoney,\n\t\t\t\tfd_agpm_agentdate        as paydate,\n\t\t\t\tfd_agpm_paytype as url,\n\t\t\t\t\n\t\t\t\tfd_agpm_bkntno as bkntno,\t\n\t\t\t\tfd_agpm_shoucardno as shoucardno,\n                fd_agpm_shoucardbank as shoucardbank,\n\t\t\t\tfd_agpm_shoucardman as shoucardman,\n                fd_agpm_shoucardmobile as shoucardmobile,\n\t\t\t\tfd_agpm_bkordernumber            as bkordernumber,\n                 fd_paycard_key                   as paycardkey,\n                 fd_author_truename               as author\n\t\t\t\t\n\t\t  from tb_agentpaymoneylist \n\t\t  left join tb_paycard on fd_agpm_paycardid = fd_paycard_id\n          left join tb_author  on fd_author_id  = fd_agpm_authorid \n\t\t  left join tb_paymoneylistdetail on fd_pymyltdetail_agpmid = fd_agpm_id \n\t\t  left join tb_paymoneylist on fd_pymyltdetail_paymoneylistid = fd_pymylt_id\n          where fd_agpm_payrq = '00' and fd_agpm_isagentpay = '1' {$where} and year(fd_agpm_agentdate) = '{$year}'";
$db->query($query);
$arr_result = $db->getFiledData('');
foreach ($arr_result as $val) {
    if ($val['url'] == 'coupon') {
        $val['url'] = 'couponsale_view';
    }
    if ($val['url'] == 'creditcard') {
        $val['url'] = 'creditcard_sp';
    }
    if ($val['url'] == 'recharge') {
        $val['url'] = 'rechargeglist_sp';
    }
    if ($val['url'] == 'tfmg') {
        $val['url'] = 'transfermoney_sp';
    }
    if ($val['url'] == 'pay') {
        $val['url'] = 'repaymoney_sp';

function getauthorset($tabname, $filename, $id)
{
    $db = new DB_test();
    $query = "select fd_" . $filename . "_name as name from  {$tabname}\n\twhere fd_" . $filename . "_id='{$id}'";
    $db->query($query);
    $arr_data = $db->getFiledData();
    return $arr_data['0']['name'];
}

$allcbmoney = '<a href="payment_detail.php?type=day&datetime=' . $curData . '&collect=day">' . $allcbmoney . '</a>';
$allpayfee = '<a href="payment_detail.php?type=day&datetime=' . $curData . '&collect=day">' . $allpayfee . '</a>';
$allagentmoney = '<a href="payment_detail.php?type=day&datetime=' . $curData . '&collect=day">' . $allagentmoney . '</a>';
foreach ($arr_paytype as $key => $value) {
    $paymoney = changenum('2', $arr_allmoney[$key]['paymoney']);
    $agentmoney = changenum('2', $arr_allmoney[$key]['agentmoney']);
    $cbmoney = changenum('2', $arr_allmoney[$key]['cbmoney']);
    $payfee = changenum('2', $arr_allmoney[$key]['payfee']);
    $showall .= ' <td class="right"><a href="payment_detail.php?type=day&datetime=' . $curData . '&paytype=' . $key . '&collect=day">' . $paymoney . '</a></td>
              <td class="right"><a href="payment_detail.php?type=day&datetime=' . $curData . '&paytype=' . $key . '&collect=day">' . $agentmoney . '</a></td>
              <td class="right"><a href="payment_detail.php?type=day&datetime=' . $curData . '&paytype=' . $key . '&collect=day">' . $cbmoney . '</a></td>
              <td class="right" style="border-right:1px #222 solid"><a href="payment_detail.php?type=day&datetime=' . $curData . '&paytype=' . $key . '&collect=day">' . $payfee . '</a></td>';
}
$query = "select fd_sdcr_id as sdcrid ,fd_sdcr_name as sdcrname   from tb_sendcenter";
$db->query($query);
$arr_data = $db->getFiledData();
foreach ($arr_data as $value) {
    $arr_sdcrid[] = $value['sdcrid'];
    $arr_sdcrname[] = $value['sdcrname'];
}
$sdcrname = makeselect($arr_sdcrname, $sdcrname, $arr_sdcrid);
$t->set_var("sdcrname", $sdcrname);
$t->set_var("type", $type);
$t->set_var("showall", $showall);
$t->set_var("typeyear", $typeyear);
$t->set_var("isdisplay", $isdisplay);
$t->set_var("count", $count);
$t->set_var("error", $error);
$t->set_var("startday", $startday);
$t->set_var("endday", $endday);
$t->set_var("authorname", $authorname);

<?php

$thismenucode = "10n002";
require "../include/common.inc.php";
$db = new DB_test();
//$dbtj = new DB_test ;
$t = new Template('.', "keep");
$t->set_file("agency_monthtable_view", "realtimetradeview.html");
$indate = date("Y-m-d", time());
//獲取代付收入金額
$t->set_block("agency_monthtable_view", "prolist", "prolists");
$query = "select\n       case \n        when fd_agpm_payrq ='01' then '<font color=blue>請求交易</font>'\n        when fd_agpm_payrq ='00' then '<font color=green>交易完成</font>'\n        when fd_agpm_payrq ='03' then '<font color=red>交易取消</font>'\n        else '無效狀態' END  payrq,\n\t\tcase \n        when fd_paycard_scope ='creditcard' then '信用卡'\n        when fd_paycard_scope ='bankcard' then '借記卡'\n\t\t END paycardscope,\n\t\t \n\t\tfd_appmnu_name  as\t paytype,\n\t\tfd_agpm_id as payid,\n\t\tfd_paycard_key as paycardkey,\n\t\t\tfd_sdcr_name as sdcrname,\n\t\t\tfd_agpm_bkordernumber as bkordernumber,\n\t\t\tfd_author_truename as authorname,\n\t\t\tdate_format(fd_agpm_paydate,'%m-%d') as paydate ,\n\t\t   date_format(fd_agpm_arrivedate,'%m-%d') as arrivedate,\n\t\t\tfd_agpm_bkmoney as paymoney,\n\t\t   fd_agpm_sdcrpayfeemoney as sdcrpayfeemoney,\n\t\t   fd_agpm_payfee as payfee ,\n\t\t   (fd_agpm_payfee -fd_agpm_sdcrpayfeemoney) as lirun  \n\t\t\tfrom tb_agentpaymoneylist\n\t\t\tleft join tb_author on fd_author_id = fd_agpm_authorid\n\t\t\tleft join tb_paycard on fd_paycard_id = fd_agpm_paycardid\n\t\t\tleft join tb_appmenu on fd_appmnu_no = fd_agpm_paytype\n\t\t\tleft join tb_sendcenter on fd_agpm_sdcrid = fd_sdcr_id\n\t\t\twhere fd_agpm_method = 'in' \n\t\t\torder by fd_agpm_datetime desc limit 100";
$db->query($query);
$arr_result = $db->getFiledData('');
foreach ($arr_result as $val) {
    $t->set_var($val);
    $allpaymoney += $val['paymoney'];
    $allsdcrpayfeemoney += $val['sdcrpayfeemoney'];
    $allpayfee += $val['payfee'];
    $alllirun += $val['lirun'];
    $t->parse("prolists", "prolist", true);
}
if (empty($arr_result)) {
    $t->parse("prolists", "", true);
}
$query = "select\n\t\t\tfd_agpm_paydate as paydate,\n\t\t\tfd_agpm_bkmoney as paymoney\n\t\t\tfrom tb_agentpaymoneylist\n\t\t\twhere fd_agpm_method = 'in' \n\t\t\tand fd_agpm_paydate='{$indate}'";
$db->query($query);
$arr_data = $db->getFiledData('');
foreach ($arr_data as $val) {
    $all_paymoney += $val['paymoney'];
}