📄 edit.php

📁 通达OA2007SE源代码非常好的
💻 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>');
        continue;
      }
      else
      {
        echo (((('<option value='.$CODE_NO).' >').$CODE_NAME).'</option>');
        continue;
      }
    }
  }
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '<html>
<head>
<title>供应商信息编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript 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.val';
  echo 'ue))
   { 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).v';
  echo 'alue;
  	 	}
  	  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="../co';
  echo 'dedefine.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 (',');
    }
  }
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle">';
  echo '<s';
  echo 'pan 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';
  echo '="TableData">供应商名称： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="PROVIDER_NAME" class="BigInput" size="50" maxlength="100" value="';
  echo $PROVIDER_NAME1;
  echo '">
    </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="';
  echo $PROVIDER_CODE1;
  echo '">
    </td>
     <td nowrap class="TableData">供应商简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PROVIDER_SHORT" class="BigInput" size="15" maxlength="100" value="';
  echo $PROVIDER_SHORT1;
  echo '">
    </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="';
  echo $TEL_NO1;
  echo '">
    </td>
     <td nowrap class="TableData">传真： </td>
    <td nowrap class="TableData">
        <input type="text" name="FAX_NO" class="BigInput" size="15" maxlength="100" value="';
  echo $FAX_NO1;
  echo '">
    </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="';
  echo $PROVIDER_WWW1;
  echo '">
    </td>
     <td nowrap class="TableData">电子邮件： </td>
    <td nowrap class="TableData">
        <input type="text" name="EMAIL" class="BigInput" size="15" maxlength="100" value="';
  echo $EMAIL1;
  echo '">
    </td>
   </tr>
   <tr>
    <td nowrap class="TableData">地区： </td>
    <td nowrap class="TableData">
    	  ';
  echo '<s';
  echo 'elect name="PROVIDER_AREA" class="BigSelect">
';
  getalldate ('AREA', $PROVIDER_AREA1);
  echo '        </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="';
  echo $POSTALCODE1;
  echo '">
    </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">';
  echo $PROVIDER_ADD1;
  echo '</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">';
  echo $MEMO11;
  echo '</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="';
  echo $BANK1;
  echo '">
    </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="';
  echo $ACCOUNT1;
  echo '">
    </td>
 </tr>
<tr>
  <td class="TableData" colspan="4">
       ';
  echo get_field_table (get_field_html ('PROVIDER', $PROVIDER_ID));
  echo '  </td>
</tr>
<tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
';
  if (($querstr != ''))
  {
    $urlstr1 = str_replace ('%', '&', $querstr);
    echo '    	  <input type="hidden" value="';
    echo $PROVIDER_ID;
    echo '" name="PROVIDER_ID">
        <input type="hidden" value="';
    echo $querstr;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '" 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?';
    echo $urlstr1;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '\'">
';
  }
  else
  {
    echo '  <input type="hidden" value="';
    echo $PROVIDER_ID;
    echo '" name="PROVIDER_ID">
  <input type="hidden" value="PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&PROVIDER_CODE=';
    echo $PROVIDER_CODE;
    echo '&MEMO=';
    echo $MEMO;
    echo '&PROVIDER_SHORT=';
    echo $PROVIDER_SHORT;
    echo '&PROVIDER_AREA=';
    echo $PROVIDER_AREA;
    echo '&PROVIDER_DETAILID=';
    echo $PROVIDER_DETAILID;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '" 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=';
    echo $PROVIDER_NAME;
    echo '&MEMO=';
    echo $MEMO;
    echo '&PROVIDER_CODE=';
    echo $PROVIDER_CODE;
    echo '&PROVIDER_SHORT=';
    echo $PROVIDER_SHORT;
    echo '&PROVIDER_AREA=';
    echo $PROVIDER_AREA;
    echo '&PROVIDER_DETAILID=';
    echo $PROVIDER_DETAILID;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '&CUR_PAGE=';
    echo $CUR_PAGE;
    echo '\'">
';
  }
  echo '    </td>
   </tr>
  </form>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明

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