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

📄 edit.php

📁 极限网络智能办公系统 Office Automation V3.0官方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 IsNumber(str)
{
   return str.match(/^[0-9]*$/)!=null;
}
function IsValidEmail(str)
{
   var re = /@/;
   return str.match(re)!=null;

}
function CheckForm()
{
   if(document.form1.PROVIDER_NAME.value=="")
   { alert("供应商名称不能为空！");
     return (false);
   }

   if (document.form1.EMAIL.value!=""&&!IsValidEmail(document.form1.EMAIL.value))
   { alert("请输入有效的电子信箱！");
     return (false);
   }

   if (document.form1.POSTALCODE.value!=""&&!IsNumber(document.form1.POSTALCODE.value))
   { alert("邮编只能是数字！");
     return (false);
   }
}
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="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");
}
</script>
</head>

<body class="bodycolor" topmargin="5" onload="document.form1.PROVIDER_NAME.focus();">

<?
 $query = "SELECT * from PROVIDER where PROVIDER_ID=$PROVIDER_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
    $PROVIDER_SHORT1=$ROW["PROVIDER_SHORT"];
    $PROVIDER_CODE1=$ROW["PROVIDER_CODE"];
    $PROVIDER_AREA1=$ROW["PROVIDER_AREA"];
    $PROVIDER_RECORDER1=$ROW["PROVIDER_RECORDER"];
    $TEL_NO1=$ROW["TEL_NO"];
    $FAX_NO1=$ROW["FAX_NO"];
    $PROVIDER_WWW1=$ROW["PROVIDER_WWW"];
    $EMAIL1=$ROW["EMAIL"];
    $PROVIDER_ADD1=$ROW["PROVIDER_ADD"];
    $POSTALCODE1=$ROW["POSTALCODE"];
    $BANK1=$ROW["BANK"];

    $ACCOUNT1=$ROW["ACCOUNT"];   
    $MEMO11=$ROW["MEMO"];
    $USERDEF11=$ROW["USERDEF1"];
    $USERDEF21=$ROW["USERDEF2"];
    $USERDEF31=$ROW["USERDEF3"];
    $USERDEF41=$ROW["USERDEF4"];
    $USERDEF51=$ROW["USERDEF5"];
     $PROVIDER_DETAILNAME="";
      $TOK=strtok($PROVIDER_DETAIL1,",");
      while($TOK!="")
      {
        $query1="select PRODUCT_NAME from PRODUCT  where PRODUCT_ID='$TOK'";
        $cursor1= exequery($connection,$query1);
        if($ROW=mysql_fetch_array($cursor1))
           $PROVIDER_DETAILNAME.=$ROW["PRODUCT_NAME"].",";

        $TOK=strtok(",");
      }
 }
 
?>
<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="450"  class="small"  bgcolor="#000000" cellpadding="3" align="center" >
  <form action="update.php"  method="post" name="form1" onsubmit="return CheckForm();">
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
      基本信息：
    </td>
   <tr>
    <td nowrap class="TableData">供应商名称： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="PROVIDER_NAME" class="BigInput" size="50" maxlength="100" value="<?=$PROVIDER_NAME1?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">供应商编码： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_CODE" class="BigInput" size="15" maxlength="100" value="<?=$PROVIDER_CODE1?>">
    </td>

     <td nowrap class="TableData">供应商简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_SHORT" class="BigInput" size="15" maxlength="100" value="<?=$PROVIDER_SHORT1?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">电话： </td>
    <td nowrap class="TableData">
        <input type="text" name="TEL_NO" class="BigInput" size="15" maxlength="100" value="<?=$TEL_NO1?>">
    </td>

     <td nowrap class="TableData">传真： </td>
    <td nowrap class="TableData">
        <input type="text" name="FAX_NO" class="BigInput" size="15" maxlength="100" value="<?=$FAX_NO1?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">网址： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_WWW" class="BigInput" size="15" maxlength="100" value="<?=$PROVIDER_WWW1?>">
    </td>
     <td nowrap class="TableData">电子邮件： </td>
    <td nowrap class="TableData">
        <input type="text" name="EMAIL" class="BigInput" size="15" maxlength="100" value="<?=$EMAIL1?>">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">地区： </td>
    <td nowrap class="TableData">
    	  <select name="PROVIDER_AREA" class="BigSelect">
<?
          GETALLDATE("AREA",$PROVIDER_AREA1);
?>
        </select>
    &nbsp;<a href="javascript:LoadWindow1('PROVIDER_AREA','AREA');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="地区定义"></a>
    </td>
    <td nowrap class="TableData">邮政编码： </td>
    <td nowrap class="TableData">
        <input type="text" name="POSTALCODE" class="BigInput" size="15" maxlength="25" value="<?=$POSTALCODE1?>">
    </td>
   </tr>

    <tr>
    <td nowrap class="TableData">详细地址： </td>
    <td nowrap class="TableData" colspan="3">
    	 <textarea cols=57 rows=3 name="PROVIDER_ADD" class="BigInput" wrap="yes"><?=$PROVIDER_ADD1?></textarea>
    </td>
   </tr>
   <tr>
 <td nowrap class="TableData">备注： </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="TableHeader" colspan="4" align="left">
     财务信息：
 </td>
</tr>
 <tr>
    <td nowrap class="TableData">开户行： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="BANK" class="BigInput" size="50" maxlength="100" value="<?=$BANK1?>">
    </td>
 </tr>
 <tr>
    <td nowrap class="TableData">帐号： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="ACCOUNT" class="BigInput" size="50" maxlength="100" value="<?=$ACCOUNT1?>">
    </td>
 </tr>

<?
 $count=0;
 $connection=OpenConnection();
 $query = "select count(*) from FIELDSETTING where TABLENAME='PROVIDER'";
 $cursor=exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
{
   $count=$ROW[0];
}
 if($count>0)
 {

?>
   <tr>
    <td nowrap  class="TableHeader" colspan="4" align="left">
      用户自定义字段：
    </td>
   </tr>
<?
  $query = "select * from FIELDSETTING where TABLENAME='PROVIDER' ORDER BY ORDERNO ASC  ";
  $cursor=exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
  {
  	   $FIELDNAME=$ROW["FIELDNAME"];
       $ORDERNO=$ROW["ORDERNO"];
       $STYPE=$ROW["STYPE"];
       $TYPENAME=$ROW["TYPENAME"];
       $TYPEVALUE=$ROW["TYPEVALUE"];
       $TYPECODE=$ROW["TYPECODE"];
       $ISQUERY=$ROW["ISQUERY"];
       $ISGROUY=$ROW["ISGROUY"];
       $FIELDNAME=$ROW["FIELDNAME"];
       $FIELDNO=$ROW["FIELDNO"];
       $FIELDNO1=$FIELDNO."1";
?>
 <tr>
    <td nowrap class="TableData"><?=$FIELDNAME?>：</td>
    <td nowrap class="TableData" colspan="3">
<?
    if($STYPE=="T")
    {
?>
     <input type="text" name='<?=$FIELDNO?>' class="BigInput" size="33" maxlength="25" value="<?=$$FIELDNO1?>">
<?
    }
    if($STYPE=="MT")
    {
?>
     <textarea cols=37 rows=3 name='<?=$FIELDNO?>' class="BigInput" wrap="yes"><?=$$FIELDNO1?></textarea>

<?
    }
    if($STYPE=="D")
    {
       $TYPEVALUE=str_replace("，",",",$TYPEVALUE);
       $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
       $TYPENAME=str_replace("，",",",$TYPENAME);
       $TYPENAME_ARRAY=explode(",",$TYPENAME);
       $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
       if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
?>
       <select name='<?=$FIELDNO?>' class="BigSelect">
<?
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
?>

       <option value="<?=$TYPEVALUE_ARRAY[$I]?>" <?if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "selected";?>><?=$TYPENAME_ARRAY[$I]?></option>

<?

       }
     }
     if($STYPE=="C")
    {
       $temp=str_replace("，",",",$$FIELDNO1);
       $temp_ARRAY=explode(",",$temp);
       $temp_ARRAY_count=sizeof($temp_ARRAY);
       $TYPEVALUE=str_replace("，",",",$TYPEVALUE);
       $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
       $TYPENAME=str_replace("，",",",$TYPENAME);
       $TYPENAME_ARRAY=explode(",",$TYPENAME);
       $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
       if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;

?>
      <input type="hidden" name='<?=$FIELDNO?>' value="<?=$temp?>">
<?
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
         $flag=0;
         for($T=0;$T< $temp_ARRAY_count;$T++)
         {
         	  if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])$flag=1;
         }
?>

       <input type="checkbox" name='C<?=$FIELDNO?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"  <? if($flag==1) echo "checked";?>  onclick="return chk(this,'C<?=$FIELDNO?>','<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><?=$TYPENAME_ARRAY[$I]?>

<?
       }
     }
     if($STYPE=="R")
    {
    	 $TYPEVALUE=str_replace("，",",",$TYPEVALUE);
       $TYPEVALUE_ARRAY=explode(",",$TYPEVALUE);
       $TYPENAME=str_replace("，",",",$TYPENAME);
       $TYPENAME_ARRAY=explode(",",$TYPENAME);
       $TYPENAME_COUNT=sizeof($TYPENAME_ARRAY);
       if($TYPENAME_ARRAY[$TYPENAME_COUNT-1]=="")$TYPENAME_COUNT--;
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
?>
      <input type="radio" name='<?=$FIELDNO?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"  <? if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "checked";?> ><?=$TYPENAME_ARRAY[$I]?>
<?
       }
    }
?>

    </td>
 </tr>
<?
  }

 }
?>
<tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
<?
 if($querstr!="")
  {
  	    $urlstr1=str_replace("%","&",$querstr);
?>
    	  <input type="hidden" value="<?=$PROVIDER_ID?>" name="PROVIDER_ID">
        <input type="hidden" value="<?=$querstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>" name="QUERY_LIST">
        <input type="hidden" value="ad_query" name="FLAGSOURCE">
        <input type="submit" value="确定" class="BigButton" title="修改客户资料" name="button">&nbsp;
        <input type="button" value="返回" class="BigButton" onclick="location='ad_query/list.php?<?=$urlstr1?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>'">
<?
  }
  else
  {
?>
  <input type="hidden" value="<?=$PROVIDER_ID?>" name="PROVIDER_ID">
  <input type="hidden" value="PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>" name="QUERY_LIST">
   <input type="submit" value="确定" class="BigButton" title="修改客户资料" name="button">&nbsp;
   <input type="button" value="返回" class="BigButton" onclick="location='index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&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 + -