📄 modify.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 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\">\r\n";
$query = "SELECT * from SALE_CANCEL where CANCEL_ID='".$CANCEL_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WH_ID1 = $ROW['WH_ID'];
	$PLACE_ID1 = $ROW['PLACE_ID'];
	$USER_ID = $ROW['USER_ID'];
	$CUSTOMER_ID = $ROW['CUSTOMER_ID'];
	$BANK_NO = $ROW['BANK_NO'];
	$REMARK = $ROW['REMARK'];
	$query2 = "select * from USER where USER_ID='".$USER_ID."'";
	$cursor2 = exequery( $connection, $query2 );
	if ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		$USER_NAME1 = $ROW['USER_NAME'];
	}
	$query2 = "select * from CUSTOMER where CUSTOMER_ID='".$CUSTOMER_ID."'";
	$cursor2 = exequery( $connection, $query2 );
	if ( $ROW = mysql_fetch_array( $cursor2 ) )
	{
		$CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
	}
}
echo "\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 );
$WH_SEL = 0;
$I = 1;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$WH_ID = $ROW['WH_ID'];
	$WH_NAME = $ROW['WH_NAME'];
	if ( $WH_ID == $WH_ID1 )
	{
		$WH_SEL = $I;
	}
	++$I;
	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[";
echo $WH_SEL;
echo "].selected=true;\r\n    selwirehouse.length=i;\r\n}\r\n\r\nfunction FillPlace(selplace,Code,PLACE_SEL)\r\n{\r\n    selplace.options[0]=new Option(\"选择库位\",\"0\");\r\n    count=1;\r\n\tj=0;\r\n    for(i=0;i<place.length;i++)\r\n    {\r\n        if(place[i][0].toString()==Code)\r\n        {\r\n\t\t\tif(PLACE_SEL==place[i][1]) j=count;\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[j].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,0);\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\tFillPlace(sel_place,";
echo $WH_ID1;
echo ",";
echo $PLACE_ID1;
echo ");\r\n}\r\n\r\nfunction LoadWindow()\r\n{\r\n  URL=\"/module/user_select_single?ID=2\";\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.open(URL,\"read_notify\",\"height=400,width=550,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=150,resizable=yes\");\r\n  window.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\r\n}\r\n\r\nfunction LoadWindow3()\r\n{\r\n  URL=\"/general/sale_manage/crm/linkman/customer_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.WH_ID.value==\"\")\r\n   { alert(\"盘点仓库不能为空！\");\r\n     return (false);\r\n   }\r\n\r\n   if(document.form1.COPY_TO_ID.value==\"\")\r\n   { alert(\"盘点人不能为空！\");\r\n     return (false);\r\n   }\r\n\r\n   return (true);\r\n}\r\n\r\nfunction sendForm()\r\n{\r\n if(CheckForm()) document.form1.submit();\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n<table border=\"0\" width=\"90%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/notify_new.gif\" align=\"absmiddle\"><span class=\"big3\"> 销售退货编辑</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" width=\"95%\" cellpadding=\"2\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n  <form action=\"update.php\"  method=\"post\" name=\"form1\">\r\n  <input type='hidden' name='CANCEL_ID' value='";
echo $CANCEL_ID;
echo "'>\r\n  <tr>\r\n      <TD class=\"TableData\">客户名称：</TD>\r\n      <TD class=\"TableData\">\r\n      <input type=\"hidden\" name=\"CUSTOMER_ID\" value=\"";
echo $CUSTOMER_ID;
echo "\">\r\n      <input type=\"text\" name=\"CUSTOMER_NAME\" class=\"BigStatic\" size=\"15\" maxlength=\"100\" readonly value=\"";
echo $CUSTOMER_NAME;
echo "\">&nbsp;\r\n      <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow3()\" title=\"选择客户名称\" name=\"button\">\r\n      </TD>\r\n      <TD class=\"TableData\">经手人：</TD>\r\n      <TD class=\"TableData\">\r\n       <INPUT class=\"BigInput\" name=\"COPY_TO_ID\" id=\"COPY_TO_ID\" value=\"";
echo $USER_ID;
echo "\" type=hidden>\t\r\n       <INPUT class=\"BigStatic\" name=\"COPY_TO_NAME\" id=\"COPY_TO_NAME\" value=\"";
echo $USER_NAME1;
echo "\" readonly style=\"CURSOR: hand\" onclick=\"LoadWindow()\" size=20>\r\n        &nbsp;<input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow()\" title=\"选择人员\" name=\"button\">\r\n      </TD>\r\n  </TR>\r\n  <tr>\r\n      <TD class=\"TableData\">退货仓：</TD>\r\n      <TD class=\"TableData\">\r\n <SELECT id=WH_ID size=1 name=WH_ID class='SmallSelect'>\r\n   <OPTION selected></OPTION>\r\n </SELECT>\t\t  \r\n <SELECT id=PLACE_ID size=1 name=PLACE_ID class='SmallSelect'>\r\n    <OPTION selected></OPTION>\r\n </SELECT>\r\n  <SCRIPT language=javascript>\r\nInitSelSelect(document.form1.WH_ID,document.form1.PLACE_ID);\r\n </SCRIPT>\r\n      </TD>\r\n      <TD class=\"TableData\">收款帐户：</TD>\r\n      <TD class=\"TableData\">\r\n       <INPUT name=\"BANK_NO\" id=\"BANK_NO\" value=\"";
echo $BANK_NO;
echo "\" size=30 maxlength=\"100\" class=\"BigInput\">\r\n       </TD>\r\n  </TR>\r\n    <tr align=\"center\" class=\"TableControl\">\r\n      <td colspan=\"4\" nowrap>\r\n        <input type=\"button\" value=\"确认\" class=\"BigButton\" onclick=\"sendForm();\">&nbsp;&nbsp;\r\n      &nbsp;&nbsp;<input type=\"button\" value=\"返回\" class=\"BigButton\" onclick=\"location='index1.php'\">\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</form>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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