📄 bill_find_check.php
字号:
<?php
session_start( );
include( "../inc/conn.php" );
include( "../inc/base_status.inc.php" );
if ( !isset( $_SESSION['myadmin'] ) )
{
echo "<script>window.location.href='../index.php';</script>";
}
if ( isset( $_GET['dact'] ) )
{
$id = $_GET['id'];
$ps = mysql_query( "delete from drop_bill where ID='{$id}'", $conn );
if ( $ps )
{
echo "<script language='javascript'>alert('删除成功!')</script>";
}
}
if ( isset( $_GET['actf'] ) )
{
$drop_content = $_POST['drop_content'];
$drop_details = $_POST['drop_details'];
$drop_time = $_POST['drop_time'];
$drop_money = $_POST['drop_money'];
$ids = $_POST['ids'];
mysql_query( "update drop_bill set drop_content='{$drop_content}',drop_details='{$drop_details}',drop_time='{$drop_time}',drop_money='{$drop_money}' where ID='{$ids}'" );
}
if ( isset( $_POST['act'] ) )
{
$txt = $_POST['txt_find'];
$find_type = $_POST['find_type'];
$date_start = $_POST['date_start'];
$date_end = $_POST['date_end'];
$start_time_h = $_POST['start_time_h'];
$start_time_f = $_POST['start_time_f'];
$end_time_h = $_POST['end_time_h'];
$end_time_f = $_POST['end_time_f'];
$money_type = $_POST['money_type'];
$down_type = $_POST['down_type'];
$_SESSION['txt'] = $txt;
$_SESSION['find_type'] = $find_type;
$_SESSION['date_start'] = $date_start;
$_SESSION['start_time_h'] = $start_time_h;
$_SESSION['start_time_f'] = $start_time_f;
$_SESSION['date_end'] = $date_end;
$_SESSION['end_time_h'] = $end_time_h;
$_SESSION['end_time_f'] = $end_time_f;
$_SESSION['money_type'] = $money_type;
$_SESSION['down_type'] = $down_type;
}
$txt = $_SESSION['txt'];
$find_type = $_SESSION['find_type'];
$date_start = $_SESSION['date_start'];
$start_time_h = $_SESSION['start_time_h'];
$start_time_f = $_SESSION['start_time_f'];
$date_end = $_SESSION['date_end'];
$end_time_h = $_SESSION['end_time_h'];
$end_time_f = $_SESSION['end_time_f'];
$money_type = $_SESSION['money_type'];
$down_type = $_SESSION['down_type'];
if ( $down_type != "all" )
{
$sq = " cut_sign='{$down_type}' and ";
}
else
{
$sq = "";
}
if ( $start_time_h == "" || $start_time_f == "" )
{
$stime = $date_start." 00:00:00";
$etime = $date_end." 23:59:59";
}
else
{
$stime = $date_start." ".$start_time_h.":".$start_time_f.":00";
$etime = $date_end." ".$end_time_h.":".$end_time_f.":00";
}
if ( $txt != "" && $find_type == 1 )
{
$sql = "select * from drop_bill where {$sq} user_name='{$txt}' and drop_time>='{$stime}' and drop_time<='{$etime}'";
}
else if ( $txt != "" && $find_type == 2 )
{
$sql = "select * from drop_bill where ID='{$txt}'";
}
else if ( $txt != "" && $find_type == 3 )
{
$sql = "select * from drop_bill where {$sq} drop_plate='{$txt}' and drop_time>='{$stime}' and drop_time<='{$etime}'";
}
else if ( $txt != "" && $find_type == 4 )
{
$sql = "select * from drop_bill where {$sq} cut_sign='1' and drop_content='{$txt}' and drop_time>='{$stime}' and drop_time<='{$etime}'";
}
else if ( $txt == "" )
{
$sql = "select * from drop_bill where {$sq} drop_time>='{$stime}' and drop_time<='{$etime}'";
}
$pagesize = 200;
$sqlc = mysql_query( $sql, $conn );
$numrows = mysql_num_rows( $sqlc );
$pages = intval( $numrows / $pagesize );
if ( $numrows % $pagesize )
{
++$pages;
}
if ( isset( $_GET['page'] ) )
{
$page = intval( $_GET['page'] );
}
else
{
$page = 1;
}
$offset = $pagesize * ( $page - 1 );
$sqld = mysql_query( "{$sql} order by ID desc limit {$offset},{$pagesize}", $conn );
echo "<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link href=\"../styles/css_g/css.CSS\" rel=\"stylesheet\" type=\"text/css\">\r\n<title>";
echo $titles;
echo "</title>\r\n";
echo "<s";
echo "tyle type=\"text/css\">\r\n<!--\r\nbody {\r\n\tmargin-left: 10px;\r\n}\r\n-->\r\n</style>\r\n";
echo "<s";
echo "cript language=\"JavaScript\" type=\"text/JavaScript\">\r\n<!--\r\nfunction MM_jumpMenu(targ,selObj,restore){ //v3.0\r\n eval(targ+\".location='\"+selObj.options[selObj.selectedIndex].value+\"'\");\r\n if (restore) selObj.selectedIndex=0;\r\n}\r\n//-->\r\n</script>\r\n ";
echo "<s";
echo "cript language=\"JavaScript\">\r\n <!--\r\n function sform()\r\n {\r\n myform.submit();\r\n }\r\n //-->\r\n </script> \r\n</head>\r\n<body oncontextmenu=\"return false\" onselectstart=\"return false\" \r\nonkeydown=\"return (event.ctrlKey && event.keyCode == 78) ? false : true\" \r\nondragstart=\"return false\" onmouseover=\"window.status=''; return true\">\r\n<br>\r\n<table width=\"796\" border=\"0\" cellpadding=\"1\" cellspacin";
echo "g=\"1\" class=\"t12\" >\r\n <tr class=\"t11\">\r\n <td colspan=\"13\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <td width=\"88%\" height=\"24\">";
echo "<s";
echo "pan ><font color=\"#FFFFFF\">注单查询</font></span></td>\r\n <td width=\"12%\"><a href=\"#\" class=\"fw12\" onClick=\"javascript:history.back();\">返回上一页</a></td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n <tr class=\"t11\">\r\n <td width=\"42\" height=\"18\"><div align=\"center\" class=\"fw12\">期数</div></td>\r\n <td width=\"84\"><div align=\"center\" class=\"fw12\">单号 / 时间</div></td>\r\n <td width=\"67\"><div align=\"center\" cla";
echo "ss=\"fw12\">帐号</div></td>\r\n <td width=\"42\"><div align=\"center\" class=\"fw12\">";
echo $ps_name;
echo "</div></td>\r\n <td width=\"42\"><div align=\"center\" class=\"fw12\">";
echo $ps_cut;
echo "</div></td>\r\n <td width=\"50\"><div align=\"center\">";
echo "<s";
echo "pan class=\"fw12\">盘类</span></div></td>\r\n <td width=\"114\"><div align=\"center\" class=\"fw12\">";
echo $ps_pourcontent;
echo "</div> </td>\r\n <td width=\"42\"><div align=\"center\" class=\"fw12\">";
echo $ps_rate;
echo "</div></td>\r\n <td width=\"81\"><div align=\"center\" class=\"fw12\">";
echo $ps_pourmoney;
echo "</div></td>\r\n <td width=\"42\"><div align=\"center\" class=\"fw12\">";
echo $ps_cut;
echo "</div></td>\r\n <td width=\"81\"><div align=\"center\" class=\"fw12\">";
echo $ps_result;
echo "</div></td>\r\n <td width=\"72\"><div align=\"center\" class=\"fw12\">修改\r\n </div></td>\r\n <td width=\"72\"><div align=\"center\" class=\"fw12\">删除</div></td>\r\n </tr>";
$i = 0;
while ( $rs = mysql_fetch_array( $sqld ) )
{
++$i;
echo "<form name=\"myform\" method=\"post\" action=\"bill_find_check.php?actf=del\" >\r\n <tr class=\"t15\" onmouseover=\"c=this.style.backgroundColor;this.style.backgroundColor='#FFFF66'\" onmouseout=\"this.style.backgroundColor=c\" onClick=\"this.style.backgroundColor='#FFFF66';c='#FFFF66'\">\r\n <td><div align=\"center\">";
echo $rs['drop_date'];
echo "</div></td>\r\n <td nowrap><div align=\"right\">\r\n ";
echo "<s";
echo "pan class=\"fgreng\">";
echo $rs['ID'];
echo " </span> ";
echo substr( $rs['drop_time'], 5 );
echo "</div></td>\r\n <td><div align=\"right\">";
echo $rs['user_name'];
echo "</div></td>\r\n <td><div align=\"right\">\r\n\t";
$u = $rs['user_name'];
$sqlname = mysql_query( "select * from member where user_account='{$u}'", $conn );
echo mysql_result( $sqlname, 0, "user_name" );
echo "</div></td>\r\n <td><div align=\"right\" class=\"fgreng\">\r\n ";
echo $rs['drop_cut'];
echo "</div></td>\r\n <td><div align=\"right\">";
echo $rs['drop_plate'];
echo $ps_plate;
echo "</div></td>\r\n <td nowrap><div align=\"right\">";
echo $rs['drop_type'];
echo " \r\n <input name=\"drop_content\" type=\"text\" class=\"input\" id=\"drop_content\" value=\"";
echo $rs['drop_content'];
echo "\" size=\"10\" maxlength=\"20\"> \r\n <input name=\"drop_details\" type=\"text\" class=\"input\" id=\"drop_details\" value=\"";
if ( $rs['drop_details'] != "0" )
{
echo $rs['drop_details'];
}
echo "\" size=\"10\" maxlength=\"20\">\r\n \r\n </div></td>\r\n <td><div align=\"right\">\r\n ";
$my = $rs['drop_money'];
$mo += $my;
echo " ";
echo $rs['drop_rate'];
echo "</div></td>\r\n <td><div align=\"right\">\r\n\t<input name=\"drop_money\" type=\"text\" class=\"input\" id=\"drop_money\" value=\"";
echo $rs['drop_money'];
echo "\" size=\"10\" maxlength=\"20\">\r\n\t</div></td>\r\n <td><div align=\"right\">\r\n\t";
$acut = $rs['drop_money'] * $rs['drop_cut'] * 0.01;
echo $acut;
$cut_count += $acut;
echo "</div></td>\r\n <td><div align=\"right\">\r\n\t";
$acy = $rs['user_win'];
if ( $acy < 0 )
{
echo "<font color='red'>".$acy."</font>";
}
else
{
echo $acy;
}
$ac += $acy;
echo "</div></td>\r\n \r\n <td><div align=\"center\">";
echo "<s";
echo "pan class=\"fw12\">\r\n <input type=\"submit\" name=\"Submit\" value=\"";
echo $ps_modify;
echo "\">\r\n <input name=\"drop_time\" type=\"hidden\" id=\"drop_time\" value=\"";
echo $rs['drop_time'];
echo "\">\r\n <input name=\"ids\" type=\"hidden\" id=\"ids\" value=\"";
echo $rs['ID'];
echo "\">\r\n </span>\r\n </div></td>\r\n <td><div align=\"center\"><a href=\"bill_find_check.php?dact=del&id=";
echo $rs['ID'];
echo "\" >删除</a></div></td>\r\n </tr></form>";
}
echo " <tr class=\"t11\">\r\n <td colspan=\"13\"><div align=\"right\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n <tr>\r\n <form name=\"form1\">\r\n <td width=\"62%\"> ";
$fp = "bill_find_check.php";
$first = 1;
$prev = $page - 1;
$next = $page + 1;
$last = $pages;
if ( 1 < $page )
{
echo "<a href='?page=".$first."' class='aw'>".$ps_firstpage."</a> ";
echo "<a href='?page=".$prev."' class='aw'>".$ps_uppage."</a> ";
}
else
{
echo "<font color='#ffffff'>".$ps_firstpage." ".$ps_uppage."</font> ";
}
if ( $page < $pages )
{
echo "<a href='?page=".$next."' class='aw'>".$ps_nextpage."</a> ";
echo "<a href='?page=".$last."' class='aw'>".$ps_endpage."</a> ";
}
else
{
echo "<font color='#ffffff'>".$ps_nextpage." ".$ps_endpage."</font> ";
}
$nums = $pagesize * $pages;
echo "<s";
echo "pan class=\"fw12\"> ";
echo $ps_pagetwice;
echo "：</span>\r\n ";
echo "<s";
echo "elect name=\"menu1\" onChange=\"MM_jumpMenu('self',this,0)\">\r\n\t\t\t\t\t\t";
$i = 1;
for ( ; $i <= $pages; ++$i )
{
if ( $page == $i )
{
$se = "selected";
}
else
{
$se = "";
}
echo "<option value='?page=".$i."' ".$se.">".$i."</option>";
}
echo " </select>\r\n ";
echo "<s";
echo "pan class=\"fw12\">";
echo $ps_all;
echo " ";
echo "<s";
echo "trong>\r\n ";
echo $pages;
echo " </strong> ";
echo $ps_page;
echo "</span>";
echo "<s";
echo "pan class=\"fw12\"> </span> </td>\r\n </form>\r\n <td width=\"38%\"><div align=\"right\"> </div></td>\r\n </tr>\r\n </table></div></td>\r\n </tr>\r\n</table>\r\n</body>\r\n\r\n\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -