📄 edit.php
字号:
<?php
function GETALLDATE( $CODE, $GETVALUE )
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='".$CODE."'";
$cursor = exequery( $connection, $query );
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_field.php" );
echo "<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\nvar upload_limit=";
echo $UPLOAD_LIMIT;
echo ",limit_type=\"";
echo strtolower( $UPLOAD_LIMIT_TYPE );
echo "\";\r\nfunction CheckForm()\r\n{\r\n if(document.form1.PRODUCT_NAME.value==\"\")\r\n {\r\n \t alert(\"产品名称不能为空!\");\r\n return (false);\r\n }\r\n if(checknum(document.form1.COST_PRICE.value)==\"0\")\r\n { alert(\"成本价必须为数字!!!\");\r\n \t form1.COST_PRICE.focus();\r\n return (false);\r\n }\r\n if(checknum(document.form1.STANDARD_PRICE.value)==\"0\")\r\n { alert(\"出售价必须为数字!!!\");\r\n \t form1.STANDARD_PRICE.focus();\r\n return (false);\r\n }\r\n if (document.form1.ATTACHMENT.value!=\"\")\r\n {\r\n var file_temp=document.form1.ATTACHMENT.value,ext_name;\r\n var Pos;\r\n Pos=file_temp.lastIndexOf(\".\");\r\n ext_name=file_temp.substring(Pos,file_temp.length);\r\n document.form1.ATTACHMENT_NAME.value=document.form1.PRODUCT_NAME.value+ext_name;\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\nfunction LoadWindow()\r\n{\r\n URL=\"/module/crm/provider_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\nfunction view_photo(PHOTO)\r\n{\r\n\t\r\n URL=\"view_photo.php?PHOTO=\"+PHOTO;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"view_photo\",\"height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction chk(input,KC,KT,count)\r\n{\r\n var lstr=\"\";\r\n if(count==1)\r\n {\r\n if(document.all(KC).checked)\r\n {\r\n document.all(KT).value=document.all(KC).value;\r\n }\r\n else\r\n {\r\n document.all(KT).value=\"\";\r\n }\r\n }\r\n else\r\n {\r\n for(i=0;i<document.all(KC).length;i++)\r\n {\r\n el=document.all(KC).item(i);\r\n if(el.checked)\r\n {\r\n val=el.value;\r\n lstr+=val+\",\";\r\n }\r\n }\r\n document.all(KT).value=lstr;\r\n }\r\n}\r\nfunction LoadWindow1(kname,codeid)\r\n{\r\n URL=\"/module/crm/codedefine.php?kname=\"+kname+\"&codeid=\"+codeid;\r\n myleft=(screen.availWidth-650)/2;\r\n window.open(URL,\"formul_edit\",\"height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\nfunction delete_photo()\r\n{\r\n msg=\"确定要删除上传的图片吗?\";\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete_photo.php?PRODUCT_ID=";
echo $PRODUCT_ID;
echo "&PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_DESC=";
echo $PRODUCT_DESC;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\";\r\n window.location=URL;\r\n }\r\n}\r\n</script>\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\" onLoad=\"document.form1.PRODUCT_NAME.focus();\">\r\n";
$query = "SELECT * from PRODUCT where PRODUCT_ID=".$PRODUCT_ID;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PRODUCT_NAME1 = $ROW['PRODUCT_NAME'];
$PRODUCT_TYPE1 = $ROW['PRODUCT_TYPE'];
$PRODUCT_MODE1 = $ROW['PRODUCT_MODE'];
$PRODUCT_CODE1 = $ROW['PRODUCT_CODE'];
$MEASURE_UNIT1 = $ROW['MEASURE_UNIT'];
$COST_PRICE1 = $ROW['COST_PRICE'];
$STANDARD_PRICE1 = $ROW['STANDARD_PRICE'];
$PROVIDER_ID1 = $ROW['PROVIDER_ID'];
$PRODUCT_DESC1 = $ROW['PRODUCT_DESC'];
$MEMO11 = $ROW['MEMO'];
$MEMO12 = $ROW['MEMO1'];
$PHOTO = $ROW['PHOTO'];
}
$query = "SELECT PROVIDER_NAME from PROVIDER where PROVIDER_ID='".$PROVIDER_ID1."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROVIDER_NAME1 = $ROW['PROVIDER_NAME'];
}
echo "<table border=\"0\" width=\"100%\" 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<form action=\"update.php\" enctype=\"multipart/form-data\" method=\"post\" name=\"form1\" onSubmit=\"return CheckForm();\">\r\n<table border=\"0\" cellspacing=\"1\" width=\"400\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n 产品基本信息\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\">供应商:</td>\r\n <td class=\"TableData\">\r\n <input type=\"hidden\" name=\"PROVIDER_ID\" value=\"";
echo $PROVIDER_ID1;
echo "\">\r\n <input type=\"text\" name=\"PROVIDER_NAME\" class=\"BigStatic\" size=\"15\" maxlength=\"100\" readonly value=\"";
echo $PROVIDER_NAME1;
echo "\"> \r\n <input type=\"button\" value=\"选 择\" class=\"SmallButton\" onClick=\"LoadWindow()\" title=\"选择供应商\" name=\"button\">\r\n </td>\r\n <td class=\"TableData\" width=\"100\">产品编码: </td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"PRODUCT_CODE\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PRODUCT_CODE1;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\" width=\"100\">产品名称: </td>\r\n <td class=\"TableData\">\r\n <input type=\"text\" name=\"PRODUCT_NAME\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PRODUCT_NAME1;
echo "\"> \r\n </td>\r\n <td nowrap class=\"TableData\">产品类别:</td>\r\n <td class=\"TableData\">\r\n \t<select name=\"PRODUCT_MODE\" class=\"BigSelect\">\r\n";
getalldate( "PRODUCT_MODE", $PRODUCT_MODE1 );
echo " </select>\r\n <a href=\"javascript:LoadWindow1('PRODUCT_MODE','PRODUCT_MODE');\"><img src=\"/images/edit1.gif\" align=\"absmiddle\" border=0 title=\"销售方式定义\"></a>\r\n\r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\">产品型号:</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"PRODUCT_TYPE\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $PRODUCT_TYPE1;
echo "\"> \r\n </td>\r\n <td nowrap class=\"TableData\">计量单位:</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"MEASURE_UNIT\" class=\"BigInput\" size=\"15\" maxlength=\"100\" value=\"";
echo $MEASURE_UNIT1;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableData\">成本价:</td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"COST_PRICE\" class=\"BigInput\" size=\"15\" maxlength=\"25\" value=\"";
echo $COST_PRICE1;
echo "\"> \r\n </td>\r\n <td nowrap class=\"TableData\">出售价: </td>\r\n <td nowrap class=\"TableData\">\r\n <input type=\"text\" name=\"STANDARD_PRICE\" class=\"BigInput\" size=\"15\" maxlength=\"25\" value=\"";
echo $STANDARD_PRICE1;
echo "\"> \r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">产品描述: </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <textarea cols=57 rows=3 name=\"PRODUCT_DESC\" class=\"BigInput\" wrap=\"yes\">";
echo $PRODUCT_DESC1;
echo "</textarea>\r\n </td>\r\n </tr>\r\n ";
if ( $PHOTO == "" )
{
$PHOTO_STR = "产品图片上传:";
}
else
{
$PHOTO_STR = "产品图片更改:";
}
echo " <tr>\r\n <td nowrap class=\"TableData\"> ";
echo $PHOTO_STR;
echo "</td>\r\n <td class=\"TableData\" colspan=\"3\">\r\n <input type=\"file\" name=\"ATTACHMENT\" size=\"40\" class=\"BigInput\" title=\"选择附件文件\" value=\"";
echo $ATTACHMENT;
echo "\">\r\n";
if ( $PHOTO != "" )
{
echo " <br><a href=#this onClick=\"delete_photo();\">删除图片</a> <a href=#this onClick=\"view_photo('";
echo $PHOTO;
echo "');\">点击查看</a>\r\n";
}
echo " </td>\r\n </tr>\r\n";
if ( $PHOTO != "" )
{
echo " \r\n <tr>\r\n <td nowrap class=\"TableData\" align=\"center\" colspan=\"4\">\r\n <img src='/inc/product_pic.php?PHOTO=";
echo $PHOTO;
echo "' width='100' border=1>\r\n </td>\r\n </tr>\r\n";
}
echo " \r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n 备注\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"100\">备注1:</td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <textarea cols=57 rows=3 name=\"MEMO\" class=\"BigInput\" wrap=\"yes\">";
echo $MEMO11;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" width=\"100\">备注2:</td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n <textarea cols=57 rows=3 name=\"MEMO1\" class=\"BigInput\" wrap=\"yes\">";
echo $MEMO12;
echo "</textarea>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\" colspan=\"4\">\r\n ";
echo get_field_table( get_field_html( "PRODUCT", $PRODUCT_ID ) );
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableControl\" colspan=\"4\" align=\"center\">\r\n <input type=\"hidden\" value=\"";
echo $PRODUCT_ID;
echo "\" name=\"PRODUCT_ID\">\r\n <input type=\"hidden\" value=\"\" name=\"ATTACHMENT_NAME\">\r\n <input type=\"hidden\" value=\"PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_DESC=";
echo $PRODUCT_DESC;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "\" name=\"QUERY_LIST\">\r\n <input type=\"submit\" value=\"确定\" class=\"BigButton\" title=\"编辑产品信息\" name=\"button\"> \r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php?PRODUCT_NAME=";
echo $PRODUCT_NAME;
echo "&PRODUCT_TYPE=";
echo $PRODUCT_TYPE;
echo "&PRODUCT_DESC=";
echo $PRODUCT_DESC;
echo "&PRODUCT_MODE=";
echo $PRODUCT_MODE;
echo "&PROVIDER_NAME=";
echo $PROVIDER_NAME;
echo "&ORDERFIELD=";
echo $ORDERFIELD;
echo "&ORDERTYPE=";
echo $ORDERTYPE;
echo "&CUR_PAGE=";
echo $CUR_PAGE;
echo "'\">\r\n </td>\r\n </tr>\r\n</table>\r\n</form>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -