📄 index.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.CUSTOMER_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 LoadWindow()
{
URL="/module/user_select_single";
loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
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");
}
function LoadWindow2()
{
if(document.form1.SHARE.value=="0")
{ alert("共享客户才能设定共享范围");
}
else
{
URL="shareuser.php?SHARE_USERID="+document.all("SHARE_USER").value;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=550,width=750,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.CUSTOMER_NAME.focus();">
<?
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
}
$query2="select * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor2 = exequery($connection, $query2);
if($ROW=mysql_fetch_array($cursor2))
$SELLER1_NAME=$ROW["USER_NAME"];
?>
<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="add.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">
<input type="text" name="TO_NAME" size="15" class="BigStatic" readonly value="<?=$SELLER1_NAME?>">
<?
if(find_id($MANAGERS,$LOGIN_USER_ID))
{
?>
<input type="button" value="选择" class="SmallButton" onClick="LoadWindow()" title="指定销售员" name="button">
<?
}
?> <input type="hidden" name="TO_ID" value="<?=$LOGIN_USER_ID?>">
</td>
<td nowrap class="TableData">是否为共享客户： </td>
<td nowrap class="TableData">
<select name="SHARE" class="BigSelect">
<option value="1">是</option>
<option value="0">否</option>
</select>
<a href="javascript:LoadWindow2();"> 共享范围 </a>
<input type="hidden" name="SHARE_USER" value="<?=$SHARE_USER?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">客户名称： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="CUSTOMER_NAME" class="BigInput" size="50" maxlength="100" value="<?=$CUSTOMER_NAME?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">客户编码： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_CODE" class="BigInput" size="15" maxlength="100" value="<?=$CUSTOMER_CODE?>">
</td>
<td nowrap class="TableData">客户简称： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_SHORT" class="BigInput" size="15" maxlength="100" value="<?=$CUSTOMER_SHORT?>">
</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_NO?>">
</td>
<td nowrap class="TableData">传真： </td>
<td nowrap class="TableData">
<input type="text" name="FAX_NO" class="BigInput" size="15" maxlength="100" value="<?=$FAX_NO?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">网址： </td>
<td nowrap class="TableData">
<input type="text" name="CUSTOMER_WWW" class="BigInput" size="15" maxlength="100" value="<?=$CUSTOMER_WWW?>">
</td>
<td nowrap class="TableData">电子邮件： </td>
<td nowrap class="TableData">
<input type="text" name="EMAIL" class="BigInput" size="15" maxlength="100" value="<?=$EMAIL?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">地区： </td>
<td nowrap class="TableData">
<select name="CUSTOMER_AREA" class="BigSelect">
<?
GETALLDATE("AREA");
?>
</select>
<a href="javascript:LoadWindow1('CUSTOMER_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="<?=$POSTALCODE?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">详细地址： </td>
<td nowrap class="TableData" colspan="3">
<textarea cols=57 rows=3 name="CUSTOMER_ADD" class="BigInput" wrap="yes"><?=$MEMO?></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" >
<select name="SOURCE" class="BigSelect">
<?
GETALLDATE("CRM_SOURCE");
?>
</select>
<a href="javascript:LoadWindow1('SOURCE','CRM_SOURCE');"><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="KIND" class="BigSelect">
<?
GETALLDATE("CRM_KIND");
?>
</select>
<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");
?>
</select>
<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");
?>
</select>
<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");
?>
</select>
<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"><?=$ENTERMEMO?></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"><?=$MEMO1?></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"><?=$MEMO2?></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"];
?>
<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="">
<?
}
if($STYPE=="MT")
{
?>
<textarea cols=37 rows=3 name='<?=$FIELDNO?>' class="BigInput" 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='<?=$FIELDNO?>' class="BigSelect">
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<option value="<?=$TYPEVALUE_ARRAY[$I]?>" <?if($GROUPID==$GROUP_ID) echo "selected";?>><?=$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='<?=$FIELDNO?>'>
<?
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
?>
<input type="checkbox" name='C<?=$FIELDNO?>' id='C<?=$FIELDNO?><?=$I?>' value="<?=$TYPEVALUE_ARRAY[$I]?>" 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($FLOW_FLAG=="1") echo "checked";?> ><label for="<?=$FIELDNO?><?=$I?>"><?=$TYPENAME_ARRAY[$I]?></label>
<?
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableControl" colspan="4" align="center">
<input type="submit" value="确定" class="BigButton" title="新建客户" name="button">
<input type="button" value="清空" class="BigButton" onclick="location='index.php'">
</td>
</tr>
</form>
</table>
</body>
</html>
<?
function GETALLDATE($CODE)
{
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"];
echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -