📄 edit.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
include_once( "inc/check_type.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";
echo "<s";
echo "cript Language=\"JavaScript\">\r\nfunction CheckForm()\r\n{\r\n   if(document.form1.CUSTOMER_ID.value==\"\")\r\n   {\r\n   \t\talert(\"销售记录名称不能为空！\");\r\n     \treturn (false);\r\n   }\r\n   document.form1.submit();\r\n}\r\n\r\nfunction LoadWindow1()\r\n{\r\n  URL=\"/general/sale/sale_history/customer_select\";\r\n  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n  loc_y=document.body.scrollTop+event.clientY";
echo "-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  display1();\r\n}\r\nfunction LoadWindow2()\r\n{\r\n  URL=\"/general/sale/sale_history/product_select\";\r\n  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;\r\n  loc_y=document.body.scrollTop+event.clientY";
echo "-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  display2();\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.showModalDi";
echo "alog(\"/inc/calendar.php?FIELDNAME=\"+fieldname,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:\"+mytop+\"px;dialogLeft:\"+myleft+\"px\");\r\n}\r\n\r\nfunction display1()\r\n{\r\n\tvar customer_name\t= document.form1.CUSTOMER_NAME.value;\r\n\tvar show_display\t= document.getElementById('display1');\r\n\r\n\tif(customer_name == \"\" || customer_name.substr(0, 1) == \" \")\r\n\t{";
echo "\r\n\t\tshow_display.style.display\t= \"\";\r\n\t}else{\r\n\t\tshow_display.style.display\t= \"none\";\r\n\t}\r\n}\r\n\r\nfunction display2()\r\n{\r\n\tvar product_name_type\t= document.form1.PRODUCT_NAME_TYPE.value;\r\n\tvar show_display\t\t= document.getElementById('display2');\r\n\r\n\tif(product_name_type == \"\" || product_name_type.substr(0, 1) == \" \")\r\n\t{\r\n\t\tshow_display.style.display\t= \"\";\r\n\t}else{\r\n\t\tshow_display.style.display\t= \"n";
echo "one\";\r\n\t}\r\n}\r\n\r\nfunction select_contact()\r\n{\r\n\tvar customer_id\t\t\t= document.form1.CUSTOMER_ID.value;\r\n\tvar child_sale_history\t= document.getElementById('child_sale_history');\r\n\tif(customer_id != ''){\r\n\t\tchild_sale_history.src = \"child_sale_history.php?CUSTOMER_ID=\"+customer_id;\r\n\t\tdocument.getElementById('show_contact').style.display = \"\";\r\n\t}\r\n}\r\n</script>\r\n</head>\r\n\r\n";
$connection = openconnection( );
$query = "SELECT * from SALE_HISTORY where HISTORY_ID=".$_REQUEST['history_id'];
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$HISTORY_ID = $ROW['HISTORY_ID'];
	$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
	$PRODUCT_ID1 = $ROW['PRODUCT_ID'];
	$DATE1 = $ROW['DATE'];
	$AMT1 = $ROW['AMT'];
	$PRICE1 = $ROW['PRICE'];
	$DISCOUNT1 = $ROW['DISCOUNT'];
	$SALESMAN1 = $ROW['SALESMAN'];
	$MEMO1 = $ROW['MEMO'];
	$query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID={$CUSTOMER_ID1}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$CUSTOMER_NAME = $ROW['CUSTOMER_NAME'];
	}
	$query = "SELECT PRODUCT_NAME,PRODUCT_TYPE from PRODUCT where PRODUCT_ID={$PRODUCT_ID1}";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PRODUCT_NAME = $ROW['PRODUCT_NAME'];
		$PRODUCT_TYPE = $ROW['PRODUCT_TYPE'];
		if ( $PRODUCT_TYPE != "" )
		{
			$PRODUCT_NAME_TYPE = $PRODUCT_NAME.$PRODUCT_TYPE;
		}
		else
		{
			$PRODUCT_NAME_TYPE = $PRODUCT_NAME;
		}
	}
}
echo "\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<form action=\"update.php\"  method=\"post\" name=\"form1\">\r\n<input type='hidden' name='edt_r' value='";
echo $_REQUEST['edt_r'];
echo "'>\r\n<input type='hidden' name='sens' value='";
echo $_REQUEST['sens'];
echo "'>\r\n<input type='hidden' name='order' value='";
echo $_REQUEST['order'];
echo "'>\r\n<input type='hidden' name='cur_page' value='";
echo $_REQUEST['cur_page'];
echo "'>\r\n<input type='hidden' name='list_CUSTOMER_NAME' value='";
echo $_REQUEST['CUSTOMER_NAME'];
echo "'>\r\n<input type='hidden' name='list_PRODUCT_ID' value='";
echo $_REQUEST['PRODUCT_ID'];
echo "'>\r\n<input type='hidden' name='list_DATE' value='";
echo $_REQUEST['DATE'];
echo "'>\r\n<input type='hidden' name='list_DATE2' value='";
echo $_REQUEST['DATE2'];
echo "'>\r\n<input type='hidden' name='list_AMT' value='";
echo $_REQUEST['AMT'];
echo "'>\r\n<input type='hidden' name='list_AMT2' value='";
echo $_REQUEST['AMT2'];
echo "'>\r\n<input type='hidden' name='list_PRICE' value='";
echo $_REQUEST['PRICE'];
echo "'>\r\n<input type='hidden' name='list_PRICE2' value='";
echo $_REQUEST['PRICE2'];
echo "'>\r\n<input type='hidden' name='list_DISCOUNT' value='";
echo $_REQUEST['DISCOUNT'];
echo "'>\r\n<input type='hidden' name='list_DISCOUNT2' value='";
echo $_REQUEST['DISCOUNT2'];
echo "'>\r\n<input type='hidden' name='list_SALESMAN' value='";
echo $_REQUEST['SALESMAN'];
echo "'>\r\n<input type='hidden' name='list_MEMO' value='";
echo $_REQUEST['MEMO'];
echo "'>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n  <tr class=\"tablehead1\">\r\n    <td><img src=\"/images/notify_new.gif\" align=\"absmiddle\">产品信息编辑\r\n    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\">\r\n    <td><BUTTON class=btn onClick=\"CheckForm();\" title=\"确定\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">确定</span></td></tr></table></BUTTON> <BUTTON class=btn onClick=\"location='index.php';\" title=\"返回\"><table><tr valign=top ><td><img src=\"/images/littlegif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON>\r\n    </td>\r\n  </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\"  >\r\n  \r\n   <tr>\r\n    <td nowrap class=\"TableLine2\">客户名称： </td>\r\n    <td class=\"TableLine1\" colspan=\"3\">\r\n      <input type=\"hidden\" name=\"CUSTOMER_ID\" value=\"";
echo $CUSTOMER_ID1;
echo "\">\r\n      <input type=\"text\" name=\"CUSTOMER_NAME\" class=\"BigStatic\" size=\"33\" maxlength=\"100\" readonly value=\"";
echo $CUSTOMER_NAME;
echo "\">&nbsp;\r\n      <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow1()\" title=\"选择客户\" name=\"button\">&nbsp;";
echo "<s";
echo "pan name=\"display1\" id=\"display1\" style=\"color:#FF0000;font:bold;\">!</span>\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\">产品： </td>\r\n    <td class=\"TableLine1\" colspan=\"3\">\r\n      <input type=\"hidden\" name=\"PRODUCT_ID\" value=\"";
echo $PRODUCT_ID1;
echo "\">\r\n      <input type=\"text\" name=\"PRODUCT_NAME_TYPE\" class=\"BigStatic\" size=\"33\" maxlength=\"100\" readonly value=\"";
echo $PRODUCT_NAME_TYPE;
echo "\">&nbsp;\r\n      <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow2()\" title=\"选择产品\" name=\"button\">&nbsp;";
echo "<s";
echo "pan name=\"display2\" id=\"display2\" style=\"color:#FF0000;font:bold;\">!</span>\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\">销售日期： </td>\r\n    <td nowrap class=\"TableLine1\" colspan=\"3\">\r\n        <input type=\"text\" name=\"DATE\" class=\"BigInput\" size=\"33\" maxlength=\"10\" value=\"";
echo $DATE1;
echo "\">&nbsp;\r\n        <img src=\"/images/menu/calendar1.gif\" border=\"0\" style=\"cursor:hand\" onclick=\"td_calendar('form1.DATE');\">\r\n    </td>\r\n   </tr>\r\n\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\" width=\"120\">数量：</td>\r\n    <td nowrap class=\"TableLine1\">\r\n        <input type=\"text\" name=\"AMT\" class=\"BigInput\" size=\"33\" maxlength=\"11\" value=\"";
echo $AMT1;
echo "\">&nbsp;\r\n    </td>\r\n\t<td nowrap class=\"TableLine2\" width=\"120\">价格：</td>\r\n    <td nowrap class=\"TableLine1\">\r\n        <input type=\"text\" name=\"PRICE\" class=\"BigInput\" size=\"33\" maxlength=\"25\" value=\"";
echo $PRICE1;
echo "\">&nbsp;\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\" width=\"120\">折扣：</td>\r\n    <td nowrap class=\"TableLine1\" colspan=\"3\">\r\n        <input type=\"text\" name=\"DISCOUNT\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"";
echo $DISCOUNT1;
echo "\">&nbsp;\r\n    </td>\r\n   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\" width=\"120\">销售员：</td>\r\n    <td nowrap class=\"TableLine1\" colspan=\"3\">\r\n        <input type=\"text\" name=\"SALESMAN\" class=\"BigInput\" size=\"33\" maxlength=\"100\" value=\"";
echo $SALESMAN1;
echo "\">&nbsp;\r\n    </td>\r\n   </tr>\r\n   <tr style=\"display:none;\" id=\"show_contact\" name=\"show_contact\">\r\n\t<td nowrap class=\"TableLine2\" width=\"120\">相关交往：</td>\r\n    <td nowrap class=\"TableLine1\" colspan=\"3\"><iframe name=\"child_sale_history\" id=\"child_sale_history\" style=\"border:0px;border-collapse:collapse; border:1px dotted #000000;\" frameborder=\"0\" scrolling=\"yes\" allowtransparency=\"true\"></iframe></td>\r\n";
echo "   </tr>\r\n   <tr>\r\n    <td nowrap class=\"TableLine2\">备注： </td>\r\n    <td nowrap class=\"TableLine1\" colspan=\"3\">\r\n      <textarea cols=37 rows=3 name=\"MEMO\" class=\"BigInput\" wrap=\"yes\">";
echo $MEMO1;
echo "</textarea>\r\n    </td>\r\n   </tr>\r\n   \r\n        <input type=\"hidden\" value=\"";
echo $HISTORY_ID;
echo "\" name=\"HISTORY_ID\">\r\n        <input type=\"hidden\" value=\"CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "&PRODUCT_ID=";
echo $PRODUCT_ID;
echo "&PROVIDER_ID=";
echo $PROVIDER_ID;
echo "&DATE=";
echo $DATE;
echo "&AMT=";
echo $AMT;
echo "&PRICE=";
echo $PRICE;
echo "&DISCOUNT=";
echo $DISCOUNT;
echo "&SALESMAN=";
echo $SALESMAN;
echo "&MEMO=";
echo $MEMO;
echo "&PAGE_START=";
echo $PAGE_START;
echo "\" name=\"QUERY_LIST\">\r\n        \r\n  \r\n  \r\n</table>\r\n</form>\r\n";
echo "<s";
echo "cript>\r\nvar customer_n\t= document.getElementById('CUSTOMER_NAME');\r\nvar product_name_type\t= document.getElementById('PRODUCT_NAME_TYPE');\r\nvar show_display1\t= document.getElementById('display1');\r\nvar show_display2\t= document.getElementById('display2');\r\nvar customer_id\t\t= document.form1.CUSTOMER_ID.value;\r\n\r\nif(customer_n.value != null){\r\n\tshow_display1.style.display\t= \"none\";\r\n}else{\r\n\tshow_disp";
echo "lay1.style.display\t= \"\";\r\n}\r\n\r\nif(product_name_type.value != null){\r\n\tshow_display2.style.display\t= \"none\";\r\n}else{\r\n\tshow_display2.style.display\t= \"\";\r\n}\r\n\r\n//document.getElementById(\"child_sale_history\").src\t= \"child_sale_history.php?CUSTOMER_ID=\"+customer_id;\r\ndocument.getElementById(\"show_contact\").style.display\t= \"none\";\r\n</script>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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