Category

Development Platform
Home > SourceCode/Document > Internet-Socket-Network > Web Server > View Code
table_all.php
Package: Nsix.rar　[view]
Upload User: m68239277
Upload Date: 2014-10-12
Package Size: 824k
Code Size: 6k
Category:

Web Server

Development Platform:

PHP

table_all.php：Code Content
  1. <?php 
  2. session_start();
  3. include("checks.php");
  4. include("../inc/base_status.inc.php");
  5. $_SESSION["menus"]="查看报表总账";
  6. $sqla=mysql_query("select * from agent where all_agent='$all_agent'",$conn);  //read agent user
  7. ?>
  8. <head>
  9. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  10. <link href="../css/css.CSS" rel="stylesheet" type="text/css">
  11. <title></title>
  12. <style type="text/css">
  13. <!--
  14. body {
  15. margin-left: 10px;
  16. }
  17. -->
  18. </style>
  19. </head>
  21. <body>
  22. <table width="695" height="36" border="0" align="left" cellpadding="0" cellspacing="0">
  23.   <tr bgcolor="#417dec">
  24.     <td width="9" height="36">&nbsp;</td>
  25.     <form name="form1">
  26.       <td width="492" class="fw12">总代理 报表管理(清单)</td>
  27.       <td width="183" class="fw12"><div align="right"><a href="table.php" class="ah">查询</a>&nbsp;<a href="#" class="ah" onClick="document.execCommand('print','true','true')">列印</a>&nbsp;<a href="table.php" class="ah">返回上一页</a></div></td>
  28.     </form>
  29.     <td width="10">&nbsp;</td>
  30.   </tr>
  31. </table><br><br>
  32. <br>
  33. <table width="695" height="99" border="0" cellpadding="2" cellspacing="1" class="t12">
  34.   <tr bgcolor="#456594">
  35.     <td colspan="10"><span class="fw12"> 日期范围：<?=$start_time?> 到 <?=$end_time?> <?php if($date_num<>"no") echo "期数：<strong>".$date_num."</strong> 期";?> 报表种类：总账</span></td>
  36.   </tr>
  37.   <tr class="t11">
  38.     <td width="75" rowspan="2"><div align="center" class="fw12">代理商</div>      <div align="center"></div></td>
  39.     <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>
  40.     <td width="100" rowspan="2"><div align="center" class="fw12">下注金额</div>      <div align="center"></div></td>
  41.     <td width="69" rowspan="2"><div align="center" class="fw12">会员</div>      <div align="center"></div></td>
  42.     <td width="69" rowspan="2"><div align="center" class="fw12">代理商</div></td>
  43.     <td colspan="4"><div align="center"></div>      
  44.     <div align="center" class="fw12">总代理</div>      
  45.     <div align="center"></div>    <div align="center" class="fw12"></div>    </td>
  46.     <td width="73" rowspan="2"><div align="center"></div>      
  47.     <div align="center" class="fw12">股东</div></td>
  48.   </tr>
  49.   <tr class="t19">
  50.     <td width="52" align="center" class="fw12">退水</td>
  51.     <td width="54" align="center" class="fw12">金额</td>
  52.     <td width="51" align="center" class="fw12">占成</td>
  53.     <td width="44" align="center" class="fw12">结果</td>
  54.   </tr>
  55.   <?php
  56.        if($date_num=="no")
  57.    {
  58.      $sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
  59.    }else $sq=" and drop_date='$date_num' ";
  60.    while($rsp=mysql_fetch_array($sqla))
  61.     {
  62.  $agent=$rsp["user_account"]; 
  63.      $sql=mysql_query("select * from drop_bill where agent='$agent' $sq",$conn);
  64.     $bnum=0;
  65.     $drop_money=0;
  66. $user_win=0;
  67. $all_agent_cut=0;
  68. $all_agent_money=0;
  69. $all_agent_profit=0;
  70. $all_agent_result=0;
  71. $agent_submit=0;
  72. $all_agent_submit=0;
  73.  $bnum_count=0;
  74.   while($rs=mysql_fetch_array($sql))
  75.   { $bnum++;
  76. $drop_money+=$rs["drop_money"];
  77. $user_win+=$rs["user_win"];
  78. $agent_submit+=$rs["agent_submit"];
  79. $all_agent_cut+=$rs["all_agent_cut"];
  80. $all_agent_money+=$rs["all_agent_money"];
  81. $all_agent_profit=$rs["all_agent_profit"];
  82. $all_agent_result+=$rs["all_agent_result"];
  83. $all_agent_submit+=$rs["all_agent_submit"];
  84.   } $bnum_count+=$bnum;
  85.     $drop_money_count+=$drop_money;
  86. $user_win_count+=$user_win;
  87. $all_agent_cut_count+=$all_agent_cut;
  88. $all_agent_money_count+=$all_agent_money;
  89. $all_agent_result_count+=$all_agent_result;
  90. $agent_submit_count+=$agent_submit;
  91. $all_agent_submit_count+=$all_agent_submit;
  92.  if($bnum>0)
  93.  {
  94. ?>
  95.   <tr class="t15">
  96.     <td height="24"><div align="right"><?=$agent?></div></td>
  97.     <td><div align="right"></div>      
  98.       <div align="right"><?=$bnum?></div></td>
  99.     <td><div align="right"><a href="table_searchs.php?agent=<?=$agent?>" class="ags"><?=$drop_money?></a></div></td>
  100.     <td><div align="right">
  101.       <?=$user_win?>
  102.     </div></td>
  103.     <td align="right">
  104.       <?=$agent_submit?></td>
  105.     <td><div align="right">
  106.         <?=$all_agent_cut?>
  107.     </div></td>
  108.     <td><div align="right">
  109.         <?=$all_agent_money?>
  110.     </div></td>
  111.     <td><div align="right">
  112.         <?=$all_agent_profit?>
  113.     </div></td>
  114.     <td><div align="right">
  115.         <?=$all_agent_result?>
  116.     </div></td>
  117.     <td><div align="right">
  118.         <?=$all_agent_submit?>
  119.     </div></td>
  120.   </tr>
  121.   <?
  122.   }
  123.    }?>
  124.   <tr class="t13">
  125.     <td height="22" nowrap><div align="right" class="fbback">总计:</div></td>
  126.     <td nowrap><div align="right" class="fbback"><?=$bnum_count?></div></td>
  127.     <td nowrap><div align="right" class="fbback">
  128.       <?=$drop_money_count?>
  129. </div></td>
  130.     <td nowrap><div align="right" class="fbback">
  131.         <?=$user_win_count?>
  132.     </div></td>
  133.     <td nowrap><div align="right"><span class="fbback">
  134.       <?=$agent_submit_count?>
  135.     </span></div></td>
  136.     <td nowrap><div align="right" class="fbback">
  137.         <?=$all_agent_cut_count?>
  138.     </div></td>
  139.     <td nowrap><div align="right" class="fbback">
  140.         <?=$all_agent_money_count?>
  141.     </div></td>
  142.     <td nowrap>&nbsp;</td>
  143.     <td nowrap><div align="right" class="fbback">
  144.         <?=$all_agent_result_count?>
  145.     </div></td>
  146.     <td nowrap><div align="right" class="fbback">
  147.         <?=$all_agent_submit_count?>
  148.     </div></td>
  149.   </tr>
  150. </table>
  151. </body>