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'];
}
