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

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

Web服务器

开发平台：

PHP

table_all_bill.php：源码内容
  1. <?php 
  2. session_start();
  3. include("checks.php");
  4. include("../inc/base_status.inc.php");
  5. $sqluser=mysql_query("select * from member where agent='$agent' order by id desc",$conn);
  6. $_SESSION["menus"]="查看$agent代理商报表";
  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" 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_search.php" class="ah">返回上一页</a></div></td>
  28.     </form>
  29.     <td width="10">&nbsp;</td>
  30.   </tr>
  31. </table><br>
  32. <br>
  33. <table width="100%" height="119" border="0" cellpadding="2" cellspacing="1" class="t12">
  34.   <tr>
  35.     <td height="30" colspan="10" class="t11"><span class="fw12"> 日期范围：<?=$start_time?> 到 <?=$end_time?> <?php if($date_num<>"no") echo "期数：<strong>".$date_num."</strong> 期";?> 报表种类：总账</span></td>
  36.   </tr>
  37.   <tr bgcolor="#456594">
  38.     <td rowspan="2"><div align="center" class="fw12">会员账号</div>      <div align="center"></div></td>
  39.     <td rowspan="2"><div align="center" class="fw12">会员名称</div>      <div align="center"></div></td>
  40.     <td rowspan="2"><div align="center" class="fw12">笔数</div>      <div align="center"></div></td>
  41.     <td rowspan="2"><div align="center" class="fw12">下注金额</div>      <div align="center"></div></td>
  42.     <td rowspan="2"><div align="center" class="fw12">会员</div>      <div align="center"></div></td>
  43.     <td colspan="4"><div align="center"></div>      
  44.     <div align="center" class="fw12">代理商</div>      <div align="center"></div></td>
  45.     <td rowspan="2"><div align="center"></div>      
  46.     <div align="center" class="fw12">总代理</div></td>
  47.   </tr>
  48.   <tr class="t19">
  49.     <td bgcolor="#456594"><div align="center" class="fw12">退水</div></td>
  50.     <td bgcolor="#456594"><div align="center" class="fw12">金额</div></td>
  51.     <td bgcolor="#456594"><div align="center" class="fw12">占成</div></td>
  52.     <td bgcolor="#456594"><div align="center" class="fw12">结果</div></td>
  53.   </tr><?php 
  54.        if($date_num=="no")
  55.    {
  56.      $sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
  57.    }else $sq=" and drop_date='$date_num' ";
  58.    while($rsp=mysql_fetch_array($sqluser))
  59.    { 
  60.     $user_account=$rsp["user_account"];
  61.     $sql=mysql_query("select * from drop_bill where user_name='$user_account' $sq",$conn);
  62.     $bnum=0;
  63.     $drop_money=0;
  64. $user_win=0;
  65. $agent_cut=0;
  66. $agent_money=0;
  67. $agent_profit=0;
  68. $agent_result=0;
  69. $agent_submit=0;
  70.   while($rs=mysql_fetch_array($sql))
  71.   { $bnum++;
  72. $drop_money+=$rs["drop_money"];
  73. $user_win+=$rs["user_win"];
  74. $agent_cut+=$rs["agent_cut"];
  75. $agent_money+=$rs["agent_money"];
  76. $agent_profit=$rs["agent_profit"];
  77. $agent_result+=$rs["agent_result"];
  78. $agent_submit+=$rs["agent_submit"];
  79.   } $bnum_count+=$bnum;
  80.     $drop_money_count+=$drop_money;
  81. $user_win_count+=$user_win;
  82. $agent_cut_count+=$agent_cut;
  83. $agent_money_count+=$agent_money;
  84. $agent_profit_count+=$agent_profit;
  85. $agent_result_count+=$agent_result;
  86. $agent_submit_count+=$agent_submit;
  87. if($bnum>0)
  88. {
  89.    ?>
  90.   <tr class="t15">
  91.     <td><div align="right"><?=$user_account?></div></td>
  92.     <td><div align="right"><?=$rsp["user_name"]?></div></td>
  93.     <td align="right"><?=$bnum?></td>
  94.     <td><div align="right"><a href="table_all_bill_details.php?user=<?=$user_account?>&dates=<?=$date_num?>" class="ags"><?=$drop_money?></a></div></td>
  95.     <td><div align="right"><?=$user_win?></div></td>
  96.     <td><div align="right"><?=$agent_cut?></div></td>
  97.     <td><div align="right">
  98.       <?=$agent_money?>
  99.     </div></td>
  100.     <td><div align="right"><?=$agent_profit?></div></td>
  101.     <td><div align="right">
  102.   <?=$agent_result?>
  103.     </div></td>
  104.     <td><div align="right">
  105.       <?=$agent_submit?>
  106. </div></td>
  107.   </tr><? 
  108.        }
  109.   } ?>
  110.   <tr class="t13">
  111.     <td colspan="2" nowrap><div align="right" class="fbback">总计:</div></td>
  112.     <td nowrap><div align="right" class="fbback"><?=$bnum_count?></div></td>
  113.     <td nowrap><div align="right" class="fbback"><?=$drop_money_count?></div></td>
  114.     <td nowrap><div align="right" class="fbback"><?=$user_win_count?></div></td>
  115.     <td nowrap><div align="right" class="fbback"><?=$agent_cut_count?></div></td>
  116.     <td nowrap><div align="right" class="fbback"><?=$agent_money_count?></div></td>
  117.     <td nowrap><div align="right"></div></td>
  118.     <td nowrap><div align="right" class="fbback"><?=$agent_result_count?></div></td>
  119.     <td nowrap><div align="right" class="fbback"><?=$agent_submit_count?></div></td>
  120.   </tr>
  121. </table>
  122. </body>