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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 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. $_SESSION["menus"]="查看分类账";
  6. if($down_type<>"all")
  7. {
  8. $sq=" and sign='$down_type'";
  9. }else $sq="";
  10. $sqlcs=mysql_query("select * from member_cut where user_account='admin' and sign<>'0' $sq order by sign asc",$conn);
  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: 10px;
  20. }
  21. -->
  22. </style>
  23. </head>
  25. <body>
  26. <table width="693" border="0" align="left" cellpadding="0" cellspacing="0">
  27.   <tr bgcolor="#417dec">
  28.     <td width="9" height="35">&nbsp;</td>
  29.     <form name="form1">
  30.       <td width="492" 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><br>
  36. <table width="692" height="123" border="0" cellpadding="2" cellspacing="1" class="t12">
  37.   <tr>
  38.     <td height="30" colspan="9" bgcolor="#456594"><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 class="t11">
  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 colspan="3"><div align="center"></div>      
  52.     <div align="center" class="fw12">总代理</div>      
  53.     <div align="center"></div></td>
  54.     <td width="60" rowspan="2"><div align="center"></div>      
  55.     <div align="center" class="fw12">股东</div></td>
  56.   </tr>
  57.   <tr class="t19">
  58.     <td width="57" bgcolor="#666666"><div align="center" class="fw12">退水</div></td>
  59.     <td width="57" bgcolor="#666666"><div align="center" class="fw12">金额</div></td>
  60.     <td width="57" bgcolor="#666666"><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  all_agent='$all_agent' and cut_sign='$cut_sign' $sq ",$conn);
  71.     $bnum=0;
  72.     $drop_money=0;
  73. $user_win=0;
  74. $all_agent_cut=0;
  75. $all_agent_money=0;
  76. $agent_profit=0;
  77. $all_agent_result=0;
  78. $agent_submit=0;
  79. $all_agent_submit=0;
  80. $all_agent_cut=0;
  81. $all_agent_money=0;
  82. $all_agent_result=0;
  83. $all_agent_submit=0;
  84.   while($rs=mysql_fetch_array($sql))
  85.   { $bnum++;
  86. $drop_money+=$rs["drop_money"];
  87. $user_win+=$rs["user_win"];
  88. $all_agent_cut+=$rs["all_agent_cut"];
  89. $all_agent_money+=$rs["all_agent_money"];
  90. $agent_profit+=$rs["agent_profit"];
  91. $all_agent_result+=$rs["all_agent_result"];
  92. $agent_submit+=$rs["agent_submit"];
  93. $all_agent_submit+=$rs["all_agent_submit"];
  94.   }
  95.     $bnum_count+=$bnum;
  96.     $drop_money_count+=$drop_money;
  97. $user_win_count+=$user_win;
  98. $all_agent_cut_count+=$all_agent_cut;
  99. $all_agent_money_count+=$all_agent_money;
  100. $agent_profit_count+=$agent_profit;
  101. $all_agent_result_count+=$all_agent_result;
  102. $agent_submit_count+=$agent_submit;
  103. $all_agent_submit_count+=$all_agent_submit;
  104. if($bnum>0)
  105. {?>
  106.   <tr class="t15">
  107.     <td height="24"><div align="left">
  108.       <? if($rowcs["cut_unit"]=="特码A")
  109.   { 
  110.   echo "特码";
  111.   }else echo $rowcs["cut_unit"];
  112.   ?>
  113.     </div></td>
  114.     <td align="right"><?=$bnum?></td>
  115.     <td align="right"><a href="table_class_bill_details.php?cutsign=<?=$cut_sign?>&dates=<?=$date_num?>&droptype=<?=$rowcs["cut_unit"]?>" class="ags"><?=$drop_money?></a></td>
  116.     <td align="right"><?=$user_win?></td>
  117.     <td align="center"><div align="right">
  118.       <?=$agent_submit?>
  119.     </div></td>
  120.     <td align="right"><?=$all_agent_cut?></td>
  121.     <td align="right"><?=$all_agent_money?></td>
  122.     <td align="right"><?=$all_agent_result?></td>
  123.     <td align="right"> <?=$all_agent_submit?></td>
  124.   </tr><? }
  125.   }
  126.    ?>
  127.   <tr class="t13">
  128.     <td height="27" nowrap><div align="center"></div>      
  129.     <div align="right" class="fbback">总计:</div></td>
  130.     <td nowrap><div align="right" class="fbback">
  131.         <?=$bnum_count?>
  132.     </div></td>
  133.     <td nowrap><div align="right" class="fbback">
  134.         <?=$drop_money_count?>
  135.     </div></td>
  136.     <td nowrap><div align="right" class="fbback">
  137.         <?=$user_win_count?>
  138.     </div></td>
  139.     <td align="center" nowrap><div align="right"><span class="fbback">
  140.       <?=$agent_submit_count?>
  141.     </span></div></td>
  142.     <td nowrap><div align="right" class="fbback">
  143.         <?=$all_agent_cut_count?>
  144.     </div></td>
  145.     <td nowrap><div align="right" class="fbback">
  146.         <?=$all_agent_money_count?>
  147.     </div></td>
  148.     <td nowrap><div align="right" class="fbback">
  149.         <?=$all_agent_result_count?>
  150.     </div></td>
  151.     <td nowrap><div align="right" class="fbback"><?=$all_agent_submit_count?>
  152.     </div></td>
  153.   </tr>
  154. </table>
  155. </body>