index1.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 383 行
PHP
383 行
<?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>\r\nfunction order_by(field,asc_desc)\r\n{\r\n\twindow.location=\"index1.php?CUR_PAGE=";
echo $CUR_PAGE;
echo "&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&FIELD=\"+field+\"&ASC_DESC=\"+asc_desc;\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 set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index1.php?&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=\"+PAGE_START;\r\n}\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      document.all(\"allbox\").checked=false;\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"exchange_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"exchange_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"exchange_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"exchange_select\").checked=true;\r\n   else\r\n      document.all(\"exchange_select\").checked=false;\r\n }\r\n}\r\nfunction delete_exchange()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"exchange_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"exchange_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(i==0)\r\n  {\r\n      el=document.all(\"exchange_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"请至少选择其中一条调拨记录。\");\r\n     return;\r\n  }\r\n  \r\n  msg='确认要删除么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    URL=\"delete.php?&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&delete_str=\" + delete_str;\r\n    window.location=URL;\r\n  }\r\n}\r\n</script>\r\n\r\n</head>\r\n<body topmargin=\"5\" class=\"bodycolor\">\r\n<div align=\"left\">\r\n<fieldset style=\"width:95%;padding-bottom:5px;\">\r\n\t <legend class=\"small\" align=left>\r\n      <b>快速查询</b>\r\n  </legend>\r\n<table class=\"TableList\" align=\"left\" width=\"100%\">\r\n  <form action=\"index1.php\"  method=\"post\" name=\"form1\">\r\n <tr>\r\n \t<td nowrap class=\"TableData\">&nbsp;&nbsp;调出库：</td>\r\n    <td nowrap class=\"TableData\">\r\n        <select name='FROM_ID' class='SmallSelect'>\r\n        <option value=''></option>\r\n";
$query = "SELECT * from WIREHOUSE where WH_OPEN=0 order by WH_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WH_ID = $ROW['WH_ID'];
	$WH_NAME = $ROW['WH_NAME'];
	echo "        <option value='";
	echo $WH_ID;
	echo "'";
	if ( $FROM_ID == $WH_ID )
	{
		echo " selected";
	}
	echo ">";
	echo $WH_NAME;
	echo "</option>\r\n";
}
echo "        </select>\r\n      </select>\r\n    </td>\r\n    <td nowrap class=\"TableData\">调入库： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <select name='TO_ID' class='SmallSelect'>\r\n        <option value=''></option>\r\n";
$query = "SELECT * from WIREHOUSE where WH_OPEN=0 order by WH_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WH_ID = $ROW['WH_ID'];
	$WH_NAME = $ROW['WH_NAME'];
	echo "        <option value='";
	echo $WH_ID;
	echo "'";
	if ( $TO_ID == $WH_ID )
	{
		echo " selected";
	}
	echo ">";
	echo $WH_NAME;
	echo "</option>\r\n";
}
echo "        </select>\r\n    </td>\r\n   <td nowrap class=\"TableData\">产品名称： </td>\r\n    <td nowrap class=\"TableData\"  colspan=\"3\">\r\n        <input type=\"text\" name=\"PRODUCT_NAME\" value=\"";
echo $PRODUCT_NAME;
echo "\" class=\"SmallInput\" size=\"15\" maxlength=\"100\">\r\n    </td>\r\n   </tr>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\">&nbsp;&nbsp;数目： </td>\r\n\t<td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"COUNT0\" value=\"";
echo $COUNT0;
echo "\" class=\"SmallInput\" size=\"5\" maxlength=\"50\">\r\n\t\t-\r\n        <input type=\"text\" name=\"COUNT1\" value=\"";
echo $COUNT1;
echo "\" class=\"SmallInput\" size=\"5\" maxlength=\"50\">\r\n\t</td>\r\n \t<td nowrap class=\"TableData\">备注： </td>\r\n\t<td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"REMARK\" value=\"";
echo $REMARK;
echo "\" class=\"SmallInput\" size=\"20\" maxlength=\"50\">\r\n\t</td>\r\n \t<td nowrap class=\"TableData\">操作时间： </td>\r\n \t<td nowrap class=\"TableData\">\r\n      <input type=\"text\" name=\"DATE1\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $DATE1;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.DATE1');\">\r\n       至<input type=\"text\" name=\"DATE2\" size=\"15\" maxlength=\"10\" class=\"SmallStatic\" readonly value=\"";
echo $DATE2;
echo "\">\r\n        <img src=\"/images/menu/calendar.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.DATE2');\">\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\"  colspan=\"6\" >\r\n \t&nbsp;<input value=\"快速查询\" type=\"submit\" class=\"SmallButton\" title=\"快速查询\" name=\"button\">\r\n  </td>\r\n </tr>\r\n</form>\r\n</table>\r\n</fieldset>\r\n</div>\r\n<br>\r\n\r\n";
$WHERE_STR .= " where 1=1 ";
if ( $FROM_ID != "" )
{
	$WHERE_STR .= " and a.FROM_ID='".$FROM_ID."'";
}
if ( $TO_ID != "" )
{
	$WHERE_STR .= " and a.TO_ID='".$TO_ID."'";
}
if ( $PRODUCT_NAME != "" )
{
	$WHERE_STR .= " and d.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if ( $REMARK != "" )
{
	$WHERE_STR .= " and a.REMARK like '%".$REMARK."%'";
}
if ( $COUNT0 != "" )
{
	$WHERE_STR .= "  and a.COUNT>='".$COUNT0."'";
}
if ( $COUNT1 != "" )
{
	$WHERE_STR .= "  and a.COUNT<='".$COUNT1."'";
}
if ( $DATE1 != "" )
{
	$WHERE_STR .= "  and a.ADD_TIME>='".$DATE1." 00:00:00'";
}
if ( $DATE2 != "" )
{
	$WHERE_STR .= "  and a.ADD_TIME<='".$DATE2." 23:59:59'";
}
if ( $LOGIN_USER_PRIV == "1" )
{
	$query = "SELECT count(*) from EXCHANGE a\r\n\tLEFT OUTER JOIN WIREHOUSE b ON a.FROM_ID = b.WH_ID \r\n\tLEFT OUTER JOIN WIREHOUSE c ON a.TO_ID = c.WH_ID\r\n\tLEFT OUTER JOIN PRODUCT d ON a.PRODUCT_ID = d.PRODUCT_ID".$WHERE_STR;
}
else
{
	$query = "SELECT count(*) from EXCHANGE a\r\n\tLEFT OUTER JOIN WIREHOUSE b ON a.FROM_ID = b.WH_ID \r\n\tLEFT OUTER JOIN WIREHOUSE c ON a.TO_ID = c.WH_ID\r\n\tLEFT OUTER JOIN PRODUCT d ON a.PRODUCT_ID = d.PRODUCT_ID".$WHERE_STR." and `USER_ID`='{$LOGIN_USER_ID}'";
}
$cursor = exequery( $connection, $query );
$EXCHANGE_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$EXCHANGE_COUNT = $ROW[0];
}
if ( $EXCHANGE_COUNT == 0 )
{
	message( "", "无库存调拨记录" );
	exit( );
}
$PER_PAGE = 15;
$PAGES = 10;
$PAGE_COUNT = ceil( $EXCHANGE_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
	$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
echo "<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr>\r\n    <td align=\"left\">\r\n        <a href=\"index1.php?CUR_PAGE=1&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>\r\n        <a href=\"index1.php?CUR_PAGE=";
echo $CUR_PAGE - 1;
echo "&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>\r\n        <a href=\"index1.php?CUR_PAGE=";
echo $CUR_PAGE + 1;
echo "&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style=\"cursor:hand\"></a>\r\n        <a href=\"index1.php?CUR_PAGE=";
echo $PAGE_COUNT;
echo "&FROM_ID=";
echo $FROM_ID;
echo "&TO_ID=";
echo $TO_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&COUNT0=";
echo $COUNT0;
echo "&COUNT1=";
echo $COUNT1;
echo "&REMARK=";
echo $REMARK;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "\"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style=\"cursor:hand\"></a>\r\n\r\n      到\r\n      <input type=\"text\" name=\"PAGE_NUM\" size=\"3\" maxlength=\"4\"  class=\"SmallInput\">\r\n      页\r\n      <img id=\"btnGotoPage\" src=\"/images/menu/book.gif\" onclick=\"set_page()\" border=\"0\" WIDTH=\"19\" HEIGHT=\"17\" style=\"cursor:hand\" alt=\"转到相应页面\">\r\n    </td>\r\n    <td align=\"right\">\r\n      ";
echo $CUR_PAGE;
echo "/";
echo $PAGE_COUNT;
echo "页&nbsp;共&nbsp;";
echo $EXCHANGE_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n";
if ( $ASC_DESC == "" )
{
	$ASC_DESC = "1";
}
if ( $FIELD == "" )
{
	$FIELD = "ADD_TIME";
}
if ( $LOGIN_USER_PRIV == "1" )
{
	$query = "SELECT a.*,b.WH_NAME WH_NAME0,c.WH_NAME WH_NAME1,d.PRODUCT_NAME from EXCHANGE a \r\n\tLEFT OUTER JOIN WIREHOUSE b ON a.FROM_ID = b.WH_ID \r\n\tLEFT OUTER JOIN WIREHOUSE c ON a.TO_ID = c.WH_ID\r\n\tLEFT OUTER JOIN PRODUCT d ON a.PRODUCT_ID = d.PRODUCT_ID".$WHERE_STR;
}
else
{
	$query = "SELECT a.*,b.WH_NAME WH_NAME0,c.WH_NAME WH_NAME1,d.PRODUCT_NAME from EXCHANGE a \r\n\tLEFT OUTER JOIN WIREHOUSE b ON a.FROM_ID = b.WH_ID \r\n\tLEFT OUTER JOIN WIREHOUSE c ON a.TO_ID = c.WH_ID \r\n\tLEFT OUTER JOIN PRODUCT d ON a.PRODUCT_ID = d.PRODUCT_ID\r\n\t".$WHERE_STR." and `USER_ID`='{$LOGIN_USER_ID}'";
}
$query .= " order by ".$FIELD;
if ( $ASC_DESC == "1" )
{
	$query .= " desc";
}
else
{
	$query .= " asc";
}
if ( $ASC_DESC == "0" )
{
	$ORDER_IMG = "<img border=0 src=\"/images/arrow_up.gif\" width=\"11\" height=\"10\">";
}
else
{
	$ORDER_IMG = "<img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\">";
}
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n  \t  <td nowrap align=\"center\">选择</td>\r\n      <td nowrap align=\"center\" onclick=\"order_by('FROM_ID','";
if ( $FIELD == "FROM_ID" )
{
	echo 1 - $ASC_DESC;
}
else
{
	echo "1";
}
echo "');\" style=\"cursor:hand;\"><u>调出库</u>";
if ( $FIELD == "FROM_ID" )
{
	echo $ORDER_IMG;
}
echo "</td>\r\n      <td nowrap align=\"center\">调入库</td>\r\n      <td nowrap align=\"center\">产品名称</td>\r\n      <td nowrap align=\"center\">数目</td>\r\n      <td nowrap align=\"center\">操作时间</td>\r\n      <td nowrap align=\"center\">操作</td>\r\n    </tr>\r\n\r\n";
$cursor = exequery( $connection, $query );
$EXCHANGE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$EXCHANGE_COUNT;
	if ( !( $EXCHANGE_COUNT < $CUR_PAGE * $PER_PAGE - $PER_PAGE + 1 ) )
	{
		if ( $CUR_PAGE * $PER_PAGE < $EXCHANGE_COUNT )
		{
			break;
		}
		$EXCHANGE_ID = $ROW['EXCHANGE_ID'];
		$WH_NAME0 = $ROW['WH_NAME0'];
		$WH_NAME1 = $ROW['WH_NAME1'];
		$PRODUCT_NAME = $ROW['PRODUCT_NAME'];
		$COUNT = $ROW['COUNT'];
		$ADD_TIME = $ROW['ADD_TIME'];
		if ( $EXCHANGE_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "    <tr class=\"";
		echo $TableLine;
		echo "\">\r\n      <td>&nbsp;<input type=\"checkbox\" name=\"exchange_select\" value=\"";
		echo $EXCHANGE_ID;
		echo "\" onClick=\"check_one(self);\"></td>\r\n      <td align=\"center\">";
		echo $WH_NAME0;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $WH_NAME1;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $PRODUCT_NAME;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $COUNT;
		echo "</td>\r\n      <td nowrap align=\"center\">";
		echo $ADD_TIME;
		echo "</td>\r\n      <td nowrap align=\"center\">\r\n      <a href=\"modify.php?&FROM_ID=";
		echo $FROM_ID;
		echo "&TO_ID=";
		echo $TO_ID;
		echo "&PRODUCT_NAME=";
		echo $PRODUCT_NAME;
		echo "&COUNT0=";
		echo $COUNT0;
		echo "&COUNT1=";
		echo $COUNT1;
		echo "&REMARK=";
		echo $REMARK;
		echo "&DATE1=";
		echo $DATE1;
		echo "&DATE2=";
		echo $DATE2;
		echo "&EXCHANGE_ID=";
		echo $EXCHANGE_ID;
		echo "&CUR_PAGE=";
		echo $CUR_PAGE;
		echo "\"> 修改</a>\r\n      </td>\r\n    </tr>\r\n";
	}
}
echo "\r\n<tr class=\"TableControl\">\r\n<td colspan=\"9\">\r\n \t   &nbsp;<input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n      <label for=\"allbox_for\">全选</label> &nbsp;\r\n     <input type=\"button\"  value=\"批量删除\" class=\"SmallButton\" onClick=\"delete_exchange();\" title=\"删除所选库存记录\"> &nbsp;\r\n</td>\r\n</tr>\r\n\r\n</table>\r\n</body>\r\n\r\n</html>\r\n";
?>
index1.php - 源码说明

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

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