uold_details.php

来自「程序脚本为PHP+MYSQL」· PHP 代码 · 共 169 行

<?php 
session_start();
$user=$_SESSION["user"];
include("../inc/conn.php");
include("../inc/base_status.inc.php");
include("../inc/drop_date.inc.php");
include("../inc/win_unit.php");
if(isset($_GET["dates"]))
{
  $dates=$_GET["dates"];
  $_SESSION["ddates"]=$dates;
}else
{
  $dates=$_SESSION["ddates"];
}
$sqlp=mysql_query("select * from results where dates='$dates'",$conn);
$deleted=mysql_result($sqlp,0,"deleted");
$pagesize=100;
$sqlc=mysql_query("select count(*) from drop_bill where drop_date='$dates' and user_name='$user'",$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 drop_date='$dates' and user_name='$user' order by drop_time desc limit $offset,$pagesize",$conn); 
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/css2.CSS" rel="stylesheet" type="text/css">
<title></title>
<style type="text/css">
<!--
body {
	margin-left: 10px;
	background-color: #e8e8e8;
}
-->
</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="90%" border="0" align="center" cellpadding="0" cellspacing="0">

    <tr>
      <td width="11" valign="top" background="../img2/skin11_09.png"><img src="../img2/skin11_03.png" width="11" height="38" /></td>
      <td valign="bottom" background="../img2/skin11_04.png"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="20"><div align="center"><strong>历史下注明细</strong></div></td>
        </tr>
      </table></td>
      <td width="11" valign="top" background="../img2/skin11_11.png"><img src="../img2/skin11_06.png" width="11" height="38" /></td>
    </tr>
    <tr>
      <td background="../img2/skin11_09.png">&nbsp;</td>
      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><table width="100%" height="20" border="0" cellpadding="0" cellspacing="0" class="t12">
          <tr>
            <td width="400" height="19" class="fw12">会员：
                <?=$_SESSION["user"]?>
      　　　　　　　　　　　期数：<span class="fhhh"><strong>
      <?=$dates?>
      </strong></span></td>
            <td width="126" align="right" class="fw12"><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>
              <span class="fb12">页/<?=$pages?>页</span></td>
          </tr>
        </table></td>
        </tr>
        <tr>
          <td><table width="100%" border="0" cellpadding="1" cellspacing="1">
  <tr class="t21">
    <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
   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");
	 $money_count+=$rs["drop_money"];
     $cuts=$rs["drop_money"]*$rs["drop_cut"]*0.01;
	 $cut_count+=$cuts;
	 $win=$rs["user_win"];
	 $wins+=$win;
	 $nums++;
  ?>
  <tr class="t17">
    <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"><? echo $rs["drop_cut"]?></div></td>
    <td nowrap><div align="right"><?=$rs["drop_plate"]?>盘/<?=$rs["drop_date"]?> <span class="fgreng"><?=substr($rs["open_date"],5)?></span> </div></td>
    <td><div align="right"><?=$rs["drop_type"]?> <?=$rs["drop_content"]?>
	<? if($rs["drop_details"]<>"0") echo $rs["drop_details"];?></div></td>
    <td><div align="right"><?=$rs["drop_rate"]?></div></td>
    <td><div align="right"><?=$rs["drop_money"]?></div></td>
    <td><div align="right">
	<?=$cuts?></div></td>
    <td><div align="right">
	<?=$win?></div></td>
  </tr><? }?>
  <tr class="t13">
    <td height="22" colspan="7"><div align="right"><span class="fbback">总计:</span></div></td>
    <td><div align="right" class="fbback"><?=$money_count?></div></td>
    <td><div align="right"><strong><?=$cut_count?></strong></div></td>
    <td><div align="right" class="fbback"><?=$wins?></div></td>
  </tr>
  <tr class="t20" >
    <td height="22" colspan="10"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <form name="form1">
          <td>&nbsp;</td>
        </form>
        <td><div align="right">共 <strong>
            <?=$pages?>
            </strong> 页 共 <strong>
            <?=$nums?>
        </strong> 笔&nbsp;&nbsp;</div></td>
      </tr>
    </table></td>
  </tr>
</table></td>
        </tr>
      </table></td>
      <td background="../img2/skin11_11.png">&nbsp;</td>
    </tr>
    <tr>
      <td valign="top"><img src="../img2/skin11_13.png" width="11" height="11" /></td>
      <td background="../img2/skin11_14.png"></td>
      <td valign="top"><img src="../img2/skin11_13-17.png" width="11" height="11" /></td>
    </tr>

</table>
</body>