⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 record.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?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<script Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n  if(document.form1.TRANS_FLAG.value==\"-1\")\r\n  { \r\n     alert(\"请选择登记类型！\");\r\n     form1.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     if (document.form1.TO_ID.value==\"\")\r\n     {\r\n        if(document.form1.TRANS_FLAG.value==\"1\")\r\n   \t   alert( \"领用人不能为空！\");\r\n        if(document.form1.TRANS_FLAG.value==\"2\")\r\n           alert( \"借用人不能为空！\");\r\n   \tif(document.form1.TRANS_FLAG.value==\"3\")\r\n           alert( \"归还人不能为空！\");\r\n        return (false);\r\n     }\r\n   }\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(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 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.showModalDialog(URL,self,\"edge:raised;scroll:1;status:0;help:0;resizable:1;dialogWidth:320px;dialogHeight:505px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\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\nfunction sel_change()\r\n{\r\n   document.form1.TO_ID.value=\"\";\r\n   document.form1.TO_NAME.value=\"\";\r\n   document.form1.PRICE.value=\"\";\r\n   if(form1.TRANS_FLAG.value==\"-1\")\r\n   {\r\n      if(document.all(\"BORROWER\").style.display==\"\")\r\n         document.all(\"BORROWER\").style.display=\"none\";\r\n      if(document.all(\"COST\").style.display==\"\")\r\n         document.all(\"COST\").style.display=\"none\";\r\n   }\r\n   if(form1.TRANS_FLAG.value==\"0\")\r\n   {\r\n      if(document.all(\"BORROWER\").style.display==\"\")\r\n         document.all(\"BORROWER\").style.display=\"none\";\r\n      document.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\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 ((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 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";
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_ID = $ROW['PRO_ID'];
		$BORROWER = $ROW['BORROWER'];
		$TRANS_FLAG = $ROW['TRANS_FLAG'];
		$TRANS_QTY = $ROW['TRANS_QTY'];
		$PRICE = $ROW['PRICE'];
		$TRANS_DATE = $ROW['TRANS_DATE'];
		$OPERATOR = $ROW['OPERATOR'];
		$REMARK = $ROW['REMARK'];
		if ( $TRANS_FLAG == "0" )
		{
			$TRANS_NAME = "采购入库";
			$BORROWER_NAME = "";
		}
		if ( $TRANS_FLAG == "1" )
		{
			$TRANS_QTY *= -1;
			$TRANS_NAME = "领用";
			$TOK = strtok( $BORROWER, "," );
			$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_FLAG == "2" )
		{
			$TRANS_QTY *= -1;
			$TRANS_NAME = "借用";
			$TOK = strtok( $BORROWER, "," );
			$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_FLAG == "3" )
		{
			$TRANS_NAME = "归还";
			$TOK = strtok( $BORROWER, "," );
			$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_FLAG == "4" )
		{
			$TRANS_QTY *= -1;
			$TRANS_NAME = "报废";
			$BORROWER_NAME = "";
		}
		$query1 = "select OFFICE_PROTYPE from OFFICE_PRODUCTS  where PRO_ID='".$PRO_ID."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW = mysql_fetch_array( $cursor1 ) )
		{
			$OFFICE_PROTYPE = $ROW['OFFICE_PROTYPE'];
		}
	}
}
else
{
	$query1 = "select OFFICE_PROTYPE from OFFICE_PRODUCTS  where PRO_ID='".$THISPRO_ID."'";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$OFFICE_PROTYPE = $ROW['OFFICE_PROTYPE'];
	}
	$PRO_ID = $THISPRO_ID;
}
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\">&nbsp;新建库存登记</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\">&nbsp;修改库存登记</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_FLAG == "0" )
{
	echo "selected";
}
echo ">采购入库</option>\r\n           <option value=\"1\" ";
if ( $TRANS_FLAG == "1" )
{
	echo "selected";
}
echo ">领用</option>\r\n           <option value=\"2\" ";
if ( $TRANS_FLAG == "2" )
{
	echo "selected";
}
echo ">借用</option>\r\n           <option value=\"3\" ";
if ( $TRANS_FLAG == "3" )
{
	echo "selected";
}
echo ">归还</option>\r\n           <option value=\"4\" ";
if ( $TRANS_FLAG == "4" )
{
	echo "selected";
}
echo ">报废</option>\r\n        </select>\r\n      </td>\r\n    </tr>\r\n    <tr id=\"BORROWER\" style=";
if ( $TRANS_FLAG == "1" || $TRANS_FLAG == "2" || $TRANS_FLAG == "3" )
{
	echo "";
}
else
{
	echo "display:none";
}
echo ">\r\n      <td nowrap id=\"t1\" class=\"TableData\" style=";
if ( $TRANS_FLAG == "1" )
{
	echo "";
}
else
{
	echo "display:none";
}
echo ">领用人：</td>\r\n      <td nowrap id=\"t2\" class=\"TableData\" style=";
if ( $TRANS_FLAG == "2" )
{
	echo "";
}
else
{
	echo "display:none";
}
echo ">借用人：</td>\r\n      <td nowrap id=\"t3\" class=\"TableData\" style=";
if ( $TRANS_FLAG == "3" )
{
	echo "";
}
else
{
	echo "display:none";
}
echo ">归还人：</td>\r\n      <td class=\"TableData\">\r\n        <input type=\"hidden\" name=\"TO_ID\" value=\"";
echo $BORROWER;
echo "\">\r\n        <input type=\"text\" name=\"TO_NAME\" size=\"20\" class=\"BigStatic\" maxlength=\"20\"  value=\"";
echo $BORROWER_NAME;
echo "\" readonly>\r\n        &nbsp;<input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"SelectUserSingle('','TO_ID','TO_NAME')\" title=\"选择\" name=\"button\">\r\n        &nbsp;<input type=\"button\" value=\"清 空\" class=\"SmallButton\" onClick=\"ClearUser()\" title=\"清空\" name=\"button\">\r\n      </td>\r\n    </tr>\r\n\r\n   <tr id=\"COST\" style=";
if ( $TRANS_FLAG == "0" )
{
	echo "";
}
else
{
	echo "display:none";
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -