index.php

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

     }
     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='CONTRACT<?=$FIELDNO?>' id='CONTRACT<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"><label for="CONTRACT<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
       }
    }
?>

    </td>
 </tr>
<?
  }

 }
?>

 <tr>
 		<td nowrap class="TableData"  colspan="6" align="right" width="650">
     &nbsp;&nbsp;&nbsp;<input value="查询" type="submit" class="SmallButton" title="查询" name="button">
    </td>
 </tr>
</table>
</fieldset>
</div>
<br>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>客户信息</b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">客户编码： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_CODE" class="SmallInput" size="15" maxlength="100">
    </td>

     <td nowrap class="TableData">客户简称： </td>
    <td nowrap class="TableData">
        <input type="text" name="CUSTOMER_SHORT" class="SmallInput" size="15" maxlength="100">
    </td>
   </tr>

   <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;地区： </td>
    <td nowrap class="TableData">
         <select name="CUSTOMER_AREA" class="SmallSelect">
<?
        GETALLDATE("AREA");
?>
        </select>
    </td>
   <td nowrap class="TableData">地址： </td>
    <td nowrap class="TableData" colspan="3">
        <input type="text" name="CUSTOMER_ADD" class="SmallInput" size="43" maxlength="100">
    </td>
   </tr>

  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;客户来源： </td>
    <td nowrap class="TableData" >
        <select name="SOURCE" class="SmallSelect">
<?
        GETALLDATE("CRM_SOURCE");
?>
        </select>
    </td>


    <td nowrap class="TableData">客户类别： </td>
    <td nowrap class="TableData" >
        <select name="KIND" class="SmallSelect">
<?
        GETALLDATE("CRM_KIND");
?>
        </select>
    </td>

    <td nowrap class="TableData">销售方式： </td>
    <td nowrap class="TableData">
        <select name="SELLMODE" class="SmallSelect">
<?
        GETALLDATE("SELL_MODE");
?>
        </select>
    </td>
  </tr>
 <tr>
 	<td nowrap class="TableData">&nbsp;&nbsp;行业属性： </td>
    <td nowrap class="TableData">
        <select name="ATTRIBUTE" class="SmallSelect">
<?
        GETALLDATE("CRM_ATTRIBUTE");
?>
        </select>
    </td>

   <td nowrap class="TableData">企业性质： </td>
    <td nowrap class="TableData" >
        <select name="ENTERTYPE" class="SmallSelect">
<?
        GETALLDATE("CRM_TYPE");
?>
        </select>


    </td>
  <td nowrap class="TableData">企业描述： </td>
    <td nowrap class="TableData"  colspan="2">
        <input type="text" name="ENTERMEMO" class="SmallInput" size="15" maxlength="100">
    </td>
 </tr>
<?
 $count=0;
 $connection=OpenConnection();
 $query = "select count(*) from FIELDSETTING where TABLENAME='CUSTOMER' and ISQUERY='1'";
 $cursor=exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
{
   $count=$ROW[0];
}
 if($count>0)
 {
?>
   <tr>
    <td nowrap  class="TableHeader" colspan="6" align="left">
     &nbsp;&nbsp;用户自定义字段：

    </td>
   </tr>
<?
  $query = "select * from FIELDSETTING where TABLENAME='CUSTOMER' AND ISQUERY='1' 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"];
?>
   <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;<?=$FIELDNAME?>：</td>
    <td nowrap class="TableData" colspan="5">
<?
    if($STYPE=="T")
    {
?>
     <input type="text" name='CUSTOMER<?=$FIELDNO?>' class="SmallInput" size="33" maxlength="25" value="">
<?
    }
    if($STYPE=="MT")
    {
?>
     <textarea cols=37 rows=1 name='CUSTOMER<?=$FIELDNO?>' class="SmallInput" wrap="yes"></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='CUSTOMER<?=$FIELDNO?>' class="SmallSelect">
       <option value=""></option>
<?
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
?>

       <option value="<?=$TYPEVALUE_ARRAY[$I]?>"><?=$TYPENAME_ARRAY[$I]?></option>

<?

       }
     }
     if($STYPE=="C")
    {
       $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='CUSTOMER<?=$FIELDNO?>'>
<?
       for($I=0;$I<$TYPENAME_COUNT;$I++)
       {
?>
       <input type="checkbox" name='CCUSTOMER<?=$FIELDNO?>' id='CCUSTOMER<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" onclick="return chk(this,'CCUSTOMER<?=$FIELDNO?>','CUSTOMER<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><label for="CCUSTOMER<?=$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='CUSTOMER<?=$FIELDNO?>' id='CUSTOMER<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"><label for="CUSTOMER<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
       }
    }
?>

    </td>
 </tr>
<?
  }

 }
?>



 <tr>
 		<td nowrap class="TableData"  colspan="6" align="right" width="650">
      <input value="查询" type="submit" class="SmallButton" title="查询" name="button">
    </td>
 </tr>

</table>
</fieldset>
</div>
</form>
</body>
</html>

<?
 function GETALLDATE($CODE)
{
  global $connection;
  $query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
  $connection=OpenConnection();
  $cursor= exequery($connection,$query);
  echo "<option value= ".">".""."</option>";
  while($ROW=mysql_fetch_array($cursor))
  {
   $CODE_NO=$ROW["CODE_NO"];
   $CODE_NAME=$ROW["CODE_NAME"];
   echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
  }

}
?>