📄 table_class_bill_details.php
字号:
<?php
session_start();
include("../inc/conn.php");
include("checks.php");
$all_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["cutsign"]))
{
$droptype=$_GET["droptype"];
$cut_sign=$_GET["cutsign"];
$dates=$_GET["dates"];
$_SESSION["droptype"]=$droptype;
$_SESSION["cutsign"]=$cut_sign;
$_SESSION["ddates"]=$dates;
}else
{
$droptype=$_SESSION["droptype"];
$cut_sign=$_SESSION["cutsign"];
$dates=$_SESSION["ddates"];
}
$_SESSION["menus"]="查看$droptype分类账";
if($date_num=="no")
{
$sq=" and drop_time>='$start_time' and drop_time<='$end_time' ";
}else $sq=" and drop_date='$dates'";
$pagesize=500;
$sqlc=mysql_query("select count(*) from drop_bill where cut_sign='$cut_sign' $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 cut_sign='$cut_sign' $sq order by drop_time 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"> </td>
<form name="form1">
<td width="556" height="20" class="fw12">下注清单 (
<? if($droptype=="特码A")
{ echo "特码";
}else echo $droptype;?>)</td>
<td width="206" class="fw12"><div align="right"> <a href="#" class="ah" onClick="document.execCommand('print','true','true')">列印</a> <a href="table.php" class="ah">返回上一页</a></div></td>
</form>
<td width="13"> </td>
</tr>
</table><br><br>
<table width="100%" height="100" border="0" cellpadding="2" cellspacing="1" class="t12">
<tr bgcolor="#456594">
<td width="123" height="25"><div align="center" class="fw12">单号/时间</div></td>
<td width="66"><div align="center" class="fw12">账号</div></td>
<td width="66"><div align="center" class="fw12">名称</div> <div align="center"></div></td>
<td width="47"><div align="center" class="fw12">退水</div> <div align="center"></div></td>
<td width="100"><div align="center" class="fw12">盘类/下注期数</div> <div align="center"></div></td>
<td width="69"><div align="center" class="fw12">下注内容</div> <div align="center"></div></td>
<td width="68"><div align="center"></div>
<div align="center" class="fw12">赔率</div> <div align="center"></div> <div align="center" class="fw12"></div> </td>
<td width="79"><div align="center" class="fw12">下注金额</div></td>
<td width="51"><div align="center" class="fw12">退水</div></td>
<td width="53"><div align="center" class="fw12">结果</div></td>
</tr><?php while($rs=mysql_fetch_array($sql))
{ $cuts=0;
$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"];
$drop_money=$rs["drop_money"];
$num_sign=$rs["num_sign"];
$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(" ","",$rs["drop_cut"])*0.01;
$user_win=$rs["user_win"];
$user_win_count+=$user_win;
$cut_count+=$cuts;
?>
<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"><?=$rs["drop_type"]?> <?=$rs["drop_content"]?>
<?php if($rs["drop_details"]<>"0") echo $rs["drop_details"]?></div></td>
<td><div align="right"><?=$rs["drop_rate"]?></div></td>
<td><div align="right">
<?php $mcount=$rs["drop_money"];
$mcounts+=$mcount;
echo $mcount;?></div></td>
<td><div align="right">
<?php //$cuts=$rs["drop_money"]*$rs["drop_cut"]*0.01;
$ccounts+=$cuts;
echo $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"><?=$mcounts?></div></td>
<td nowrap><div align="right"><strong><?=$ccounts?></strong></div></td>
<td nowrap><div align="right" >
<?=$user_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_class_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> ";
echo "<a href='".$fp."?page=".$prev."' class='aw'>上一页</a> ";
}else
{
echo "<font color='#ffffff'>第一页 上一页</font> ";
}
if ($page<$pages)
{
echo "<a href='".$fp."?page=".$next."' class='aw'>下一页</a> ";
echo "<a href='".$fp."?page=".$last."' class='aw'>最终页</a> ";
} else
{
echo "<font color='#ffffff'>下一页 最终页</font> ";
}
$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"> </span></div></td>
</tr>
</table></td>
</tr>
</table>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -