📄 record.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 src=\"/inc/js/module.js\"></script>\r\n<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n if(document.form1.PRO_ID.value==\"-1\")\r\n { \r\n alert(\"请选择办公用品!\");\r\n form1.PRO_ID.focus();\r\n return (false);\r\n }\r\n\r\n if(document.form1.TRANS_QTY.value==\"\")\r\n { \r\n alert(\"申请数量不能为空!\");\r\n form1.TRANS_QTY.focus();\r\n return (false);\r\n }\r\n \r\n if(document.form1.TRANS_QTY.value==\"0\")\r\n { \r\n alert(\"申请数量不能为0!\");\r\n form1.TRANS_QTY.focus();\r\n return (false);\r\n }\r\n\r\n if(checknum(document.form1.TRANS_QTY.value)==\"0\")\r\n { \r\n alert(\"申请数量必须是数字!\");\r\n form1.TRANS_QTY.focus();\r\n return (false);\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\nfunction LoadWindow2()\r\n{\r\n URL=\"tree.php\";\r\n loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;\r\n window.open(URL,\"\",\"height=355px,width=320px,directories=no,menubar=no,toolbar=no,status=no,scrollbars=yes,location=no,top=\"+loc_y+\",left=\"+loc_x+\"\");\r\n}\r\n\r\nvar PRODUCT=[\r\n";
$query = "SELECT CODE_NO from SYS_CODE where PARENT_NO='OFFICE_PROTYPE' order by CODE_NAME";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = "";
$STR_PRONAME1 = "";
$STR_PROID1 = "";
$CODE_NO = $ROW['CODE_NO'];
if ( $LOGIN_USER_PRIV != 1 )
{
$query = "SELECT * from OFFICE_PRODUCTS where OFFICE_PROTYPE='".$CODE_NO."' and (( find_in_set('{$LOGIN_USER_ID}',PRO_MANAGER) or find_in_set('{$LOGIN_DEPT_ID}',PRO_DEPT)) or (PRO_MANAGER='' and PRO_DEPT='') or PRO_DEPT='ALL_DEPT')";
}
else
{
$query = "SELECT * from OFFICE_PRODUCTS where OFFICE_PROTYPE='".$CODE_NO."'";
}
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$PROSTOCK = $ROW['PRO_STOCK'];
$PROUNIT = htmlspecialchars( $ROW['PRO_UNIT'] );
$PRONAME = htmlspecialchars( $ROW['PRO_NAME'] );
$STR_PRONAME1 = $STR_PRONAME1."\"".$PRONAME."/库存".$PROSTOCK.$PROUNIT."\",";
$STR_PROID1 = $STR_PROID1."\"".$ROW['PRO_ID']."\",";
}
$STR_PRONAME1 = substr( $STR_PRONAME1, 0, strlen( $STR_PRONAME1 ) - 1 );
$STR_PROID1 = substr( $STR_PROID1, 0, strlen( $STR_PROID1 ) - 1 );
$STR_TEMP = $STR_TEMP."[".$STR_PRONAME1."],[".$STR_PROID1."],";
}
$STR_TEMP = substr( $STR_TEMP, 0, strlen( $STR_TEMP ) - 1 );
echo $STR_TEMP;
echo "];\r\n\r\nfunction getProduct()\r\n{\r\n var OFFICE_PROTYPE=document.form1.OFFICE_PROTYPE;\r\n var PRO_ID=document.form1.PRO_ID;\r\n var PRODUCT_NAME=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2];\r\n var PRODUCT_VALUE=PRODUCT[(OFFICE_PROTYPE.selectedIndex-1)*2+1];\r\n PRO_ID.length=1;\r\n for(var i=0;i<PRODUCT_NAME.length;i++)\r\n {\r\n PRO_ID[i+1]=new Option(PRODUCT_NAME[i],PRODUCT_VALUE[i]);\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\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=\"add.php\" method=\"post\" name=\"form1\">\r\n<table width=\"70%\" align=\"center\" class=\"TableBlock\">\r\n <tr>\r\n <td nowrap class=\"TableData\">登记类型:</td>\r\n <td class=\"TableData\">\r\n <select name=\"TRANS_FLAG\" class=\"BigSelect\">\r\n <option value=\"1\" selected>领用</option>\r\n <option value=\"2\">借用</option>\r\n </select>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">办公用品类别:</td>\r\n <td class=\"TableData\">\r\n <select name=\"OFFICE_PROTYPE\" class=\"BigSelect\" onChange=\"getProduct()\">\r\n <option value=\"-1\">请选择类别</option>\r\n";
$query = "SELECT CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO='OFFICE_PROTYPE' order by CODE_NAME";
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$CODENAME = $ROW['CODE_NAME'];
$CODENO = $ROW['CODE_NO'];
echo " <option value=\"";
echo $CODE_NO;
echo "\">";
echo $CODENAME;
echo "</option>\r\n";
}
echo " </select>\r\n </td>\r\n </tr>\r\n \t<tr>\r\n <td nowrap class=\"TableData\">办公用品:</td>\r\n <td class=\"TableData\">\r\n <select name=\"PRO_ID\" class=\"BigSelect\">\r\n <option value=\"-1\">---请选择---</option>\r\n";
if ( $LOGIN_USER_PRIV != 1 )
{
$query = "SELECT * from OFFICE_PRODUCTS where (PRO_MANAGER='".$LOGIN_USER_ID."' or find_in_set('{$LOGIN_DEPT_ID}',PRO_DEPT)) or (PRO_MANAGER='' and PRO_DEPT='') or PRO_DEPT='ALL_DEPT'";
}
else
{
$query = "SELECT * from OFFICE_PRODUCTS";
}
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$VOTE_COUNT;
$PROID = $ROW['PRO_ID'];
$PRONAME = $ROW['PRO_NAME'];
$PROSTOCK = $ROW['PRO_STOCK'];
$PROUNIT = $ROW['PRO_UNIT'];
echo " <option value=\"";
echo $PROID;
echo "\">";
echo $PRONAME;
echo "/库存";
echo $PROSTOCK;
echo $PROUNIT;
echo "</option>\r\n";
}
echo " </select> \r\n\t\t <input type=\"button\" name=\"SelectPro\" title=\"模糊选择\" value=\"模糊选择\" class=\"SmallButton\" onClick=\"LoadWindow2()\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">申请数量:</td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"TRANS_QTY\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"\">\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">备注:</td>\r\n <td class=\"TableData\">\r\n <textarea name=\"REMARK\" cols=\"45\" rows=\"5\" class=\"BigInput\"></textarea>\r\n </td>\r\n </tr>\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"";
echo $LOGIN_USER_ID;
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 </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 + -