📄 showdetail.php
字号:
<?
include_once("inc/auth.php");
?>
<script Language="JavaScript">
function showlist(srcstr,CUSTOMER_ID,count)
{
if(count==0)count=1;
document.all.EDIT_HTML.height="200%";
document.all.EDIT_HTML.src=srcstr+"?"+"CUSTOMER_ID="+CUSTOMER_ID;
document.all.list.style.display="";
}
</script>
<html>
<head>
<title>客户信息查看</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
$query = "SELECT a.CUSTOMER_NAME as CUSTOMER_NAME,a.CUSTOMER_SHORT as CUSTOMER_SHORT,
a.CUSTOMER_CODE as CUSTOMER_CODE,a.TEL_NO as TEL_NO,a.FAX_NO as FAX_NO,a.CUSTOMER_WWW as CUSTOMER_WWW,
a.EMAIL as EMAIL,b.CODE_NAME as CUSTOMER_AREA ,a.CUSTOMER_ADD as CUSTOMER_ADD,a.POSTALCODE as POSTALCODE,
a.MEMO as MEMO,a.SELLER as SELLER,c.CODE_NAME as SOURCE,d.CODE_NAME as KIND,e.CODE_NAME as SELLMODE,
f.CODE_NAME as ATTRIBUTE,g.CODE_NAME as ENTERTYPE,a.ENTERMEMO as ENTERMEMO,a.MEMO1 as MEMO1,a.USERDEF1 as USERDEF1,
a.USERDEF2 as USERDEF2,a.USERDEF3 as USERDEF3,a.USERDEF4 as USERDEF4,a.USERDEF5 as USERDEF5,
count(DISTINCT h.LINKMAN_ID) AS LINKMANCOUNT,count(DISTINCT i.CONTACT_ID) AS CONTACTCOUNT,
count(DISTINCT j.CONTRACT_ID) AS CONTRACTCOUNT,count(DISTINCT k.HISTORY_ID) AS HISTORYCOUNT
from CUSTOMER a
LEFT OUTER JOIN SYS_CODE b ON a.CUSTOMER_AREA=b.CODE_NO AND b.PARENT_NO = 'AREA'
LEFT OUTER JOIN SYS_CODE c ON a.SOURCE=c.CODE_NO AND c.PARENT_NO = 'CRM_SOURCE'
LEFT OUTER JOIN SYS_CODE d ON a.KIND=d.CODE_NO AND d.PARENT_NO = 'CRM_KIND'
LEFT OUTER JOIN SYS_CODE e ON a.SELLMODE=e.CODE_NO AND e.PARENT_NO = 'SELL_MODE'
LEFT OUTER JOIN SYS_CODE f ON a.ATTRIBUTE=f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'
LEFT OUTER JOIN SYS_CODE g ON a.ENTERTYPE=g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'
LEFT OUTER JOIN LINKMAN h ON a.CUSTOMER_ID=h.CUSTOMER_ID
LEFT OUTER JOIN CONTACT i ON a.CUSTOMER_ID=i.CUSTOMER_ID
LEFT OUTER JOIN CONTRACT j ON a.CUSTOMER_ID=j.CUSTOMER_ID
LEFT OUTER JOIN SALE_HISTORY k ON a.CUSTOMER_ID=k.CUSTOMER_ID
where a.CUSTOMER_ID='$CUSTOMER_ID' group by a.CUSTOMER_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$LINKMANCOUNT=$ROW["LINKMANCOUNT"];
$CONTACTCOUNT=$ROW["CONTACTCOUNT"];
$CONTRACTCOUNT=$ROW["CONTRACTCOUNT"];
$HISTORYCOUNT=$ROW["HISTORYCOUNT"];
$CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
$CUSTOMER_SHORT1=$ROW["CUSTOMER_SHORT"];
$CUSTOMER_CODE1=$ROW["CUSTOMER_CODE"];
$TEL_NO1=$ROW["TEL_NO"];
$FAX_NO1=$ROW["FAX_NO"];
$CUSTOMER_WWW1=$ROW["CUSTOMER_WWW"];
$EMAIL1=$ROW["EMAIL"];
$CUSTOMER_AREA1=$ROW["CUSTOMER_AREA"];
$CUSTOMER_ADD1=$ROW["CUSTOMER_ADD"];
$POSTALCODE1=$ROW["POSTALCODE"];
$MEMO11=$ROW["MEMO"];
$SELLER1=$ROW["SELLER"];
$SOURCE1=$ROW["SOURCE"];
$KIND1=$ROW["KIND"];
$SELLMODE1=$ROW["SELLMODE"];
$ATTRIBUTE1=$ROW["ATTRIBUTE"];
$ENTERTYPE1=$ROW["ENTERTYPE"];
$ENTERMEMO1=$ROW["ENTERMEMO"];
$MEMO12=$ROW["MEMO1"];
$USERDEF11=$ROW["USERDEF1"];
$USERDEF21=$ROW["USERDEF2"];
$USERDEF31=$ROW["USERDEF3"];
$USERDEF41=$ROW["USERDEF4"];
$USERDEF51=$ROW["USERDEF5"];
}
$query2="select * from USER where USER_ID='$SELLER1'";
$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/customerdetail.gif" align="absmiddle"> <span class="big3">客户信息查看</span>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="50" class="small" bgcolor="#000000" cellpadding="3" align="center" >
<tr>
<td nowrap class="TableHeader" colspan="4" align="left">
基本信息：
</td>
<td nowrap class="TableHeader" colspan="2" width="200" align="left">
客户类型：
</td>
<td nowrap class="TableHeader" width="250" colspan="2" align="left">备注1：
</td>
</tr>
<tr>
<td nowrap class="TableData">销售员：</td>
<td nowrap class="TableData" colspan="3">
<?=$SELLER1_NAME?>
</td>
<td nowrap class="TableData">客户来源： </td>
<td nowrap class="TableData">
<?=$SOURCE1?>
</td>
<td class="TableData" colspan="2" rowspan="3">
<?=$MEMO11?>
</td>
</tr>
<tr>
<td nowrap class="TableData">客户名称： </td>
<td nowrap class="TableData" colspan="3">
<?=$CUSTOMER_NAME1?>
</td>
<td nowrap class="TableData">客户类别： </td>
<td nowrap class="TableData">
<?=$KIND1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">客户编码： </td>
<td nowrap class="TableData">
<?=$CUSTOMER_CODE1?>
</td>
<td nowrap class="TableData">客户简称： </td>
<td nowrap class="TableData">
<?=$CUSTOMER_SHORT1?>
</td>
<td nowrap class="TableData">销售方式： </td>
<td nowrap class="TableData">
<?=$SELLMODE1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">电话： </td>
<td nowrap class="TableData">
<?=$TEL_NO1?>
</td>
<td nowrap class="TableData">传真： </td>
<td nowrap class="TableData">
<?=$FAX_NO1?>
</td>
<td nowrap class="TableHeader" colspan="2" align="left">
企业概况：
</td>
<td nowrap class="TableHeader" colspan="2">备注2： </td>
</tr>
<tr>
<td nowrap class="TableData">网址： </td>
<td nowrap class="TableData">
<?=$CUSTOMER_WWW1?>
</td>
<td nowrap class="TableData">电子邮件： </td>
<td nowrap class="TableData">
<?=$EMAIL1?>
</td>
<td nowrap class="TableData">行业属性： </td>
<td nowrap class="TableData" >
<?=$ATTRIBUTE1?>
</td>
<td class="TableData" rowspan="3">
<?=$MEMO12?>
</td>
</tr>
<tr>
<td nowrap class="TableData">地区： </td>
<td nowrap class="TableData">
<?=$CUSTOMER_AREA1?>
</td>
<td nowrap class="TableData">邮政编码： </td>
<td nowrap class="TableData">
<?=$POSTALCODE1?>
</td>
<td nowrap class="TableData">企业性质： </td>
<td nowrap class="TableData">
<?=$ENTERTYPE1?>
</td>
</tr>
<tr>
<td nowrap class="TableData">详细地址： </td>
<td nowrap class="TableData" colspan="3">
<?=$CUSTOMER_ADD1?>
</td>
<td nowrap class="TableData">企业描述： </td>
<td nowrap class="TableData">
<?=$ENTERMEMO1?>
</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="8" 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="7">
<?
if($STYPE=="T")
{
?>
<?=$$FIELDNO1?>
<?
}
if($STYPE=="MT")
{
?>
<?=$$FIELDNO1?>
<?
}
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--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>
<?
}
}
}
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--;
for($I=0;$I<$TYPENAME_COUNT;$I++)
{
$flag=0;
for($T=0;$T< $temp_ARRAY_count;$T++)
{
if($temp_ARRAY[$T]==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>,
<?
}
}
}
}
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++)
{
if($$FIELDNO1==$TYPEVALUE_ARRAY[$I])
{
?>
<?=$TYPENAME_ARRAY[$I]?>
<?
}
}
}
?>
</td>
</tr>
<?
}
}
?>
<tr>
<td nowrap class="TableControl" colspan="8" align="left">
<input type="button" value="联系人信息(记录数<?=$LINKMANCOUNT?>)" class="SmallButton" onclick="showlist('linkmanlist.php','<?=$CUSTOMER_ID?>','<?=ceil($LINKMANCOUNT/4)?>')">
<input type="button" value="客户服务记录(记录数<?=$CONTACTCOUNT?>)" class="SmallButton" onclick="showlist('contactlist.php','<?=$CUSTOMER_ID?>','<?=ceil($CONTACTCOUNT/4)?>')">
<input type="button" value="销售合同(记录数<?=$CONTRACTCOUNT?>)" class="SmallButton" onclick="showlist('contractlist.php','<?=$CUSTOMER_ID?>','<?=ceil($CONTRACTCOUNT/4)?>')">
<input type="button" value="销售记录(记录数<?=$HISTORYCOUNT?>)" class="SmallButton" onclick="showlist('historylist.php','<?=$CUSTOMER_ID?>','<?=ceil($HISTORYCOUNT/4)?>')">
<input type="button" value="关闭" class="SmallButton" onclick="window.close()">
</td>
</tr>
<tr id="list" style="display:none">
<td nowrap class="TableData" colspan="8" align="center" height="300%">
<table border="0" width="100%" align="center">
<tr>
<td >
<iframe id="EDIT_HTML" width="100%" frameborder=0 type="text/x-scriptlet" VIEWASTEXT></iframe>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -