开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > Web服务器 > 查看源码
table_manage.php
资源名称：Nsix.rar　[点击查看]
上传用户：m68239277
上传日期：2014-10-12
资源大小：824k
文件大小：6k
源码类别：

Web服务器

开发平台：

PHP

table_manage.php：源码内容
  1. <?php 
  2. session_start();
  3. include("checks.php");
  4. $sqla=mysql_query("select * from super_agent ",$conn);  //read super_agent user
  5. $_SESSION["menus"]="查看股东报表";
  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: 0px;
  16. }
  17. -->
  18. </style>
  19. </head>
  21. <body>
  22. <table width="100%" height="25" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#6a9bd8">
  23.   <tr>
  24.     <td width="9">&nbsp;</td>
  25.     <form name="form1">
  26.       <td width="492" height="20" 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. <table width="100%" height="99" border="0" cellpadding="0" cellspacing="1" class="t12">
  33.   <tr>
  34.     <td colspan="11" class="t11"><span class="fw12"> 日期范围：<?=$start_time?> 到 <?=$end_time?> <?php if($date_num<>"no") echo "期数：<strong>".$date_num."</strong> 期";?> 报表种类：总账</span></td>
  35.   </tr>
  36.   <tr bgcolor="#456594">
  37.     <td width="69" rowspan="2"><div align="center" class="fw12">股东</div>      
  38.     <div align="center"></div></td>
  39.     <td width="53" 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="91" rowspan="2"><div align="center" class="fw12">下注金额</div>      <div align="center"></div></td>
  41.     <td width="63" rowspan="2"><div align="center" class="fw12">会员</div>      <div align="center"></div></td>
  42.     <td width="63" rowspan="2"><div align="center" class="fw12">代理商</div></td>
  43.     <td width="63" rowspan="2"><div align="center" class="fw12">总代理</div></td>
  44.     <td width="63" rowspan="2" align="center"><span class="fw12">股东</span></td>
  45.     <td colspan="4"><div align="center"></div>      
  46.     <div align="center" class="fw12"></div>      
  47.     <div align="center"></div>    
  48.     <div align="center" class="fw12">公司</div>    </td>
  49.   </tr>
  50.   <tr class="t19">
  51.     <td width="48" align="center" bgcolor="#456594" class="fw12">退水</td>
  52.     <td width="50" align="center" bgcolor="#456594" class="fw12">金额</td>
  53.     <td width="40" align="center" bgcolor="#456594" class="fw12">占成</td>
  54.     <td width="36" align="center" bgcolor="#456594" class="fw12">结果</td>
  55.   </tr>
  56.   <?php
  57.      if($date_num=="no")
  58.    {
  59.      $sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
  60.    }else $sq=" and drop_date='$date_num' ";
  61.    while($rsp=mysql_fetch_array($sqla))
  62.     {
  63.  $super_agents=$rsp["user_account"]; 
  64.      $sql=mysql_query("select * from drop_bill where super_agent='$super_agents' $sq",$conn);
  65.     $bnum=0;
  66.     $drop_money=0;
  67. $user_win=0;
  68. $manage_cut=0;
  69. $manage_money=0;
  70. $manage_profit=0;
  71. $manage_profit=0;
  72. $agent_submit=0;
  73. $all_agent_submit=0;
  74. $super_agent_submit_count=0;
  75.   while($rs=mysql_fetch_array($sql))
  76.   { $bnum++;
  77. $drop_money+=$rs["drop_money"];
  78. $user_win+=$rs["user_win"];
  79. $agent_submit+=$rs["agent_submit"];
  80. $manage_cut+=$rs["manage_cut"];
  81. $manage_money+=$rs["manage_money"];
  82. $manage_profit=$rs["manage_profit"];
  83. $manage_result+=$rs["manage_result"];
  84. $all_agent_submit+=$rs["all_agent_submit"];
  85. $super_agent_submit+=$rs["super_agent_submit"];
  86.   } $bnum_count+=$bnum;
  87.     $drop_money_count+=$drop_money;
  88. $user_win_count+=$user_win;
  89. $manage_cut_count+=$manage_cut;
  90. $manage_money_count+=$manage_money;
  91. $manage_profit_count+=$manage_profit;
  92. $manage_result_count+=$manage_result;
  93. $agent_submit_count+=$agent_submit;
  94. $all_agent_submit_count+=$all_agent_submit;
  95. $super_agent_submit_count+=$super_agent_submit;
  96.  if($bnum>0)
  97.  {
  98. ?>
  99.   <tr class="t15">
  100.     <td height="24"><div align="right"><?=$super_agents?></div></td>
  101.     <td><div align="right"></div>
  102.         <div align="right">
  103.           <?=$bnum?>
  104.       </div></td>
  105.     <td><div align="right"><a href="table_manage_searchs.php?agent=<?=$super_agents?>" class="ags">
  106.         <?=$drop_money?>
  107.     </a></div></td>
  108.     <td><div align="right">
  109.         <?=$user_win?>
  110.     </div></td>
  111.     <td align="right">
  112.       <?=$agent_submit?></td>
  113.     <td><div align="right">
  114.         <?=$all_agent_submit?>
  115.     </div></td>
  116.     <td><div align="right">
  117.         <?=$super_agent_submit?>
  118.     </div></td>
  119.     <td><div align="right">
  120.         <?=$manage_cut?>
  121.     </div></td>
  122.     <td><div align="right">
  123.         <?=$manage_money?>
  124.     </div></td>
  125.     <td><div align="right">
  126.         <?=$manage_profit?>
  127.     </div></td>
  128.     <td><div align="right">
  129.         <?=$manage_result?>
  130.     </div></td>
  131.   </tr>
  132.   <?
  133.   } 
  134.    }?>
  135.   <tr class="t13">
  136.     <td height="22" nowrap><div align="right" class="fbback">总计:</div></td>
  137.     <td nowrap><div align="right" class="fbback">
  138.         <?=$bnum_count?>
  139.     </div></td>
  140.     <td nowrap><div align="right" class="fbback">
  141.         <?=$drop_money_count?>
  142.     </div></td>
  143.     <td nowrap><div align="right" class="fbback">
  144.         <?=$user_win_count?>
  145.     </div></td>
  146.     <td nowrap><div align="right"><span class="fbback">
  147.         <?=$agent_submit_count?>
  148.     </span></div></td>
  149.     <td nowrap><div align="right" class="fbback">
  150.         <?=$all_agent_submit_count?>
  151.     </div></td>
  152.     <td nowrap><div align="right" class="fbback">
  153.         <?=$super_agent_submit_count?>
  154.     </div></td>
  155.     <td nowrap><div align="right" class="fbback">
  156.         <?=$manage_cut_count?>
  157.     </div></td>
  158.     <td nowrap><div align="right" class="fbback">
  159.         <?=$manage_money_count?>
  160.     </div></td>
  161.     <td nowrap>&nbsp;</td>
  162.     <td nowrap class="t10"><div align="right" class="fbback">
  163.         <?=$manage_result_count?>
  164.     </div></td>
  165.   </tr>
  166. </table>
  167. </body>