public function getareaauthornum($cusid, $month)
{
$db = new db_test();
$query = "select count(*) as activecardnum from tb_author\n where fd_author_bdagentid = '{$cusid}'\n and (fd_author_bdagenttime) like '%{$month}%'\n group by fd_author_bdagentid";
// echo $query;
if ($db->execute($query)) {
$arr_money = $db->get_one($query);
}
return $arr_money['activecardnum'];
}
$thismenucode = "2k508";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
$gotourl = "yewupayset.php";
$t = new Template(".", "keep");
$t->set_file("template", "yewupayset.html");
$t->set_block("template", "BXBK", "BXBKs");
$arr_text = array("编号", "业务类型", "交易规则", "操作");
for ($i = 0; $i < count($arr_text); $i++) {
$theadth .= ' <th>' . $arr_text[$i] . '</th>';
}
$query = "select * from tb_creditcardset";
$arr_creditcset = $db->get_one($query);
if ($arr_creditcset['fd_creditcset_whenpayfee'] = 'post') {
$showname = '通付宝刷卡时';
} else {
$showname = '支金代付款时';
}
$arr_cinput['creditcardset'] = "\n\t还信用卡刷卡金额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_slotcardmoney'] . "</font></u> 元/笔，\n\t商户刷卡 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_dayslotcard'] . "</font></u> 次/月，\n\t月还款总限额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_maxmoney'] . "</font></u> 元,\n\t单卡还款次数 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_monthslotcard'] . "</font></u> 次/月，";
if ($arr_creditcset['fd_creditcset_mode'] == 'fix') {
$arr_cinput['creditcardset'] .= "固定手续费 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_fee'] . "</font></u> 元/笔。";
} else {
$arr_cinput['creditcardset'] .= "\n\t最低费率额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_minfee'] . "</font></u> ,\n\t最高费率额 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_maxfee'] . "</font></u> ，\n\t收取费率 <u><font color='#00CC00'>" . $arr_creditcset['fd_creditcset_sqfee'] . "</font></u> 。";
}
$query = "select * from tb_transfermoneyset where fd_transfermoneyset_tfmgtype = 'tfmg'";
$arr_transfermoneyset = $db->get_one($query);
$arr_cinput['transfermoneyset'] = "\n\t转账刷卡金额 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_slotcardmoney'] . "</font></u> 元/笔，\n\t转账刷卡次数 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_dayslotcardcount'] . "</font></u> 次/日 ， \n\t转账月限额 <u><font color='#00CC00'>" . $arr_transfermoneyset['fd_transfermoneyset_datemaxcount'] . "</font></u> 元,\n\t\n\t";
if ($arr_transfermoneyset['fd_transfermoneyset_mode'] == 'fix') {
<?php
require "../include/common.inc.php";
$db = new db_test();
$query = "select fd_couponset_fee as fee,fd_couponset_maxfee as maxfee from tb_couponset left join tb_arrive on fd_arrive_id =fd_couponset_arriveid";
$arr_couponset = $db->get_one($query);
$couponfee = substr($arr_couponset['fee'], 0, -1);
//¸¡¶¯ÊÖÐø·Ñ
$boolean = 0;
$query = "select\n case\n when fd_agpm_payfeedirct ='f' then fd_agpm_paymoney\n when fd_agpm_payfeedirct ='s' then (fd_agpm_paymoney-fd_agpm_payfee)\n else fd_agpm_paymoney END money,\n\n fd_agpm_bkordernumber as bkordernumber,\n fd_pymyltdetail_id as vid,\n fd_agpm_bkntno as bkntno,\n fd_paycard_key as paycardkey,\n fd_author_truename as author,\n fd_agpm_paytype as paytypee,\n fd_agpm_paydate as paydate,\n fd_agpm_shoucardno as shoucardno,\n fd_agpm_shoucardbank as shoucardbank,\n fd_agpm_shoucardman as shoucardman,\n fd_agpm_shoucardmobile as shoucardmobile,\n fd_agpm_current as current,\n fd_agpm_paymoney as paymoney ,\n fd_agpm_payfee as payfee,\n fd_agpm_arrivemode as arrivemode,\n fd_agpm_arrivedate as arrivedate,\n fd_paycardaccount_accountname as accountname,\n fd_sdcr_agentfee as sdcragentfee,\n fd_agpm_isagentpay as isagentpay,\n fd_paycardaccount_accountnum as accountnum," . "fd_agpm_authorid as authorid\n from tb_paymoneylistdetail\n left join tb_agentpaymoneylist on fd_pymyltdetail_agpmid = fd_agpm_id\n left join tb_paycard on fd_agpm_paycardid = fd_paycard_id\n left join tb_author on fd_author_id = fd_agpm_authorid\n left join tb_paycardaccount on fd_paycard_paycardaccount = fd_paycardaccount_id\n left join tb_sendcenter on fd_sdcr_id = fd_agpm_sdcrid\n where fd_pymyltdetail_paymoneylistid = '{$listid}'\n order by fd_agpm_bkntno";
$db->query($query);
$arr_result = $db->getFiledData('');
foreach ($arr_result as $key => $value) {
switch ($value['paytypee']) {
case 'coupon':
$table = 'couponsale';
$where = 'couponsale';
break;
case 'creditcard':
$table = 'creditcardglist';
$where = 'ccglist';
break;
case 'recharge':
$table = 'rechargeglist';
$where = 'rechargelist';
$paymoney = $value['paymoney'];
$authorid = $value['authorid'];
$paytype = $value['paytypee'];
$bkordernumber = $value['bkordernumber'];
$query = "update tb_authoraccount set fd_acc_money = fd_acc_money-{$paymoney} where fd_acc_authorid = '{$authorid}'";
$db->query($query);
<?php
$thismenucode = "2k302";
require "../include/common.inc.php";
$db = new db_test();
$db2 = new db_test();
$db3 = new db_test();
$gotourl = $gourl . $tempurl;
$t = new Template(".", "keep");
$t->set_file("template", "payfeelist_view.html");
$arr_paytype = getauthorpaycardmenu();
$query = "select sum(fd_agpm_payfee) as allpayfee,sum(fd_agpm_payfee-fd_agpm_sdcrpayfeemoney-fd_agpm_sdcragentfeemoney) as allyingli from tb_agentpaymoneylist where fd_agpm_payrq='00' ";
$db->query($query);
$arr_data = $db->get_one($query);
$arr_text = array('刷卡器', '总手续费', '总利润额', "最后一次刷卡时间");
foreach ($arr_paytype as $value) {
$arr_text[] = $value;
}
$arr_text1 = array("手续费", "利润额");
for ($i = 0; $i < count($arr_text); $i++) {
$max = count($arr_text) - 1;
if (3 < $i) {
$colspan = "colspan=2";
foreach ($arr_text1 as $value) {
$theadth1 .= ' <th onclick="changeorderby(this,\'' . $i . '\')">' . $value . '</th>';
}
} else {
$colspan = "";
$theadth1 .= '<th onclick="changeorderby(this,\'' . $i . '\')"></th>';
}
$theadth .= ' <th ' . $colspan . '>' . $arr_text[$i] . '</th>';
