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

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

Web服务器

开发平台：

PHP

table_class_bill.php：源码内容
  1. <?php 
  2. session_start();
  3. include("checks.php");
  4. include("../inc/base_status.inc.php");
  5. if($down_type<>"all")
  6. {
  7. $sq=" and sign='$down_type'";
  8. }else $sq="";
  9. $sqlcs=mysql_query("select * from member_cut where user_account='admin' and sign<>'0' $sq order by sign asc",$conn);
  10. $_SESSION["menus"]="查看分类账";
  11. ?>
  12. <head>
  13. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  14. <link href="../css/css.CSS" rel="stylesheet" type="text/css">
  15. <title></title>
  16. <style type="text/css">
  17. <!--
  18. body {
  19. margin-left: 0px;
  20. }
  21. -->
  22. </style>
  23. </head>
  25. <body>
  26. <table width="100%" height="25" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#6a9bd8">
  27.   <tr>
  28.     <td width="9">&nbsp;</td>
  29.     <form name="form1">
  30.       <td width="492" height="20" class="fw12">代理商 报表管理(清单)</td>
  31.       <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>
  32.     </form>
  33.     <td width="10">&nbsp;</td>
  34.   </tr>
  35. </table><br><br>
  36. <table width="100%" height="123" border="0" cellpadding="2" cellspacing="1" class="t12">
  37.   <tr bgcolor="#B77700">
  38.     <td height="30" colspan="11" class="t11"><span class="fw12"> 日期范围：
  39.       <?=$start_time?>
  40.       到
  41.       <?=$end_time?> 期数：<?php if($date_num<>"no") echo "期数：<strong>".$date_num."</strong> 期";?>
  42.     报表种类：分类账 </span></td>
  43.   </tr>
  44.   <tr bgcolor="#456594">
  45.     <td width="109" rowspan="2"><div align="center" class="fw12">下注种类</div>      
  46.     <div align="center"></div></td>
  47.     <td width="57" rowspan="2"><div align="center" class="fw12">笔数</div>      <div align="center"></div></td>
  48.     <td width="109" rowspan="2"><div align="center" class="fw12">下注金额</div>      <div align="center"></div></td>
  49.     <td width="64" rowspan="2"><div align="center" class="fw12">会员</div>      <div align="center"></div></td>
  50.     <td width="76" rowspan="2" align="center" class="fw12">代理商</td>
  51.     <td width="76" rowspan="2" align="center" class="fw12">总代理</td>
  52.     <td width="76" rowspan="2" align="center" class="fw12"><div align="center" class="fw12"></div>
  53.     <div align="center">股东</div></td>
  54.     <td colspan="4"><div align="center"></div>      
  55.     <div align="center" class="fw12">管理员</div>    </td>
  56.   </tr>
  57.   <tr class="t19">
  58.     <td width="57" bgcolor="#456594"><div align="center" class="fw12">退水</div></td>
  59.     <td width="57" bgcolor="#456594"><div align="center" class="fw12">金额</div></td>
  60.     <td width="56" colspan="2" bgcolor="#456594"><div align="center" class="fw12">结果</div></td>
  61.   </tr> <?php 
  62.                 if($date_num=="no")
  63.                 {
  64.                 $sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
  65.                  }else $sq=" and drop_date='$date_num' ";
  66. $count_cuts=0;
  67. while($rowcs=mysql_fetch_array($sqlcs))
  68. { 
  69.   $cut_sign=$rowcs["sign"];
  70.   $sql=mysql_query("select * from drop_bill where cut_sign='$cut_sign' $sq ",$conn);
  71.     $bnum=0;
  72.     $drop_money=0;
  73. $user_win=0;
  74. $manage_cut=0;
  75. $manage_money=0;
  76. $agent_profit=0;
  77. $manage_result=0;
  78. $agent_submit=0;
  79. $all_agent_submit=0;
  80. $manage_cut=0;
  81. $manage_money=0;
  82. $manage_result=0;
  83. $all_agent_submit=0;
  84. $super_agent_submit=0;
  85.   while($rs=mysql_fetch_array($sql))
  86.   { $bnum++;
  87. $drop_money+=$rs["drop_money"];
  88. $user_win+=$rs["user_win"];
  89. $manage_cut+=$rs["manage_cut"];
  90. $manage_money+=$rs["manage_money"];
  91. $agent_profit+=$rs["agent_profit"];
  92. $manage_result+=$rs["manage_result"];
  93. $agent_submit+=$rs["agent_submit"];
  94. $all_agent_submit+=$rs["all_agent_submit"];
  95. $super_agent_submit+=$rs["super_agent_submit"];
  96.   }
  97.     $bnum_count+=$bnum;
  98.     $drop_money_count+=$drop_money;
  99. $user_win_count+=$user_win;
  100. $manage_cut_count+=$manage_cut;
  101. $manage_money_count+=$manage_money;
  102. $agent_profit_count+=$agent_profit;
  103. $manage_result_count+=$manage_result;
  104. $agent_submit_count+=$agent_submit;
  105. $all_agent_submit_count+=$all_agent_submit;
  106. $super_agent_submit_count+=$super_agent_submit;
  107. if($bnum>0)
  108. {?>
  109.   <tr class="t15">
  110.     <td height="24" nowrap><div align="left">
  111.       <? if($rowcs["cut_unit"]=="特码A")
  112.       { echo "特码";
  113.   }else echo $rowcs["cut_unit"];?>
  114.     </div></td>
  115.     <td align="right" nowrap><?=$bnum?></td>
  116.     <td align="right" nowrap><a href="table_class_bill_details.php?cutsign=<?=$cut_sign?>&dates=<?=$date_num?>&droptype=<?=$rowcs["cut_unit"]?>" class="ags"><?=$drop_money?></a></td>
  117.     <td align="right" nowrap><?=$user_win?></td>
  118.     <td align="center" nowrap><div align="right">
  119.       <?=$agent_submit?>
  120.     </div></td>
  121.     <td align="right" nowrap><?=$all_agent_submit?></td>
  122.     <td align="right" nowrap><?=$super_agent_submit?></td>
  123.     <td align="right" nowrap><?=$manage_cut?></td>
  124.     <td align="right" nowrap><?=$manage_money?></td>
  125.     <td colspan="2" align="right" nowrap><?=$manage_result?></td>
  126.   </tr><? }
  127.   }
  128.    ?>
  129.   <tr class="t13">
  130.     <td height="27" nowrap><div align="center"></div>      
  131.     <div align="right" class="fbback">总计:</div></td>
  132.     <td nowrap><div align="right" class="fbback">
  133.         <?=$bnum_count?>
  134.     </div></td>
  135.     <td nowrap><div align="right" class="fbback">
  136.         <?=$drop_money_count?>
  137.     </div></td>
  138.     <td nowrap><div align="right" class="fbback">
  139.         <?=$user_win_count?>
  140.     </div></td>
  141.     <td align="center" nowrap><div align="right"><span class="fbback">
  142.       <?=$agent_submit_count?>
  143.     </span></div></td>
  144.     <td align="right" nowrap><span class="fbback">
  145.       <?=$all_agent_submit_count?>
  146.     </span></td>
  147.     <td align="right" nowrap><span class="fbback">
  148.       <?=$super_agent_submit_count?>
  149.     </span></td>
  150.     <td nowrap><div align="right" class="fbback">
  151.         <?=$manage_cut_count?>
  152.     </div></td>
  153.     <td nowrap><div align="right" class="fbback">
  154.         <?=$manage_money_count?>
  155.     </div></td>
  156.     <td colspan="2" nowrap><div align="right" class="fbback">
  157.         <?=$manage_result_count?>
  158.     </div></td>
  159.   </tr>
  160. </table>
  161. </body>