index1.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 679 行 · 第 1/2 页
PHP
679 行
<?php
 

function GETALLDATE( $CODE, $GETVALUE )
{
	global $connection;
	$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
	$connection = openconnection( );
	$cursor = exequery( $connection, $query );
	echo "<option value= ></option>";
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$CODE_NO = $ROW['CODE_NO'];
		$CODE_NAME = $ROW['CODE_NAME'];
		if ( $CODE_NO == $GETVALUE )
		{
			echo "<option value=".$CODE_NO."  selected>".$CODE_NAME."</option>";
		}
		else
		{
			echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";
		}
	}
}

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$PAGE_SIZE = 10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$MANAGER_ID = $ROW['MANAGER_ID'];
	$MANAGERS = $ROW['MANAGERS'];
}
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<script Language=\"JavaScript\">\r\n\r\nvar sel_wirehouse;\r\nvar sel_place;\r\n\r\nvar wirehouse=new Array(\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 " new Array(\"";
	echo $WH_ID;
	echo "\",\"";
	echo $WH_NAME;
	echo "\"),\r\n";
}
echo "new Array(\"0\",\"\")\r\n);\r\n\r\nvar place=new Array(\r\n";
$query = "SELECT * from WIREHOUSE_PLACE where PLACE_OPEN=0 order by PLACE_NO";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$PLACE_ID = $ROW['PLACE_ID'];
	$PLACE_NAME = $ROW['PLACE_NAME'];
	$WH_ID = $ROW['WH_ID'];
	echo "new Array(\"";
	echo $WH_ID;
	echo "\",\"";
	echo $PLACE_ID;
	echo "\",\"";
	echo $PLACE_NAME;
	echo "\"),\r\n";
}
echo "new Array(\"0\",\"0\",\"\")\r\n);\r\n\r\nfunction FillWirehouse(selwirehouse)\r\n{\r\n    selwirehouse.options[0]=new Option(\"选择仓库\",\"0\");\r\n    for(i=0;i<wirehouse.length;i++)\r\n    {\r\n        selwirehouse.options[i+1]=new Option(wirehouse[i][1],wirehouse[i][0]);\r\n    }\r\n    selwirehouse.options[0].selected=true;\r\n    selwirehouse.length=i;\r\n}\r\n\r\nfunction FillPlace(selplace,Code)\r\n{\r\n    selplace.options[0]=new Option(\"选择库位\",\"0\");\r\n    count=1;\r\n    for(i=0;i<place.length;i++)\r\n    {\r\n        if(place[i][0].toString()==Code)\r\n        {\r\n            selplace.options[count]=new Option(place[i][2],place[i][1]);\r\n            count=count+1;\r\n        }\r\n    }\r\n    selplace.options[0].selected=true;\r\n    selplace.length=count;\r\n}\r\n\r\nfunction wirehouse_onchange()\r\n{\r\n    FillPlace(sel_place,sel_wirehouse.value);\r\n}\r\n\r\nfunction InitSelSelect(selwirehouse,selplace)\r\n{\r\n    sel_wirehouse=selwirehouse;\r\n    sel_place=selplace;\r\n    selwirehouse.onchange=Function(\"wirehouse_onchange();\");\r\n    FillWirehouse(selwirehouse);\r\n}\r\n\r\n  function delete_customer(STOCK_ID)\r\n{\r\n msg='确认要删除该库存记录？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&STOCK_ID=\" + STOCK_ID;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\nfunction set_page()\r\n{\r\n PAGE_START=PAGE_NUM.value;\r\n location=\"index1.php?PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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 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\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(\"flow_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      document.all(\"flow_select\").item(i).checked=true;\r\n   else\r\n      document.all(\"flow_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(\"flow_select\").checked=true;\r\n   else\r\n      document.all(\"flow_select\").checked=false;\r\n }\r\n}\r\nfunction delete_mail()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"flow_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"flow_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(\"flow_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?WH_ID=";
echo $WH_ID;
echo "&PLACE_ID=";
echo $PLACE_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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\r\n\r\nfunction detail(PRODUCT_ID)\r\n{\r\n URL=\"detail.php?PRODUCT_ID=\"+PRODUCT_ID;\r\n myleft=(screen.availWidth-500)/2;\r\n window.open(URL,\"read_notify\",\"height=240,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\n</script>\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=\"PRODUCT_MODE\" class=\"SmallSelect\">\r\n";
getalldate( "PRODUCT_MODE", $PRODUCT_MODE );
echo "      </select>\r\n    </td>\r\n    <td nowrap class=\"TableData\">产品名称： </td>\r\n    <td nowrap class=\"TableData\">\r\n        <input type=\"text\" name=\"PRODUCT_NAME\" class=\"SmallInput\" value=\"";
echo $PRODUCT_NAME;
echo "\" size=\"15\" maxlength=\"100\">\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_TYPE\" class=\"SmallInput\" value=\"";
echo $PRODUCT_TYPE;
echo "\" 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<td nowrap class=\"TableData\"  colspan=\"3\">\r\n<SELECT id=WH_ID0 size=1 name=WH_ID0 class='SmallSelect'>\r\n   <OPTION selected></OPTION>\r\n </SELECT>\t\t  \r\n <SELECT id=PLACE_ID0 size=1 name=PLACE_ID0 class='SmallSelect'>\r\n    <OPTION selected></OPTION>\r\n </SELECT>\r\n  <SCRIPT language=javascript>\r\nInitSelSelect(document.form1.WH_ID0,document.form1.PLACE_ID0);\r\n </SCRIPT>\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=\"7\" >\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";
$WHERE_STR .= " where a.PRODUCT_ID<>0 and a.WH_ID<>0";
if ( $PRODUCT_NAME != "" )
{
	$WHERE_STR .= " and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
}
if ( $PRODUCT_MODE != "" )
{
	$WHERE_STR .= " and c.PRODUCT_MODE ='".$PRODUCT_MODE."'";
}
if ( $PRODUCT_TYPE != "" )
{
	$WHERE_STR .= " and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
}
if ( $WH_ID0 != "" && $WH_ID0 != 0 )
{
	$WHERE_STR .= " and a.WH_ID ='".$WH_ID0."'";
}
if ( $PLACE_ID0 != "" && $PLACE_ID0 != 0 )
{
	$WHERE_STR .= " and a.PLACE_ID ='".$PLACE_ID0."'";
}
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 ( $ORDERFIELD != "" )
{
	if ( $ORDERSIGN == "DOWN" )
	{
		$ORDERTYPE = "ASC";
	}
	if ( $ORDERSIGN == "UP" )
	{
		$ORDERTYPE = "DESC";
	}
	$OREDERBY = " ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT = 0;
$query = "SELECT count(*) from STOCK a\r\n        LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID\r\n         LEFT OUTER JOIN SALE_HISTORY  f ON f.HISTORY_ID=a.HISTORY_ID\r\n        LEFT OUTER JOIN USER  e ON f.SALESMAN=e.USER_ID\r\n        ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$CUSTOMER_COUNT = $ROW[0];
}
$PER_PAGE = 10;
$PAGE_COUNT = ceil( $CUSTOMER_COUNT / $PER_PAGE );
if ( $CUR_PAGE <= 0 || $CUR_PAGE == "" )
{
	$CUR_PAGE = 1;
}
if ( $PAGE_COUNT < $CUR_PAGE )
{
	$CUR_PAGE = $PAGE_COUNT;
}
$query1 = "SELECT c.PRODUCT_ID,c.PRODUCT_NAME as PRODUCT_NAME,a.PRICE as PRICE,a.AMT as AMT,a.PRICE*a.AMT as TOTAL_PRICE,a.ADD_TIME as ADD_TIME,e.USER_NAME as SELLER,a.STOCK_ID as STOCK_ID,a.USER_ID as USER_ID,b.WH_NAME,d.PLACE_NAME\r\n         from STOCK a\r\n         LEFT OUTER JOIN WIREHOUSE  b ON a.WH_ID=b.WH_ID\r\n         LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID\r\n         LEFT OUTER JOIN WIREHOUSE_PLACE  d ON a.PLACE_ID=d.PLACE_ID\r\n         LEFT OUTER JOIN SALE_HISTORY  f ON f.HISTORY_ID=a.HISTORY_ID\r\n         LEFT OUTER JOIN USER  e ON f.SALESMAN=e.USER_ID\r\n         ".$WHERE_STR.$OREDERBY;
$offest = ( $CUR_PAGE - 1 ) * 10;
$query1 = $query1." LIMIT ".$offest." ,".$PER_PAGE;
$cursor1 = exequery( $connection, $query1 );
if ( $CUSTOMER_COUNT == 0 )
{
	message( "<br>提示", "没有符合条件的库存记录" );
	exit( );
}
echo "\r\n<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&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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 "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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 "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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 "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
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 $CUSTOMER_COUNT;
echo "&nbsp;条\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n  <form action=\"index1.php\"  method=\"post\" name=\"form2\">\r\n  <tr class=\"TableHeader\">\r\n      <td nowrap align=\"center\"><a href=\"index1.php?PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&WH_ID0=";
echo $WH_ID0;
echo "&PLACE_ID0=";
echo $PLACE_ID0;
echo "&DATE1=";
echo $DATE1;
echo "&DATE2=";
echo $DATE2;
echo "&ORDERFIELD=PRODUCT_NAME&ORDERSIGN=";
if ( $ORDERSIGN == "DOWN" )
{
	echo "UP";
}
if ( $ORDERSIGN == "UP" )
{
	echo "DOWN";
}
if ( $ORDERSIGN == "" )
{
	if ( $ORDERTYPE == "ASC" )
	{
		echo "UP";
	}
	else
	{
		echo "DOWN";
	}
}
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\">产品名称&nbsp;";
if ( $ORDERTYPE == "DESC" && $ORDERFIELD == "PRODUCT_NAME" )
{
	echo "<img src=\"/images/arrow_down.gif\" align=\"absmiddle\" border=0>";
}
if ( $ORDERTYPE == "ASC" && $ORDERFIELD == "PRODUCT_NAME" )
{
	echo "<img src=\"/images/arrow_up.gif\" align=\"absmiddle\" border=0>";
}
echo "</a></td>\r\n      <td nowrap align=\"center\"><a href=\"index1.php?PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PRODUCT_TYPE=";
index1.php - 源码说明

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

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