detail.php
来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 82 行
PHP
82 行
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
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<script Language=\"JavaScript\">\r\nfunction chk(input,strwher)\r\n {\r\n URL=\"list1.php?\"+strwher+\"&SUMFIELD=\"+input.value;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n\r\nfunction LoadWindow1(ARRAY_FIELD,graphValues1,graphValues2,graphValues3,showname,type)\r\n {\r\n URL=\"statics?ARRAY_FIELD=\"+ARRAY_FIELD+\"&graphValues1=\"+graphValues1+\"&graphValues2=\"+graphValues2+\"&graphValues3=\"+graphValues3+\"&showname=\"+showname+\"&type=\"+type;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n }\r\n\r\nfunction change_type(type)\r\n{\r\n window.location=\"index.php?CUR_PAGE=";
echo $CUR_PAGE;
echo "&WH_ID=\"+type+\"&FIELD=";
echo $FIELD;
echo "&ASC_DESC=";
echo $ASC_DESC;
echo "\";\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "SELECT PRODUCT_NAME FROM PRODUCT WHERE PRODUCT_ID=".$PRODUCT_ID;
$cursor = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor ) )
{
$PRODUCT_NAME = $ROW1['PRODUCT_NAME'];
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_open.gif\" WIDTH=\"22\" HEIGHT=\"22\" align=\"absmiddle\"><span class=\"big3\"> ";
echo $PRODUCT_NAME;
echo "</span> </td>\r\n </tr>\r\n</table>\r\n<div align=\"left\">\r\n";
$query1 = "SELECT WH_ID,PRODUCT_LOWSTOCK,sum(PRICE*AMT) TOTAL_PRICE,sum(AMT) TOTAL_AMT\r\n\t from STOCK left join PRODUCT on PRODUCT.PRODUCT_ID=STOCK.PRODUCT_ID where STOCK.PRODUCT_ID=".$PRODUCT_ID." and WH_ID<>0{$WHERE_STR} GROUP BY STOCK.WH_ID {$HAVING_STR}".$OREDERBY;
$cursor1 = exequery( $connection, $query1 );
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n";
$STOCK_COUNT = 0;
$LOWSTOCK_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
++$STOCK_COUNT;
$WH_ID0 = $WH_ID1;
$WH_ID1 = $ROW['WH_ID'];
$PRODUCT_LOWSTOCK = $ROW['PRODUCT_LOWSTOCK'];
$TOTAL_PRICE = $ROW['TOTAL_PRICE'];
$TOTAL_AMT = $ROW['TOTAL_AMT'];
if ( $WH_ID0 != $WH_ID1 )
{
$query = "SELECT WH_NAME FROM WIREHOUSE WHERE WH_ID=".$WH_ID1;
$cursor = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor ) )
{
$WH_NAME = $ROW1['WH_NAME'];
}
if ( $TableLine == "TableLine2" )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
}
echo " <tr class=\"";
echo $TableLine;
echo "\">\r\n <td nowrap align=\"center\">";
if ( $TOTAL_AMT < $PRODUCT_LOWSTOCK )
{
echo "<font color=red>";
}
echo $WH_NAME;
if ( $TOTAL_AMT < $PRODUCT_LOWSTOCK )
{
echo "</font>";
}
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PRODUCT_LOWSTOCK;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_AMT;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $TOTAL_PRICE;
echo "</td>\r\n </tr>\r\n\r\n";
}
if ( $STOCK_COUNT == 0 )
{
message( "", "无库存统计" );
exit( );
}
echo " <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">合计：</td>\r\n <td nowrap align=\"center\" colspan=\"4\">共有产品 ";
echo $STOCK_COUNT;
echo " 个</td>\r\n </tr>\r\n <thead class=\"TableHeader\">\r\n <TD>仓库名称</TD>\r\n <TD>警戒库存</TD>\r\n <TD>当前库存</TD>\r\n <TD>总金额</TD>\r\n </thead>\r\n</table>\r\n<br>\r\n <div align=center> <input type=\"button\" value=\"关闭\" class=\"BigButton\" onclick=\"window.close()\"></div>\r\n<br>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?