<?php require "../include/common.inc.php"; include "../include/pageft.php"; $db = new db_test(); $gourl = "authorpaycard_query.php"; $gotourl = $gourl . $tempurl; require "../include/alledit.1.php"; $t = new Template(".", "keep"); $t->set_file("authorpaycard", "authorpaycard.html"); $t->set_block("authorpaycard_query", "prolist", "prolists"); if (!empty($listid)) { // 编辑 $query = "select fd_agpm_bkntno as bkntno,\n\t\t\t\t count(fd_agpm_paycardid) as paynum,\t\t\n\t\t\t\t sum(fd_agpm_payfee) as payfee,\n\t\t\t\t sum(fd_agpm_sdcrpayfeemoney) as sdcrpayfeemoney,\n\t\t\t\t sum(fd_agpm_sdcragentfeemoney) as sdcragentfeemoney,\n\t\t\t\t fd_agpm_shoucardno as shoucardno,\n fd_agpm_shoucardbank as shoucardbank,\n\t\t\t\t fd_agpm_shoucardman as shoucardman,\n fd_agpm_shoucardmobile as shoucardmobile,\n\t\t\t\t fd_agpm_paytype as paytype,\n\t\t\t\t fd_agpm_paydate as paydate,\n\t\t\t\t fd_agpm_no as no,\n\t\t\t\t fd_agpm_id as agpmid,\t\n\t\t\t\t fd_author_truename as authorname,\n\t\t\t\t fd_paycard_key as paycardkey,\n\t\t\t\t fd_paycardtype_name as paycardtype,\n\t\t\t\t fd_paycard_scope as paycardscope,\n fd_agpm_paymoney as paymoney,\n\t\t\t\t fd_agpm_state as agpmstate,\n\t\t\t\t fd_paycard_batches as batches,\n\t\t\t\t fd_agpm_money as money,\n\t\t\t\t fd_agpm_paymoney as paymoney from tb_agentpaymoneylist \n\t\t\t\t left join tb_author on fd_author_id = fd_agpm_authorid\n\t\t\t\t left join tb_paycard on fd_paycard_id = fd_agpm_paycardid\n\t\t\t\t left join tb_paycardtype on fd_paycardtype_id=fd_paycard_paycardtypeid\n where fd_agpm_id ='{$listid}' group by fd_agpm_paycardid order by fd_agpm_no\n "; $db->query($query); $total = $db->num_rows($result); pageft($total, 20, $url); if ($firstcount < 0) { $firstcount = 0; } $query = "{$query} limit {$firstcount},{$displaypg}"; //echo $query; $db->query($query); $rows = $db->num_rows(); $arr_result = $db->getFiledData(''); foreach ($arr_result as $value) { $t->set_var($value); $cssy = $value[payfee] - $value[sdcrpayfeemoney] - $value[sdcragentfeemoney]; $t->parse("prolists", "prolist", true); } }