📄 manage.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
session_start( );
if ( $_REQUEST['cur_page'] == "" )
{
$cur_page = 1;
}
else
{
$cur_page = $_REQUEST['cur_page'];
}
echo "\r\n<html>\r\n<head>\r\n<title>入库单管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction exports(sort,appellation,spec,join_amount,price,money,user_name,date,bill){\r\n\turl = \"export.php?sort=\"+sort+\"&appellation=\"+appellation+\"&spec=\"+spec+\"&join_amount=\"+join_amount+\"&price=\"+price+\"&money=\"+money+\"&user_name=\"+user_name+\"&date=\"+date+\"&bill=\"+bill+\"&choose=exports\";\r\n\tlocation\t= url;\r\n}\r\n\r\nfunction del(storeroom_id){\r\n\tvar msg\t= \"你确定要删除此条记录？\";\r\n\tif(window.";
echo "confirm(msg)){\r\n\t\turl\t= \"update.php?handle=delete&storeroom_id=\"+storeroom_id;\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n\t<tr class=\"tablehead1\">\r\n\t\t<td><img src=\"/images/manage/news.gif\" align=\"absmiddle\">入库单管理</td>\r\n\t</tr>\r\n\t<tr class=\"tablehead2\">\r\n\t\t<td><BUTTON class=btn onClick=\"javascript";
echo ":location='add.php';\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">新增入库单</span></td></tr></table></BUTTON> <BUTTON class=btn onClick=\"javscript:location='search.php';\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">入库单查询</span></td></tr></table></BUTTON> <BUTTON class=btn onClick=\"javscript:history.back();\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON></td>\r\n\t</tr>\r\n</table>\r\n<br>\r\n";
$connection = openconnection( );
$query5 = "SELECT oj.*, oa.* FROM officeitem_joinstoreroom as oj, officeitem_appellation as oa where oj.APPELLATION_ID=oa.APPELLATION_ID";
$cursor5 = exequery( $connection, $query5 );
while ( $row5 = mysql_fetch_array( $cursor5 ) )
{
$join_amount5 = $row5['JOIN_AMOUNT'];
$money5 = $row5['MONEY'];
$sum_join_amount += $join_amount5;
$sum_money += $money5;
}
$query = "SELECT oj.*, oa.* FROM officeitem_joinstoreroom as oj, officeitem_appellation as oa where oj.APPELLATION_ID=oa.APPELLATION_ID";
switch ( $_REQUEST['order'] )
{
case "appellation_id" :
$query .= " order by oj.APPELLATION_ID";
break;
case "join_amount" :
$query .= " order by oj.JOIN_AMOUNT";
break;
case "price" :
$query .= " order by oj.PRICE";
break;
case "operator" :
$query .= " order by oj.OPERATOR";
break;
case "join_date" :
$query .= " order by oj.JOIN_DATE";
break;
case "bill" :
$query .= " order by oj.BILL";
break;
case "money" :
$query .= " order by oj.MONEY";
break;
default :
$query .= " order by oj.STOREROOM_ID";
break;
}
$query .= $_REQUEST['sens'] ? " DESC" : " ASC";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$count = 0;
echo "<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"5\" class=\"small\">\r\n";
while ( $row = mysql_fetch_array( $cursor ) )
{
++$count;
$storeroom_id = $row['STOREROOM_ID'];
$join_date = $row['JOIN_DATE'];
$provider_id = $row['PROVIDER_ID'];
$bill = $row['BILL'];
$appellation_id = $row['APPELLATION_ID'];
$price = $row['PRICE'];
$join_amount = $row['JOIN_AMOUNT'];
$money = $row['MONEY'];
$storeroom_stockpile = $row['STOREROOM_STOCKPILE'];
$operator = $row['OPERATOR'];
$join_appellation = $row['JOIN_APPELLATION'];
$join_appellation_sort = $row['JOIN_APPELLATION_SORT'];
$date = explode( " ", $join_date );
$query2 = "\r\n\t\tSELECT oa.APPELLATION, os.SORT, oa.SPEC \r\n\t\tFROM officeitem_appellation as oa, officeitem_sort as os \r\n\t\tWHERE oa.APPELLATION_ID=".$appellation_id." && os.SORT_ID=oa.SORT_ID\r\n\t\t";
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_row( $cursor2 ) )
{
$appellation = $row2[0];
$sort = $row2[1];
$spec = $row2[2];
}
$query3 = "SELECT USER_NAME FROM user WHERE USER_ID='".$operator."'";
$cursor3 = exequery( $connection, $query3 );
if ( $row3 = mysql_fetch_row( $cursor3 ) )
{
$user_name = $row3[0];
}
if ( $count % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo "\t<tr class=\"";
echo $TableLine;
echo "\">\r\n\t\t<td>";
echo $sort;
echo "</td>\r\n\t\t<td>";
echo $appellation;
echo "</td>\r\n\t\t<td>";
echo $spec;
echo "</td>\r\n\t\t<td>";
echo $join_amount;
echo "</td>\r\n\t\t<td>";
echo $price;
echo "</td>\r\n\t\t<td>";
echo $money;
echo "</td>\r\n\t\t<td>";
echo $user_name;
echo "</td>\r\n\t\t<td>";
echo $date[0];
echo "</td>\r\n\t\t<td>";
echo $bill;
echo "</td>\r\n\t\t<td><a href=\"#\" onclick=\"javascript:exports('";
echo $sort;
echo "','";
echo $appellation;
echo "','";
echo $spec;
echo "','";
echo $join_amount;
echo "','";
echo $price;
echo "','";
echo $money;
echo "','";
echo $user_name;
echo "','";
echo $date[0];
echo "','";
echo $bill;
echo "')\">导出</a> ";
if ( $_SESSION['LOGIN_USER_ID'] == "admin" )
{
echo "<a href=\"#\" onclick=\"del('";
echo $storeroom_id;
echo "')\">删除</a>";
}
echo "</td>\r\n\t</tr>\r\n";
}
echo "<center>";
if ( $count == 0 )
{
message( "提示", "暂无记录" );
exit( );
}
echo "</center>";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "\t<thead class=\"TableHeader\">\r\n\t\t<td>类别</td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=appellation_id\">名称";
if ( $_REQUEST['order'] == "appellation_id" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>规格</td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=join_amount\">数量";
if ( $_REQUEST['order'] == "join_amount" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=price\">单价";
if ( $_REQUEST['order'] == "price" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=money\">金额";
if ( $_REQUEST['order'] == "money" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=operator\">操作员";
if ( $_REQUEST['order'] == "operator" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=join_date\">入库时间";
if ( $_REQUEST['order'] == "join_date" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=bill\">入库单据号";
if ( $_REQUEST['order'] == "bill" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>操作</td>\r\n\t</thead>\r\n\t<tr style=\"color:#999999;font:bold;\" class=\"TableLine1\">\r\n\t\t<td>总计：</td>\r\n\t\t<td> </td>\r\n\t\t<td> </td>\r\n\t\t<td>";
echo $sum_join_amount;
echo "</td>\r\n\t\t<td> </td>\r\n\t\t<td>";
echo $sum_money;
echo "</td>\r\n\t\t<td> </td>\r\n\t\t<td> </td>\r\n\t\t<td> </td>\r\n\t\t<td> </td>\r\n\t</tr>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n\t<tr>\r\n\t\t<td class=\"TableLine1\" nowrap align=\"right\">";
disp( "sens=".$_REQUEST['sens']."&order=".$_REQUEST['order'] );
echo "</td>\r\n\t</tr>\r\n</table>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
$cur_page = $_REQUEST['cur_page'] - $n;
header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -