📄 index.php
字号:
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 行业属性： </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">
用户自定义字段：
</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"> <?=$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>
<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"> 联系人姓名： </td>
<td nowrap class="TableData">
<input type="text" name="LINKMAN_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">性别：</td>
<td nowrap class="TableData">
<select name="SEX" class="SmallSelect">
<option value=""></option>
<option value="0">男</option>
<option value="1" >女</option>
</select>
</td>
<td nowrap class="TableData">爱好：</td>
<td nowrap class="TableData">
<input type="text" name="HOBBY" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData"> </td>
<td nowrap class="TableData"> </td>
</tr>
<?
$count=0;
$connection=OpenConnection();
$query = "select count(*) from FIELDSETTING where TABLENAME='LINKMAN' 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="8" align="left">
用户自定义字段：
</td>
</tr>
<?
$query = "select * from FIELDSETTING where TABLENAME='LINKMAN' 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"> <?=$FIELDNAME?>：</td>
<td nowrap class="TableData" colspan="7">
<?
if($STYPE=="T")
{
?>
<input type="text" name='LINKMAN<?=$FIELDNO?>' class="SmallInput" size="33" maxlength="25" value="">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=1 name='LINKMAN<?=$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='LINKMAN<?=$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='LINKMAN<?=$FIELDNO?>'>
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<input type="checkbox" name='CLINKMAN<?=$FIELDNO?>' id='CLINKMAN<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" onclick="return chk(this,'CLINKMAN<?=$FIELDNO?>','LINKMAN<?=$FIELDNO?>','<?=$TYPENAME_COUNT?>');"><label for="CLINKMAN<?=$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='LINKMAN<?=$FIELDNO?>' id='LINKMAN<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>"><label for="LINKMAN<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableData" colspan="8" align="right" width="650">
<input value="查询" type="submit" class="SmallButton" title="查询" name="button">
</td>
</tr>
</table>
</fieldset>
</div>
<br>
</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>";
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -