⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 edit.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>修改产品信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function CheckForm()
{
   if(document.form1.PRODUCT_NAME.value=="")
   {
   	 alert("产品名称不能为空！");
     return (false);
   }
   if(checknum(document.form1.COST_PRICE.value)=="0")
   { alert("成本价必须为数字！！！");
   	  form1.COST_PRICE.focus();
     return (false);
   }
    if(checknum(document.form1.STANDARD_PRICE.value)=="0")
   { alert("出售价必须为数字！！！");
   	  form1.STANDARD_PRICE.focus();
     return (false);
   }
    if(checknum(document.form1.PRODUCT_LOWSTOCK.value)=="0")
   { alert("警戒库存必须为数字！！！");
   	  form1.PRODUCT_LOWSTOCK.focus();
     return (false);
   }
    if (document.form1.ATTACHMENT.value!="")
   {
     var file_temp=document.form1.ATTACHMENT.value,ext_name;
     var Pos;
     Pos=file_temp.lastIndexOf(".");
     ext_name=file_temp.substring(Pos,file_temp.length);
     document.form1.ATTACHMENT_NAME.value=document.form1.PRODUCT_NAME.value+ext_name;
   }
}
function checknum(p)
{
 var l = p.length;
 var count=0;
 for(var i=0; i<l; i++)
 {
   var digit = p.charAt(i);
   if(digit == "." )
  {
    ++count;
    if(count>1)
    {
     return 0;
    }
   }
   else if(digit < "0" || digit > "9")
  {
   return 0;
   }
 }
 return 1;
}
function LoadWindow()
{
  URL="../new/provider_select";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  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");
}
function view_photo(PHOTO)
{
	
  URL="view_photo.php?PHOTO="+PHOTO;
  myleft=(screen.availWidth-650)/2;
  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");
}
function chk(input,KC,KT,count)
{
 var lstr="";
 if(count==1)
 {
  if(document.all(KC).checked)
  {
   document.all(KT).value=document.all(KC).value;
  }
  else
  {
   document.all(KT).value="";
  }
 }
 else
 {
  for(i=0;i<document.all(KC).length;i++)
  {
   el=document.all(KC).item(i);
   if(el.checked)
   {
    val=el.value;
    lstr+=val+",";
   }
   }
  document.all(KT).value=lstr;
 }
}
function LoadWindow1(kname,codeid)
{
  URL="../new/codedefine.php?kname="+kname+"&codeid="+codeid;
  myleft=(screen.availWidth-650)/2;
  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");
}
function delete_photo()
{
  msg="确定要删除上传的图片吗?";
  if(window.confirm(msg))
  {
    URL="delete_photo.php?PRODUCT_ID=<?=$PRODUCT_ID?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>";
    window.location=URL;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="document.form1.PRODUCT_NAME.focus();">
<?
 $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"];
    $PRODUCT_LOWSTOCK1=$ROW["PRODUCT_LOWSTOCK"];
    $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"];
 }
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3">修改产品信息</span>
    </td>
  </tr>
</table>
<br>
<table border="0" cellspacing="1" width="400" class="small" bgcolor="#000000" cellpadding="3" align="center" >
  <form action="update.php"  enctype="multipart/form-data" method="post" name="form1" onsubmit="return CheckForm();">
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
     产品基本信息
    </td>
   </tr>
   <tr>
    <td class="TableData">供应商：</td>
    <td class="TableData">
      <input type="hidden" name="PROVIDER_ID" value="<?=$PROVIDER_ID1?>">
      <input type="text" name="PROVIDER_NAME" class="BigStatic" size="15" maxlength="100" readonly value="<?=$PROVIDER_NAME1?>">&nbsp;
      <input type="button" value="选 择" class="SmallButton" onClick="LoadWindow()" title="选择供应商" name="button">
    </td>
    <td  class="TableData" width="100">产品编码： </td>
    <td  class="TableData">
        <input type="text" name="PRODUCT_CODE" class="BigInput" size="15" maxlength="100" value="<?=$PRODUCT_CODE1?>">&nbsp;
    </td>
   </tr>
   <tr>
    <td  class="TableData" width="100">产品名称： </td>
    <td  class="TableData">
        <input type="text" name="PRODUCT_NAME" class="BigInput" size="15" maxlength="100" value="<?=$PRODUCT_NAME1?>">&nbsp;
    </td>
    <td nowrap class="TableData">产品类别：</td>
      <td class="TableData">
      	<select name="PRODUCT_MODE" class="BigSelect">
<?
        GETALLDATE("PRODUCT_MODE",$PRODUCT_MODE1);
?>
        </select>
       &nbsp;<a href="javascript:LoadWindow1('PRODUCT_MODE','PRODUCT_MODE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="销售方式定义"></a>

      </td>
   </tr>
   <tr>
   	<td nowrap class="TableData">产品型号：</td>
    <td nowrap class="TableData">
        <input type="text" name="PRODUCT_TYPE" class="BigInput" size="15" maxlength="100" value="<?=$PRODUCT_TYPE1?>">&nbsp;
    </td>
    <td nowrap class="TableData">计量单位：</td>
    <td nowrap class="TableData">
        <input type="text" name="MEASURE_UNIT" class="BigInput" size="15" maxlength="100" value="<?=$MEASURE_UNIT1?>">&nbsp;
    </td>
  </tr>
  <tr>
  	<td nowrap class="TableData">采购价：</td>
    <td nowrap class="TableData">
        <input type="text" name="COST_PRICE" class="BigInput" size="15" maxlength="25" value="<?=$COST_PRICE1?>">&nbsp;
    </td>
    <td nowrap class="TableData">出售价： </td>
    <td nowrap class="TableData">
        <input type="text" name="STANDARD_PRICE" class="BigInput" size="15" maxlength="25" value="<?=$STANDARD_PRICE1?>">&nbsp;
    </td>
   </tr>
  <tr>
    <td nowrap class="TableData">警戒库存： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="PRODUCT_LOWSTOCK" class="BigInput" size="15" maxlength="25" value="<?=$PRODUCT_LOWSTOCK1?>">&nbsp;
    </td>
  </tr>
   <tr>
    <td nowrap class="TableData">产品描述： </td>
    <td nowrap class="TableData" colspan="3">
       <textarea cols=57 rows=3 name="PRODUCT_DESC" class="BigInput" wrap="yes"><?=$PRODUCT_DESC1?></textarea>
    </td>
   </tr>
  <?
if($PHOTO=="")
   $PHOTO_STR="产品图片上传：";
else
   $PHOTO_STR="产品图片更改：";
?>
    <tr>
      <td nowrap class="TableData"> <?=$PHOTO_STR?></td>
      <td class="TableData" colspan="3">
        <input type="file" name="ATTACHMENT" size="40"  class="BigInput" title="选择附件文件" value="<?=$ATTACHMENT?>">
<?
if($PHOTO!="")
{
?>
      <br><a href=#this onclick="delete_photo();">删除照片</a>&nbsp;<a href=#this onclick="view_photo('<?=$PHOTO?>');">点击查看</a>
<?
}
?>
      </td>
    </tr>
<?
if($PHOTO!="")
{
?>    
  <tr>
    <td nowrap class="TableData" align="center" colspan="4">
       <img src='/inc/product_pic.php?PHOTO=<?=$PHOTO?>' width='100' border=1>
    </td>
  </tr>
<?
}
?>      
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
      备注
    </td>
  </tr>
   <tr>
    <td nowrap class="TableData" width="100">备注1：</td>
    <td nowrap class="TableData" colspan="3">
      <textarea cols=57 rows=3 name="MEMO" class="BigInput" wrap="yes"><?=$MEMO11?></textarea>
    </td>
   </tr>
    <tr>
    <td nowrap class="TableData" width="100">备注2：</td>
    <td nowrap class="TableData" colspan="3">
      <textarea cols=57 rows=3 name="MEMO1" class="BigInput" wrap="yes"><?=$MEMO12?></textarea>
    </td>
   </tr>
   <tr>
    <td class="TableData" colspan="4">
       <?=get_field_table(get_field_html("PRODUCT", $PRODUCT_ID))?>
    </td>
   </tr>
   <tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
        <input type="hidden" value="<?=$PRODUCT_ID?>" name="PRODUCT_ID">
         <input type="hidden" value="" name="ATTACHMENT_NAME">
        <input type="hidden" value="PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
        <input type="submit" value="确定" class="BigButton" title="编辑产品信息" name="button">&nbsp;
        <input type="button" value="返回" class="BigButton" onclick="location='index.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
    </td>
   </tr>
  </form>
</table>
</body>
</html>
<?
 function GETALLDATE($CODE,$GETVALUE)
{
  global $connection;
  $query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
  $connection=OpenConnection();
  $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>";}
  }

}
?>

⌨️ 快捷键说明

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