📄 table_all.php
字号:
<?php
session_start();
include("checks.php");
include("../inc/base_status.inc.php");
$_SESSION["menus"]="查看$all_agent总代理报表";
$sqla=mysql_query("select * from agent where all_agent='$all_agent'",$conn); //read agent user
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/css.CSS" rel="stylesheet" type="text/css">
<title></title>
<style type="text/css">
<!--
body {
margin-left: 0px;
}
-->
</style>
</head>
<body>
<table width="100%" height="25" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#6A9BD8">
<tr>
<td width="9"> </td>
<form name="form1">
<td width="492" class="fw12">总代理 报表管理(清单)</td>
<td width="183" class="fw12"><div align="right"><a href="table.php" class="ah">查询</a> <a href="#" class="ah" onClick="document.execCommand('print','true','true')">列印</a> <a href="table_super_search.php" class="ah">返回上一页</a></div></td>
</form>
<td width="10"> </td>
</tr>
</table><br>
<br>
<table width="100%" height="99" border="0" cellpadding="2" cellspacing="1" class="t12">
<tr>
<td colspan="10" class="t11"><span class="fw12"> 日期范围：<?=$start_time?> 到 <?=$end_time?> <?php if($date_num<>"no") echo "期数：<strong>".$date_num."</strong> 期";?> 报表种类：总账</span></td>
</tr>
<tr bgcolor="#456594">
<td width="75" rowspan="2"><div align="center" class="fw12">代理商</div> <div align="center"></div></td>
<td width="57" rowspan="2"><div align="center" class="fw12">笔数</div> <div align="center"></div> <div align="center" class="fw12"></div> <div align="center"></div></td>
<td width="100" rowspan="2"><div align="center" class="fw12">下注金额</div> <div align="center"></div></td>
<td width="69" rowspan="2"><div align="center" class="fw12">会员</div> <div align="center"></div></td>
<td width="69" rowspan="2"><div align="center" class="fw12">代理商</div></td>
<td colspan="4"><div align="center"></div>
<div align="center" class="fw12">总代理</div>
<div align="center"></div> <div align="center" class="fw12"></div> </td>
<td width="73" rowspan="2"><div align="center"></div>
<div align="center" class="fw12">股东</div></td>
</tr>
<tr class="t19">
<td width="52" align="center" bgcolor="#456594" class="fw12">退水</td>
<td width="54" align="center" bgcolor="#456594" class="fw12">金额</td>
<td width="51" align="center" bgcolor="#456594" class="fw12">占成</td>
<td width="44" align="center" bgcolor="#456594" class="fw12">结果</td>
</tr>
<?php
if($date_num=="no")
{
$sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
}else $sq=" and drop_date='$date_num' ";
while($rsp=mysql_fetch_array($sqla))
{
$agent=$rsp["user_account"];
$sql=mysql_query("select * from drop_bill where agent='$agent' $sq",$conn);
$bnum=0;
$drop_money=0;
$user_win=0;
$all_agent_cut=0;
$all_agent_money=0;
$all_agent_profit=0;
$all_agent_result=0;
$agent_submit=0;
$all_agent_submit=0;
$bnum_count=0;
while($rs=mysql_fetch_array($sql))
{ $bnum++;
$drop_money+=$rs["drop_money"];
$user_win+=$rs["user_win"];
$agent_submit+=$rs["agent_submit"];
$all_agent_cut+=$rs["all_agent_cut"];
$all_agent_money+=$rs["all_agent_money"];
$all_agent_profit=$rs["all_agent_profit"];
$all_agent_result+=$rs["all_agent_result"];
$all_agent_submit+=$rs["all_agent_submit"];
} $bnum_count+=$bnum;
$drop_money_count+=$drop_money;
$user_win_count+=$user_win;
$all_agent_cut_count+=$all_agent_cut;
$all_agent_money_count+=$all_agent_money;
$all_agent_result_count+=$all_agent_result;
$agent_submit_count+=$agent_submit;
$all_agent_submit_count+=$all_agent_submit;
if($bnum>0)
{
?>
<tr class="t15">
<td height="24"><div align="right"><?=$agent?></div></td>
<td><div align="right"></div>
<div align="right"><?=$bnum?></div></td>
<td><div align="right"><a href="table_searchs.php?agent=<?=$agent?>" class="ags"><?=$drop_money?></a></div></td>
<td><div align="right">
<?=$user_win?>
</div></td>
<td align="right">
<?=$agent_submit?></td>
<td><div align="right">
<?=$all_agent_cut?>
</div></td>
<td><div align="right">
<?=$all_agent_money?>
</div></td>
<td><div align="right">
<?=$all_agent_profit?>
</div></td>
<td><div align="right">
<?=$all_agent_result?>
</div></td>
<td><div align="right">
<?=$all_agent_submit?>
</div></td>
</tr>
<?
}
}?>
<tr class="t13">
<td height="22" nowrap><div align="right" class="fbback">总计:</div></td>
<td nowrap><div align="right" class="fbback"><?=$bnum_count?></div></td>
<td nowrap><div align="right" class="fbback">
<?=$drop_money_count?>
</div></td>
<td nowrap><div align="right" class="fbback">
<?=$user_win_count?>
</div></td>
<td nowrap><div align="right"><span class="fbback">
<?=$agent_submit_count?>
</span></div></td>
<td nowrap><div align="right" class="fbback">
<?=$all_agent_cut_count?>
</div></td>
<td nowrap><div align="right" class="fbback">
<?=$all_agent_money_count?>
</div></td>
<td nowrap> </td>
<td nowrap><div align="right" class="fbback">
<?=$all_agent_result_count?>
</div></td>
<td nowrap><div align="right" class="fbback">
<?=$all_agent_submit_count?>
</div></td>
</tr>
</table>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -