📄 record.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>办公用品登记管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><script src=\"/inc/js/module.js\"></script>\r\n\r\n<script Language=\"JavaScript\">\r\nfunction LoadWindow2()\r\n{\r\n URL=\"product_select\";\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.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:245px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\nfunction CheckForm()\r\n{\r\n if(document.form1.TRANS_FLAG.value==\"-1\")\r\n { alert(\"请选择登记类型！！\");\r\n \tform1.TRANS_FLAG.focus();\r\n return (false);\r\n }\r\n if(document.form1.TRANS_FLAG.value==\"1\" || document.form1.TRANS_FLAG.value==\"2\" || document.form1.TRANS_FLAG.value==\"3\")\r\n {\r\n \tif (document.form1.TO_ID.value==\"\")\r\n \t{\r\n \t\t if(document.form1.TRANS_FLAG.value==\"1\")\r\n \t\t alert( \"领用人不能空！！\");\r\n \t if(document.form1.TRANS_FLAG.value==\"2\")\r\n \t\t alert( \"借用人不能空！！\");\r\n \t\t if(document.form1.TRANS_FLAG.value==\"3\")\r\n \t\t alert( \"归还人不能空！！\");\r\n return (false);\r\n \t }\r\n }\r\n\r\n\r\n if(document.form1.PRO_ID.value==\"-1\")\r\n { alert(\"请选择办公用品！！\");\r\n \t form1.PRO_ID.focus();\r\n return (false);\r\n }\r\n\r\n if(document.form1.TRANS_QTY.value==\"\")\r\n { alert(\"数量不能空！！\");\r\n \t form1.TRANS_QTY.focus();\r\n return (false);\r\n }\r\n\r\n if(checknum(document.form1.TRANS_QTY.value)==\"0\")\r\n { alert(\"数量必须是数字！！！\");\r\n \t 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 PageBack()\r\n{\r\n\t";
if ( $TTYPE != "USER" )
{
echo "location='detail.php?TRUN=1&TRANS_FLAG=";
echo $TRANS_FLAG;
echo "&PRO_ID=";
echo $PRO_ID;
echo "&PRO_NAME=";
echo $PRO_NAME;
echo "&FROM_DATE=";
echo $FROM_DATE;
echo "&TO_DATE=";
echo $TO_DATE;
echo "&BORROWER=";
echo $BORROWER;
echo "';";
}
else
{
echo " window.history.go(-1);";
}
echo "\t\r\n\r\n\r\n}\r\n\r\nfunction sel_change()\r\n{\r\n\t document.form1.TO_ID.value=\"\";\r\n\t document.form1.TO_NAME.value=\"\";\r\n\t document.form1.PRICE.value=\"\";\r\n \t if(form1.TRANS_FLAG.value==\"-1\")\r\n {\r\n \tif(document.all(\"BORROWER\").style.display==\"\")\r\n \t document.all(\"BORROWER\").style.display=\"none\";\r\n \tif(document.all(\"COST\").style.display==\"\")\r\n \t document.all(\"COST\").style.display=\"none\";\r\n }\r\n if(form1.TRANS_FLAG.value==\"0\")\r\n {\r\n \tif(document.all(\"BORROWER\").style.display==\"\")\r\n \t document.all(\"BORROWER\").style.display=\"none\";\r\n \tdocument.all(\"COST\").style.display=\"\";\r\n }\r\n\r\n if(form1.TRANS_FLAG.value==\"1\")\r\n {\r\n if(document.all(\"COST\").style.display==\"\")\r\n \t document.all(\"COST\").style.display=\"none\";\r\n document.all(\"BORROWER\").style.display=\"\";\r\n \t document.all.t1.style.display='';\r\n \t document.all.t2.style.display='none';\r\n \t document.all.t3.style.display='none';\r\n }\r\n\r\n if(form1.TRANS_FLAG.value==\"2\")\r\n {\r\n \tif(document.all(\"COST\").style.display==\"\")\r\n \t document.all(\"COST\").style.display=\"none\";\r\n document.all(\"BORROWER\").style.display=\"\";\r\n \t document.all.t2.style.display='';\r\n \t document.all.t1.style.display='none';\r\n \t document.all.t3.style.display='none';\r\n }\r\n\r\n if(form1.TRANS_FLAG.value==\"3\")\r\n {\r\n \tif(document.all(\"COST\").style.display==\"\")\r\n \t document.all(\"COST\").style.display=\"none\";\r\n document.all(\"BORROWER\").style.display=\"\";\r\n \t document.all.t3.style.display='';\r\n \t document.all.t1.style.display='none';\r\n \t document.all.t2.style.display='none';\r\n }\r\n if(form1.TRANS_FLAG.value==\"4\")\r\n {\r\n\r\n if(document.all(\"BORROWER\").style.display==\"\")\r\n \t document.all(\"BORROWER\").style.display=\"none\";\r\n \tif(document.all(\"COST\").style.display==\"\")\r\n \t document.all(\"COST\").style.display=\"none\";\r\n \tdocument.all.t3.style.display='none';\r\n \t document.all.t1.style.display='none';\r\n \t document.all.t2.style.display='none';\r\n }\r\n}\r\n\r\nfunction delete_vote(TRANS_ID)\r\n{\r\n msg='确认放弃该操作？放弃该操作库存将回滚到操作前的状态！！';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?TRANS_ID=\"+TRANS_ID;\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( $TRANS_ID != "" )
{
$query = "SELECT * from OFFICE_TRANSHISTORY where TRANS_ID=".$TRANS_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TRANS_ID = $ROW['TRANS_ID'];
$PRO_ID1 = $ROW['PRO_ID'];
$BORROWER1 = $ROW['BORROWER'];
$BORROWER2 = $ROW['BORROWER'];
$TRANS_FLAG1 = $ROW['TRANS_FLAG'];
$TRANS_QTY = $ROW['TRANS_QTY'];
$PRICE = $ROW['PRICE'];
$TRANS_DATE = $ROW['TRANS_DATE'];
$OPERATOR = $ROW['OPERATOR'];
$REMARK = $ROW['REMARK'];
if ( $TRANS_FLAG1 == "0" )
{
$TRANS_NAME = "采购入库";
$BORROWER_NAME = "";
}
if ( $TRANS_FLAG1 == "1" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "领用";
$TOK = strtok( $BORROWER1, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if ( $TRANS_FLAG1 == "2" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "借用";
$TOK = strtok( $BORROWER1, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if ( $TRANS_FLAG1 == "3" )
{
$TRANS_NAME = "归还";
$TOK = strtok( $BORROWER1, "," );
$query1 = "select USER_NAME from USER where USER_ID='".$TOK."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$BORROWER_NAME = $ROW['USER_NAME'];
}
}
if ( $TRANS_FLAG1 == "4" )
{
$TRANS_QTY *= -1;
$TRANS_NAME = "报废";
$BORROWER_NAME = "";
}
}
}
echo "<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n";
if ( $TRANS_ID == "" )
{
echo " <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 新建办公用品登记</span>\r\n </td>\r\n";
}
else
{
echo " <td class=\"Big\"><img src=\"/images/edit.gif\" align=\"absmiddle\" width=\"20\" height=\"20\"><span class=\"big3\"> 修改办公用品登记</span>\r\n </td>\r\n";
}
echo " </tr>\r\n</table>\r\n<br>\r\n<table width=\"70%\" align=\"center\" class=\"TableBlock\">\r\n <form enctype=\"multipart/form-data\" action=\"add.php\" method=\"post\" name=\"form1\">\r\n <tr>\r\n <td nowrap class=\"TableData\">登记类型：</td>\r\n <td class=\"TableData\">\r\n <select name=\"TRANS_FLAG\" class=\"BigSelect\" onChange=\"sel_change()\">\r\n <option value=\"-1\">---请选择---</option>\r\n <option value=\"0\" ";
if ( $TRANS_FLAG1 == "0" )
{
echo "selected";
}
echo ">采购入库</option>\r\n <option value=\"1\" ";
if ( $TRANS_FLAG1 == "1" )
{
echo "selected";
}
echo ">领用</option>\r\n <option value=\"2\" ";
if ( $TRANS_FLAG1 == "2" )
{
echo "selected";
}
echo ">借用</option>\r\n <option value=\"3\" ";
if ( $TRANS_FLAG1 == "3" )
{
echo "selected";
}
echo ">归还</option>\r\n <option value=\"4\" ";
if ( $TRANS_FLAG1 == "4" )
{
echo "selected";
}
echo ">报废</option>\r\n </select>\r\n\r\n </td>\r\n </tr>\r\n <tr id=\"BORROWER\" style=";
if ( $TRANS_FLAG1 == "1" || $TRANS_FLAG1 == "2" || $TRANS_FLAG1 == "3" )
{
echo "";
}
else
{
echo "display:none";
}
echo ">\r\n <td nowrap id=\"t1\" class=\"TableData\" style=";
if ( $TRANS_FLAG1 == "1" )
{
echo "";
}
else
{
echo "display:none";
}
echo ">领用人：</td>\r\n <td nowrap id=\"t2\" class=\"TableData\" style=";
if ( $TRANS_FLAG1 == "2" )
{
echo "";
}
else
{
echo "display:none";
}
echo ">借用人：</td>\r\n <td nowrap id=\"t3\" class=\"TableData\" style=";
if ( $TRANS_FLAG1 == "3" )
{
echo "";
}
else
{
echo "display:none";
}
echo ">归还人：</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"TO_ID\" value=\"";
echo $BORROWER1;
echo "\">\r\n <input type=\"text\" name=\"TO_NAME\" size=\"20\" class=\"BigStatic\" maxlength=\"20\" value=\"";
echo $BORROWER_NAME;
echo "\" readonly>\r\n <a href=\"javascript:;\" class=\"orgAdd\" onClick=\"SelectUserSingle('','TO_ID', 'TO_NAME','1')\">选择</a>\r\n <a href=\"javascript:;\" class=\"orgClear\" onClick=\"ClearUser('TO_ID', 'TO_NAME')\">清空</a>\r\n </td>\r\n </tr>\r\n\r\n <tr id=\"COST\" style=";
if ( $TRANS_FLAG1 == "0" )
{
echo "";
}
else
{
echo "display:none";
}
echo ">\r\n\r\n <td nowrap class=\"TableData\">单价：</td>\r\n <td class=\"TableData\">\r\n";
if ( $PRICE == "" )
{
echo " \t<input type=\"text\" name=\"PRICE\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"0.0\">\r\n";
}
else
{
echo " <input type=\"text\" name=\"PRICE\" size=\"20\" maxlength=\"20\" class=\"BigInput\" value=\"";
echo $PRICE;
echo "\">\r\n\r\n";
}
echo " </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 "\" ";
if ( $PROID == $PRO_ID1 )
{
echo "selected";
}
echo ">";
echo $PRONAME;
echo "/库存";
echo $PROSTOCK;
echo $PROUNIT;
echo "</option>\r\n\r\n";
}
echo " </select>\r\n <!--<input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow2()\" title=\"选择办公用品\" name=\"button\">-->\r\n </td>\r\n </tr>\r\n\r\n\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=\"";
echo $TRANS_QTY;
echo "\">\r\n </td>\r\n </tr>\r\n\r\n\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\">";
echo $REMARK;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tfoot align=\"center\" class=\"TableFooter\">\r\n <td colspan=\"2\" nowrap>\r\n <input type=\"hidden\" name=\"TRANS_ID\" value=\"";
echo $TRANS_ID;
echo "\">\r\n <input type=\"hidden\" name=\"TTYPE\" value=\"";
echo $TTYPE;
echo "\">\r\n <input type=\"hidden\" name=\"OLD_BORROWER\" value=\"";
echo $BORROWER2;
echo "\">\r\n <input type=\"hidden\" value=\"TRANS_FLAG=";
echo $TRANS_FLAG;
echo "&TRUN=1&PRO_ID=";
echo $PRO_ID;
echo "&PRO_NAME=";
echo $PRO_NAME;
echo "&FROM_DATE=";
echo $FROM_DATE;
echo "&TO_DATE=";
echo $TO_DATE;
echo "&BORROWER=";
echo $BORROWER;
echo "\" name=\"QUERY_LIST\">\r\n <input type=\"button\" value=\"确认\" class=\"BigButton\" onClick=\"CheckForm();\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"PageBack()\">\r\n </td>\r\n </tfoot>\r\n </table>\r\n</form>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -