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

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

Web服务器

开发平台：

PHP

table_class_bill_details.php：源码内容
  1. <?php 
  2. session_start();
  3. include("../inc/conn.php");
  4. include("checks.php");
  5. $all_agent=$_SESSION["all_agent"];
  6. $date_num=$_SESSION["date_num"];
  7. $start_time=$_SESSION["start_time"];
  8. $end_time=$_SESSION["end_time"];
  9. $_SESSION["menus"]="查看分类账细节";
  10. include("../inc/win_unit.php");
  11. include("../inc/base_status.inc.php");
  12. if(isset($_GET["cutsign"]))
  13. {
  14.   $droptype=$_GET["droptype"];
  15.   $cut_sign=$_GET["cutsign"];
  16.   $dates=$_GET["dates"];
  17.   $_SESSION["droptype"]=$droptype;
  18.   $_SESSION["cutsign"]=$cut_sign;
  19.   $_SESSION["ddates"]=$dates;
  20. }else
  21. {
  22.  $droptype=$_SESSION["droptype"];
  23.   $cut_sign=$_SESSION["cutsign"];
  24.   $dates=$_SESSION["ddates"];
  25. }
  26. if($date_num=="no")
  27. {
  28. $sq=" and drop_time>='$start_time' and drop_time<='$end_time' and all_agent='$all_agent'";
  29. }else $sq=" and drop_date='$dates' and all_agent='$all_agent'";
  30. $pagesize=200;
  31. $sqlc=mysql_query("select count(*) from drop_bill where cut_sign='$cut_sign'  $sq ",$conn);
  32. $myrow=mysql_fetch_array($sqlc);
  33. $numrows=$myrow[0];
  34. $pages=intval($numrows/$pagesize);
  35. if ($numrows%$pagesize) $pages++;
  36. if (isset($_GET['page'])) 
  37. { 
  38. $page=intval($_GET['page']);
  39. }
  40. else{
  41. $page=1;
  42. }
  43. $offset=$pagesize*($page - 1); 
  44. $sql=mysql_query("select * from drop_bill where cut_sign='$cut_sign'  $sq order by drop_time desc limit $offset,$pagesize",$conn); 
  45. ?>
  46. <head>
  47. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  48. <link href="../css/css.CSS" rel="stylesheet" type="text/css">
  49. <title></title>
  50. <style type="text/css">
  51. <!--
  52. body {
  53. margin-left: 10px;
  54. }
  55. -->
  56. </style>
  57. <script language="JavaScript" type="text/JavaScript">
  58. <!--
  59. function MM_jumpMenu(targ,selObj,restore){ //v3.0
  60.   eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  61.   if (restore) selObj.selectedIndex=0;
  62. }
  63. //-->
  64. </script>
  65. </head>
  67. <body>
  68. <table width="779" border="0" align="left" cellpadding="0" cellspacing="0">
  69.   <tr bgcolor="#417dec">
  70.     <td width="9" height="33">&nbsp;</td>
  71.     <form name="form1">
  72.       <td width="556" class="fw12">下注清单 (
  73.   <? if($droptype=="特码A")
  74.   { echo "特码";
  75.   }else echo $droptype;?>)</td>
  76.       <td width="206" class="fw12"><div align="right">&nbsp;<a href="#" class="ah" onClick="document.execCommand('print','true','true')">列印</a>&nbsp;<a href="table_search.php"  class="ah">返回上一页</a></div></td>
  77.     </form>
  78.     <td width="10">&nbsp;</td>
  79.   </tr>
  80. </table><br><br><br>
  81. <table width="779" height="100" border="0" cellpadding="2" cellspacing="1" class="t12">
  82.   <tr class="t11">
  83.     <td width="123" height="25"><div align="center" class="fw12">单号/时间</div></td>
  84.     <td width="66"><div align="center" class="fw12">账号</div></td>
  85.     <td width="66"><div align="center" class="fw12">名称</div>      <div align="center"></div></td>
  86.     <td width="47"><div align="center" class="fw12">退水</div>      <div align="center"></div></td>
  87.     <td width="100"><div align="center" class="fw12">盘类/下注期数</div>      <div align="center"></div></td>
  88.     <td width="69"><div align="center" class="fw12">下注内容</div>      <div align="center"></div></td>
  89.     <td width="68"><div align="center"></div>      
  90.     <div align="center" class="fw12">赔率</div>      <div align="center"></div>    <div align="center" class="fw12"></div>    </td>
  91.     <td width="79"><div align="center" class="fw12">下注金额</div></td>
  92.     <td width="51"><div align="center" class="fw12">退水</div></td>
  93.     <td width="53"><div align="center" class="fw12">结果</div></td>
  94.   </tr><?php while($rs=mysql_fetch_array($sql))
  95.   {  $cuts=0;
  96.      $uname=$rs["user_name"];
  97.      $sqlname=mysql_query("select * from member where user_account='$uname'",$conn);
  98.  $username=mysql_result($sqlname,0,"user_name");
  99.  $money_count+=$rs["drop_money"];
  100.  $drop_money=$rs["drop_money"];
  101.  $num_sign=$rs["num_sign"];
  102.  $drop_content=$rs["drop_content"];
  103.  $drop_type=$rs["drop_type"];
  104.  $drop_details=$rs["drop_details"];
  105.  $dates=$rs["drop_date"];
  106.  $drop_rate=$rs["drop_rate"];
  107.  $cuts=$rs["drop_money"]*$rs["drop_cut"]*0.01;
  108.  $user_win=$rs["user_win"];
  109.  $user_win_count+=$user_win;
  110.  $cut_count+=$cuts;
  111.   ?>
  112.   <tr class="t15">
  113.     <td height="26"><div align="right"><span class="fgreng"><?=$rs["ID"]?></span> <?=substr($rs["drop_time"],5)?></div>
  114.         <div align="center"></div></td>
  115.     <td><div align="right"><?=$rs["user_name"]?></div></td>
  116.     <td><div align="right"><?=$username?></div></td>
  117.     <td><div align="right"><?=$rs["drop_cut"]?></div></td>
  118.     <td><div align="right"><?=$rs["drop_plate"]?>盘/<?=$rs["drop_date"]?> <span class="fgreng"><?=substr($rs["open_date"],5)?></span> </div></td>
  119.     <td><div align="right"><?=$rs["drop_type"]?> <?=$rs["drop_content"]?>
  120.       <?php if($rs["drop_details"]<>"0") echo $rs["drop_details"]?></div></td>
  121.     <td><div align="right"><?=$rs["drop_rate"]?></div></td>
  122.     <td><div align="right">
  123. <?php $mcount=$rs["drop_money"];
  124. $mcounts+=$mcount;
  125. echo $mcount;?></div></td>
  126.     <td><div align="right">
  127. <?php $cuts=$rs["drop_money"]*$rs["drop_cut"]*0.01;
  128.   $ccounts+=$cuts;
  129.   echo $cuts; ?></div></td>
  130.     <td><div align="right"><?=$user_win?></div></td>
  131.   </tr><? }?>
  132.   <tr class="t13">
  133.     <td height="22" colspan="7" nowrap><div align="right"><span class="fbback">总计:</span></div></td>
  134.     <td nowrap><div align="right" class="fbback"><?=$mcounts?></div></td>
  135.     <td nowrap><div align="right"><strong><?=$ccounts?></strong></div></td>
  136.     <td nowrap><div align="right" >
  137. <?=$user_win_count?></div></td>
  138.   </tr>
  139.   <tr >
  140.     <td height="22" colspan="10" class="t11"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  141.                 <tr>
  142.                   <form name="form1">
  143.                     <td>　<? 
  144. $fp="table_class_bill_details.php";
  145. $first=1;
  146. $prev=$page-1;
  147. $next=$page+1;
  148. $last=$pages;
  149. if ($page>1)
  150. {
  151. echo "<a href='".$fp."?page=".$first."' class='aw'>第一页</a>&nbsp;&nbsp;";
  152. echo "<a href='".$fp."?page=".$prev."' class='aw'>上一页</a>&nbsp;&nbsp;";
  153. }else
  154. {
  155.  echo "<font color='#ffffff'>第一页&nbsp;&nbsp;上一页</font>&nbsp;&nbsp;";
  156. }
  157. if ($page<$pages)
  158. {
  159. echo "<a href='".$fp."?page=".$next."' class='aw'>下一页</a>&nbsp;&nbsp;";
  160. echo "<a href='".$fp."?page=".$last."' class='aw'>最终页</a>&nbsp;&nbsp;";
  161. } else
  162. {
  163.  echo "<font color='#ffffff'>下一页&nbsp;&nbsp;最终页</font>&nbsp;&nbsp;";
  164. }
  165. $nums=$pagesize*$pages;
  166. ?><span class="fw12"> 页次：</span>
  167.                       <select name="menu1" onChange="MM_jumpMenu('self',this,0)">
  168.                         <?php for ($i=1;$i<=$pages;$i++) 
  169. {
  170. if($page==$i)
  171. { $se="selected";
  172. }else $se="";
  174.                        echo "<option value='".$fp."?page=".$i."' ".$se.">".$i."</option>"; 
  175.    }
  176.         ?>
  177.                       </select>
  178. </td>
  179.                   </form>
  180.                   <td><div align="right"><span class="fw12">共 <strong><?=$pages?></strong> 页</span><span class="fw12">&nbsp;&nbsp;</span></div></td>
  181.                 </tr>
  182.               </table></td>
  183.   </tr>
  184. </table>
  185. </body>