record.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 201 行
PHP
201 行
<?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\">\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\r\n\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\n\r\nfunction clear_dept1()\r\n{\r\n\r\n  document.form1.TO_ID.value=\"\";\r\n\tdocument.form1.TO_NAME.value=\"\";\r\n}\r\n\r\nfunction LoadWindow1()\r\n{\r\n  URL=\"/module/user_select_single?MANAGE_FLAG=1\";\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:265px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\nfunction td_calendar(fieldname)\r\n{\r\n  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;\r\n  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;\r\n\r\n  window.showModalDialog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\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'];
		$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\">&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 border=\"0\" width=\"70%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n  <form enctype=\"multipart/form-data\" action=\"add.php\"  method=\"post\" name=\"form1\">\r\n    <tr>\r\n      <td nowrap class=\"TableData\" width=20%>登记类型：</td>\r\n      <td class=\"TableData\">\r\n           ";
if ( $TRANS_FLAG1 == "0" )
{
	echo "采购入库";
}
echo "           ";
if ( $TRANS_FLAG1 == "1" )
{
	echo "领用";
}
echo "           ";
if ( $TRANS_FLAG1 == "2" )
{
	echo "借用";
}
echo "           ";
if ( $TRANS_FLAG1 == "3" )
{
	echo "归还";
}
echo "           ";
if ( $TRANS_FLAG1 == "4" )
{
	echo "报废";
}
echo "      </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\">";
echo $BORROWER_NAME;
echo "</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";
echo $PRICE;
echo "      </td>\r\n   </tr>\r\n  \t<tr>\r\n      <td nowrap class=\"TableData\">办公用品：</td>\r\n      <td class=\"TableData\">\r\n";
$query = "SELECT * from OFFICE_PRODUCTS where PRO_ID='".$PRO_ID1."'";
$connection = openconnection( );
$cursor = exequery( $connection, $query );
$VOTE_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PRONAME = $ROW['PRO_NAME'];
	$PROSTOCK = $ROW['PRO_STOCK'];
	$PROUNIT = $ROW['PRO_UNIT'];
	echo "               ";
	echo $PRONAME;
	echo "/库存";
	echo $PROSTOCK;
	echo $PROUNIT;
}
echo "       </td>\r\n      </tr>\r\n\r\n\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\r\n\r\n     <tr>\r\n      <td nowrap class=\"TableData\">备注：</td>\r\n      <td class=\"TableData\">";
echo $REMARK;
echo "</td>\r\n    </tr>\r\n    <tr align=\"center\" class=\"TableControl\">\r\n      <td colspan=\"2\" nowrap>\r\n        <input type=\"hidden\" name=\"TRANS_ID\" value=\"";
echo $TRANS_ID;
echo "\">\r\n        <input type=\"hidden\" value=\"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 "\" name=\"QUERY_LIST\">\r\n        <input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='detail.php?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 "'\">\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</form>\r\n</body>\r\n</html>";
?>
record.php - 源码说明

本页面展示了「极限网络智能办公系统 - Office Automation 2008 官方100％源码」中的 record.php 源码文件，采用 PHP 编程语言编写，共 201 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。
虫虫下载站收录了大量与Automation相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。
⌨️ 快捷键说明

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