edit.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

    </td>

   </tr>
  <tr>
    <td nowrap class="TableData">客户类别： </td>
    <td nowrap class="TableData"  colspan="3">
        <select name="KIND" class="BigSelect">
<?
        GETALLDATE("CRM_KIND",$KIND1);
?>
        </select>
        &nbsp;<a href="javascript:LoadWindow1('KIND','CRM_KIND');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="客户类别"></a>
    </td>

  </tr>
   <tr>
    <td nowrap class="TableData">销售方式： </td>
    <td nowrap class="TableData" colspan="3">
        <select name="SELLMODE" class="BigSelect">
<?
        GETALLDATE("SELL_MODE",$SELLMODE1);
?>
        </select>
       &nbsp;<a href="javascript:LoadWindow1('SELLMODE','SELL_MODE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="销售方式定义"></a>
    </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">
        <select name="ATTRIBUTE" class="BigSelect">
<?
        GETALLDATE("CRM_ATTRIBUTE",$ATTRIBUTE1);
?>
        </select>
    &nbsp;<a href="javascript:LoadWindow1('ATTRIBUTE','CRM_ATTRIBUTE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="行业属性定义"></a>
    </td>
</tr>
<tr>
 <td nowrap class="TableData">企业性质： </td>
    <td nowrap class="TableData"  colspan="3">
        <select name="ENTERTYPE" class="BigSelect">
<?
        GETALLDATE("CRM_TYPE",$ENTERTYPE1);
?>
        </select>
    &nbsp;<a href="javascript:LoadWindow1('ENTERTYPE','CRM_TYPE');"><img src="/images/edit1.gif" align="absmiddle" border=0 title="企业性质定义"></a>
    </td>
  </tr>
<tr>
 <td nowrap class="TableData">企业描述： </td>
    <td nowrap class="TableData" colspan="3">
        <textarea cols=55 rows=2 name="ENTERMEMO" class="BigInput" wrap="yes"><?=$ENTERMEMO1?></textarea>
    </td>
</tr>

<tr>
 <td nowrap  class="TableHeader" colspan="4" align="left">
      备注：
 </td>
</tr>
<tr>
 <td nowrap class="TableData">备注1： </td>
    <td nowrap class="TableData" colspan="3">
        <textarea cols=55 rows=3 name="MEMO" class="BigInput" wrap="yes"><?=$MEMO11?></textarea>
    </td>
</tr>

<tr>
 <td nowrap class="TableData">备注2： </td>
    <td nowrap class="TableData" colspan="3">
        <textarea cols=55 rows=3 name="MEMO1" class="BigInput" wrap="yes"><?=$MEMO12?></textarea>
    </td>
</tr>

<?
 $count=0;
 $connection=OpenConnection();
 $query = "select count(*) from FIELDSETTING where TABLENAME='CUSTOMER'";
 $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='CUSTOMER' 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?>' id='C<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"  <? if($flag==1) echo "checked";?>  onclick="return chk(this,'C<?=$FIELDNO?>','<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><label for="C<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>

<?
       }
     }
     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?>' id='<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"  <? if($$FIELDNO1==$TYPEVALUE_ARRAY[$I]) echo "checked";?> ><label for="<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
       }
    }
?>

    </td>
 </tr>
<?
  }

 }
?>
<tr>
    <td nowrap  class="TableControl" colspan="4" align="center">
<?
 if($querstr!="")
  {
  	    $urlstr1=str_replace("%","&",$querstr);
?>
    	  <input type="hidden" value="<?=$CUSTOMER_ID?>" name="CUSTOMER_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="<?=$CUSTOMER_ID?>" name="CUSTOMER_ID">
  <input type="hidden" value="CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&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?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&SCOPE=<?=$SCOPE?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&SOURCE=<?=$SOURCE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&AREACODE=<?=$AREACODE?>&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>";}
  }

}
?>