📄 trans_detail.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "<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 CheckForm()\r\n{\r\n if(document.form1.FACT_QTY.value==\"0\")\r\n { \r\n alert(\"实际数量不能为0!\");\r\n \t form1.FACT_QTY.focus();\r\n return (false);\r\n }\r\n \r\n if(document.form1.FACT_QTY.value==\"\")\r\n { \r\n alert(\"实际数量不能为空!\");\r\n \t form1.FACT_QTY.focus();\r\n return (false);\r\n }\r\n\r\n if(checknum(document.form1.FACT_QTY.value)==\"0\")\r\n { \r\n alert(\"实际数量必须是数字!\");\r\n \t form1.FACT_QTY.focus();\r\n return (false);\r\n }\r\n \r\n if((document.form1.TRANS_FLAG.value==\"1\")||(document.form1.TRANS_FLAG.value==\"2\"))\r\n { \r\n if (Number(document.form1.FACT_QTY.value)>Number(document.form1.PRO_STOCK.value))\r\n\t {\r\n \t alert(\"实际数量不能大于库存数量!\");\r\n\t\tform1.FACT_QTY.focus();\r\n return (false);\r\n\t }\r\n }\r\n\r\n document.form1.submit();\r\n}\r\n\r\nfunction checknum(p)\r\n{\r\n var l = p.length;\r\n var count=0;\r\n for(var i=0; i<l; i++)\r\n {\r\n var digit = p.charAt(i);\r\n if(digit == \".\" )\r\n {\r\n ++count;\r\n if(count>1)\r\n {\r\n return 0;\r\n }\r\n }\r\n else if(digit < \"0\" || digit > \"9\")\r\n {\r\n return 0;\r\n }\r\n }\r\n return 1;\r\n}\r\n\r\n</script>\r\n</head>\r\n";
$query = "SELECT * from OFFICE_TRANSHISTORY where TRANS_ID = '".$TRANS_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRO_ID = $ROW['PRO_ID'];
$TRANS_FLAG = $ROW['TRANS_FLAG'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$REMARK = $ROW['REMARK'];
$TRANS_DATE = $ROW['TRANS_DATE'];
$TRANS_STATE = $ROW['TRANS_STATE'];
$BORROWER = $ROW['BORROWER'];
$query1 = "select USER_NAME from USER where USER_ID='".$BORROWER."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW[0];
}
else
{
$BORROWER_NAME = "已不存在该用户";
}
$query1 = "SELECT OFFICE_PROTYPE,PRO_NAME,PRO_PRICE,PRO_LOWSTOCK,PRO_MAXSTOCK,PRO_STOCK from OFFICE_PRODUCTS where PRO_ID = '".$PRO_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PRO_NAME = $ROW['PRO_NAME'];
$OFFICE_PROTYPE = $ROW['OFFICE_PROTYPE'];
$PRO_PRICE = $ROW['PRO_PRICE'];
$PRO_LOWSTOCK = $ROW['PRO_LOWSTOCK'];
$PRO_MAXSTOCK = $ROW['PRO_MAXSTOCK'];
$PRO_STOCK = $ROW['PRO_STOCK'];
}
else
{
$PRO_NAME = "此物品已删除";
}
$query1 = "SELECT CODE_NAME from SYS_CODE where CODE_NO='".$OFFICE_PROTYPE."' and PARENT_NO='OFFICE_PROTYPE'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$CODE_NAME = $ROW['CODE_NAME'];
}
else
{
$CODE_NAME = "此类别已删除";
}
if ( $TRANS_FLAG == "1" )
{
$TRANS_NAME = "领用";
}
if ( $TRANS_FLAG == "2" )
{
$TRANS_NAME = "借用";
}
if ( $TRANS_FLAG == "3" )
{
$TRANS_NAME = "归还";
}
if ( substr( $TRANS_QTY, 0, 1 ) == "-" )
{
$TRANS_QTY = substr( $TRANS_QTY, 1 );
}
}
echo "<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"javascript:document.form1.FACT_QTY.focus();\">\r\n<table border=\"0\" width=\"50%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 处理待批申请</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<form enctype=\"multipart/form-data\" action=\"trans_handle.php\" method=\"post\" name=\"form1\">\r\n<table width=\"70%\" align=\"center\" class=\"TableBlock\">\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"30%\">申请类型:</td>\r\n <td class=\"TableData\">";
echo $TRANS_NAME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"30%\">申请人:</td>\r\n <td class=\"TableData\">";
echo $BORROWER_NAME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"30%\">申请时间:</td>\r\n <td class=\"TableData\">";
echo $TRANS_DATE;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">办公用品类别:</td>\r\n <td class=\"TableData\">";
echo $CODE_NAME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">办公用品名称:</td>\r\n <td class=\"TableData\">";
echo $PRO_NAME;
echo "</td>\r\n </tr>\r\n <tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">警戒库存范围:</td>\r\n <td class=\"TableData\">";
echo $PRO_LOWSTOCK;
echo " 至 ";
echo $PRO_MAXSTOCK;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">当前库存:</td>\r\n <td class=\"TableData\">";
echo $PRO_STOCK;
echo " ";
if ( $PRO_MAXSTOCK < $PRO_STOCK )
{
echo "<font color=red>大于最高警戒库存</font>";
}
if ( $PRO_STOCK < $PRO_LOWSTOCK )
{
echo "<font color=red>小于最低警戒库存</font>";
}
echo "</td>\r\n </tr>\r\n <tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">单价:</td>\r\n <td class=\"TableData\">";
echo $PRO_PRICE;
echo "元</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">申请数量:</td>\r\n <td class=\"TableData\">";
echo $TRANS_QTY;
echo "</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">实际数量:</td>\r\n <td class=\"TableData\"><input type=\"text\" size=\"30\" class=\"BigInput\" name=\"FACT_QTY\" value=\"\"></td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">备注:</td>\r\n <td class=\"TableData\">";
echo $REMARK;
echo "</td>\r\n </tr>\r\n <input type=\"hidden\" name=\"OPERATOR_ID\" value=\"";
echo $LOGIN_USER_ID;
echo "\">\r\n <input type=\"hidden\" name=\"TRANS_ID\" value=\"";
echo $TRANS_ID;
echo "\">\r\n <input type=\"hidden\" name=\"TRANS_FLAG\" value=\"";
echo $TRANS_FLAG;
echo "\">\r\n <input type=\"hidden\" name=\"PRO_ID\" value=\"";
echo $PRO_ID;
echo "\">\r\n <input type=\"hidden\" name=\"PRO_STOCK\" value=\"";
echo $PRO_STOCK;
echo "\">\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"button\" value=\"同意\" class=\"BigButton\" onClick=\"CheckForm();\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"javascript:history.go(-1)\">\r\n </td>\r\n </tfoot>\r\n </table>\r\n</form>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -