Web服务器

开发平台：
PHP

table_all_bill_details.php：源码内容
							<?php 
session_start();
include("../inc/conn.php");
include("checks.php");
$agent=$_SESSION["agent"];
$date_num=$_SESSION["date_num"];
$start_time=$_SESSION["start_time"];
$end_time=$_SESSION["end_time"];
include("../inc/base_status.inc.php");
if(isset($_GET["user"]))
{
  $users=$_GET["user"];
  $dates=$_GET["dates"];
  $_SESSION["duser"]=$users;
  $_SESSION["ddates"]=$dates;
}else
{
  $users=$_SESSION["duser"];
  $dates=$_SESSION["ddates"];
}
$_SESSION["menus"]="查看$users会员下注清单";
 if($date_num=="no")
 {
  $deleted=0;
  $sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
  }else
  { $sq=" and drop_date='$dates'";
$sqlp=mysql_query("select * from results where dates='$dates'",$conn);
$deleted=mysql_result($sqlp,0,"deleted");
}
$pagesize=500;
$sqlc=mysql_query("select count(*) from drop_bill where user_name='$users' $sq",$conn);
$myrow=mysql_fetch_array($sqlc);
$numrows=$myrow[0];
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize) $pages++;
if (isset($_GET['page'])) 
{ 
$page=intval($_GET['page']);
}
else{
$page=1;
}
$offset=$pagesize*($page - 1); 
$sql=mysql_query("select * from drop_bill where user_name='$users' $sq order by ID desc limit $offset,$pagesize",$conn); 
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/css.CSS" rel="stylesheet" type="text/css">
<title></title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="100%" height="25" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#6a9bd8">
  <tr>
    <td width="9">&nbsp;</td>
    <form name="form1">
      <td width="556" height="20" class="fw12">下注清单</td>
      <td width="206" class="fw12"><div align="right">&nbsp;<a href="#" class="ah" onClick="document.execCommand('print','true','true')">列印</a>&nbsp;<a href="table_searchs.php?agent=<?=$agent?>"  class="ah">返回上一页</a></div></td>
    </form>
    <td width="13">&nbsp;</td>
  </tr>
</table><br><br>
<table width="97%" height="100" border="0" cellpadding="5" cellspacing="1" class="t12">
  <tr bgcolor="#456594">
    <td height="25"><div align="center" class="fw12">单号/时间</div></td>
    <td><div align="center" class="fw12">账号</div></td>
    <td><div align="center" class="fw12">名称</div>      <div align="center"></div></td>
    <td><div align="center" class="fw12">退水</div>      <div align="center"></div></td>
    <td><div align="center" class="fw12">盘类/下注期数</div>      <div align="center"></div></td>
    <td><div align="center" class="fw12">下注内容</div>      <div align="center"></div></td>
    <td><div align="center"></div>      
    <div align="center" class="fw12">赔率</div>      <div align="center"></div>    <div align="center" class="fw12"></div>    </td>
    <td><div align="center" class="fw12">下注金额</div></td>
    <td><div align="center" class="fw12">退水</div></td>
    <td><div align="center" class="fw12">结果</div></td>
  </tr><?php 
  //$win_count=0;
  $winp=0;
  $win_count=0;
  while($rs=mysql_fetch_array($sql))
  { 
     $uname=$rs["user_name"];
     $sqlname=mysql_query("select * from member where user_account='$uname'",$conn);
	 $username=mysql_result($sqlname,0,"user_name");
	 $drop_money=$rs["drop_money"];
	 $money_count+=$rs["drop_money"];
	 $num_sign=$rs["num_sign"];
	 $user_win=$rs["user_win"];
	 $drop_content=$rs["drop_content"];
	 $drop_type=$rs["drop_type"];
	 $drop_details=$rs["drop_details"];
	 $dates=$rs["drop_date"];
	 $drop_rate=$rs["drop_rate"];
	 $cuts=$rs["drop_money"]*str_replace("&nbsp;","",$rs["drop_cut"])*0.01;
	 $cut_count+=$cuts;
	 $win_count+=$user_win;
  ?>
  <tr class="t15">
    <td height="26"><div align="right"><span class="fgreng"><?=$rs["ID"]?></span> <?=substr($rs["drop_time"],5)?></div>
        <div align="center"></div></td>
    <td><div align="right"><?=$rs["user_name"]?></div></td>
    <td><div align="right"><?=$username?></div></td>
    <td><div align="right"><?=$rs["drop_cut"]?></div></td>
    <td><div align="right"><?=$rs["drop_plate"]?>盘/<?=$rs["drop_date"]?> <span class="fgreng"><?=substr($rs["open_date"],5)?></span> </div></td>
    <td><div align="right"><?=$drop_type?> <?=$rs["drop_content"]?>  <?php if($rs["drop_details"]<>"0") echo $rs["drop_details"]?></div></td>
    <td><div align="right"><?=$drop_rate?></div></td>
    <td><div align="right"><?=$drop_money?></div></td>
    <td><div align="right">
	<?=$cuts?></div></td>
    <td><div align="right">
	  <? 
	  if($user_win>0)
	  { echo "<font color='red'>".$user_win."</font>";
	  }else echo $user_win;
	  ?>
    </div></td>
  </tr><? }?>
  <tr class="t13">
    <td height="22" colspan="7" nowrap><div align="right"><span class="fbback">总计:</span></div></td>
    <td nowrap><div align="right" class="fbback"><?=$money_count?></div></td>
    <td nowrap><div align="right"><strong><?=$cut_count?></strong></div></td>
    <td nowrap><div align="right" class="fbback"><?=$win_count?></div></td>
  </tr>
  <tr >
    <td height="22" colspan="10" class="t11"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <form name="form1">
                    <td>　<? 
$fp="table_all_bill_details.php";					
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{
echo "<a href='".$fp."?page=".$first."' class='aw'>第一页</a>&nbsp;&nbsp;";
echo "<a href='".$fp."?page=".$prev."' class='aw'>上一页</a>&nbsp;&nbsp;";
}else
{
 echo "<font color='#ffffff'>第一页&nbsp;&nbsp;上一页</font>&nbsp;&nbsp;";
}
if ($page<$pages)
{
echo "<a href='".$fp."?page=".$next."' class='aw'>下一页</a>&nbsp;&nbsp;";
echo "<a href='".$fp."?page=".$last."' class='aw'>最终页</a>&nbsp;&nbsp;";
} else
{
 echo "<font color='#ffffff'>下一页&nbsp;&nbsp;最终页</font>&nbsp;&nbsp;";
}
$nums=$pagesize*$pages;
?><span class="fw12"> 页次：</span>
                      <select name="menu1" onChange="MM_jumpMenu('self',this,0)">
                        <?php for ($i=1;$i<=$pages;$i++) 
						{
						if($page==$i)
						{ $se="selected";
						}else $se="";
						
                       echo "<option value='".$fp."?page=".$i."' ".$se.">".$i."</option>"; 
					   }
				        ?>
                      </select>
</td>
                  </form>
                  <td><div align="right"><span class="fw12">共 <strong><?=$pages?></strong> 页</span><span class="fw12">&nbsp;&nbsp;</span></div></td>
                </tr>
              </table></td>
  </tr>
</table>
</body>

						