📄 showdetail.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '<s';
echo 'tyle type="text/css">
.s_on{background:url(v2_nav_a.gif) no-repeat top; background-color:#ffc52e; font-weight:bold; color:#fff;}
.s_of{background:url(v2_nav_a.gif) no-repeat center; background-color:#f7f7f7;}
.m_on{background:url(v2_nav_a.gif) no-repeat bottom; cursor:pointer; font-weight:bold;}
.bk_n{height:22px; width:100%; font-size:14px;}
.bk_n1{height:22px; width:50%; font-size:14px;}
.';
echo 'eg{color:#999999; font-size:12px;}
.pt2{padding-top:2px;}
.pl5{padding-left:5px;}
.blbr1d9{border-left:1px solid #d9d9d9; border-right:1px solid #d9d9d9;}
</style>
';
echo '<s';
echo 'cript type="text/javascript">
function ControlContent06(){
if (contentid06.style.display == \'none\'){
contentid06.style.display = \'\';
imgarrow06.src = \'/images/arrow_up.gif\';
}
else {
contentid06.style.display = \'none\';
imgarrow06.src = \'/images/arrow_down.gif\';
}
}
function s_chg(td_now)
{
s_td_1.className = s_td_2.className = s_td_3.className = s_td_4.';
echo 'className = s_td_5.className="s_of";
td_now.className = "s_on";
if(td_now.id == "s_td_1")
{
btn1.innerHTML = "<iframe id=\'EDIT_HTML1\' width=\'100%\' SRC=\'linkmanlist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\' frameborder=0 height=\'350\'></iframe>"
}
if(td_now.id == "s_td_2")
{
btn1.innerHTML = "<iframe id=\'EDIT_HTML1\' width=\'100%\' SRC=\'contactlist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\' frameborder=0 height=\'350\'></iframe>"
}
if(td_now.id == "s_td_3")
{
btn1.innerHTML = "<iframe id=\'EDIT_HTML1\' width=\'100%\' SRC=\'contractlist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\' frameborder=0 height=\'350\'></iframe>"
}
if(td_now.id == "s_td_4")
{
btn1.innerHTML = "<iframe id=\'EDIT_HTML1\' width=\'100%\' SRC=\'historylist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\' frameborder=0 height=\'350\'></iframe>"
}
if(td_now.id == "s_td_5")
{
btn1.innerHTML = "<iframe id=\'EDIT_HTML1\' width=\'100%\' SRC=\'costslist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '\' frameborder=0 height=\'350\'></iframe>"
}
}
function mouse_on(td_now)
{
if(td_now.className == "s_on") return false;
else td_now.className = "m_on";
}
function mouse_of(td_now)
{
if(td_now.className == "s_on") return false;
else td_now.className = "s_of";
}
</script>
<html>
<head>
<title>客户信息查看</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '</head>
<body class="bodycolor" topmargin="0" leftmargin="0">
';
$query = (((''.'SELECT a.ATTACHMENT_ID as ATTACHMENT_ID,a.ATTACHMENT_NAME as ATTACHMENT_NAME,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 = strip_tags ($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'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
}
$query2 = (((''.'select * from USER where USER_ID=\'').$SELLER1).'\'');
$cursor2 = exequery ($connection, $query2);
if ($ROW = mysql_fetch_array ($cursor2))
{
$SELLER1_NAME = $ROW['USER_NAME'];
}
echo '
<table border="0" cellspacing="1" class="small" cellpadding="3" align="center" width="100%">
<tr>
<td nowrap class="TableHeader" colspan="6" align="left">
基本信息：
</td>
</tr>
<tr>
<td nowrap class="TableData" align="right">客户编码： </td>
<td nowrap class="TableData">
';
echo $CUSTOMER_CODE1;
echo ' </td>
<td nowrap class="TableData" align="right">客户简称： </td>
<td nowrap class="TableData">
';
echo $CUSTOMER_SHORT1;
echo ' </td>
<td nowrap class="TableData" align="right">客户名称： </td>
<td nowrap class="TableData">
';
echo $CUSTOMER_NAME1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData" align="right">电 话： </td>
<td nowrap class="TableData">
';
echo $TEL_NO1;
echo ' </td>
<td nowrap class="TableData" align="right">传 真： </td>
<td nowrap class="TableData">
';
echo $FAX_NO1;
echo ' </td>
<td nowrap class="TableData" align="right">网 址： </td>
<td nowrap class="TableData">
<A HREF="';
echo $CUSTOMER_WWW1;
echo '" target="blank" class="cc" title="点击进入">';
echo $CUSTOMER_WWW1;
echo '</A>
</td>
</tr>
<tr>
<td nowrap class="TableData" align="right">电子邮件： </td>
<td nowrap class="TableData">
<A HREF="mailto:';
echo $EMAIL1;
echo '" class="cc" title="发送邮件">';
echo $EMAIL1;
echo '</A>
</td>
<td nowrap class="TableData" align="right">地 区： </td>
<td nowrap class="TableData">
';
echo $CUSTOMER_AREA1;
echo ' </td>
<td nowrap class="TableData" align="right">邮政编码： </td>
<td nowrap class="TableData">
';
echo $POSTALCODE1;
echo ' </td>
</tr>
<tr>
<td nowrap class="TableData" align="right">详细地址： </td>
<td nowrap class="TableData" colspan="3">
';
echo $CUSTOMER_ADD1;
echo ' </td>
<td nowrap class="TableData" align="right">销 售 员：</td>
<td nowrap class="TableData">
';
echo $SELLER1_NAME;
echo ' </td>
</tr>
<tr class="TableHeader" height="25">
<td nowrap colspan="6">';
echo '<s';
echo 'pan>点击查看详细信息</span> <img src="/images/arrow_down.gif" border="0" id="imgarrow06" title="展开/收缩" onClick="ControlContent06();" style="cursor:hand"></td>
</tr>
<tr style="display:none" id="contentid06">
<td colspan="6" valign="top">
<div width="100%">
<table cellpadding=0 cellspacing=1 align=center class="small" width="100%">
<tr height="22">
<td nowrap class="';
echo 'TableHeader" colspan="6" align="left">
企业概况：
</td>
</tr>
<tr height="22">
<td nowrap class="TableData" align="right">行业属性： </td>
<td nowrap class="TableData" >
';
echo $ATTRIBUTE1;
echo ' </td>
<td nowrap class="TableData" align="right">企业性质： </td>
<td nowrap class="TableData">
';
echo $ENTERTYPE1;
echo ' </td>
<td nowrap class="TableData" align="right">企业描述： </td>
<td nowrap class="TableData">
';
echo $ENTERMEMO1;
echo ' </td>
</tr>
<tr height="22">
<td nowrap class="TableHeader" colspan="6" align="left">
客户类型：
</td>
</tr>
<tr height="22">
<td nowrap class="TableData" align="right">客户来源： </td>
<td nowrap class="TableData">
';
echo $SOURCE1;
echo ' </td>
<td nowrap class="TableData" align="right">客户类别： </td>
<td nowrap class="TableData">
';
echo $KIND1;
echo ' </td>
<td nowrap class="TableData" align="right">销售方式： </td>
<td nowrap class="TableData">
';
echo $SELLMODE1;
echo ' </td> </tr>
<tr height="22">
<td nowrap class="TableControl" colspan="6" align="left">
其它信息：
</td>
</tr>
<tr height="22">
<td nowrap class="TableHeader" width="250" colspan="6" align="left">备注1：
</td>
</tr>
<tr height="22">
<td class="TableData" colspan="6">
';
echo $MEMO11;
echo ' </td>
</tr>
<tr height="22">
<td nowrap class="TableHeader" colspan="6">备注2： </td>
</tr>
<tr height="22">
<td class="TableData" colspan="6">
';
echo $MEMO12;
echo ' </td>
</tr>
<tr>
<td class="TableData" colspan="8">
';
echo get_field_table (get_field_text ('CUSTOMER', $CUSTOMER_ID));
echo ' </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<table border="0" width="100%" height="27" cellpadding="0" cellspacing="0" background="/images/line1.gif">
<tr align="center">
<td width="8"></td>
<td width="80" id="s_td_1" class="s_on" onClick="s_chg(this);" onMouseOver="mouse_on(this);" onMouseOut="mouse_of(this);">联系人</td>
<td width="80" id="s_td_2" class="s_of" onClic';
echo 'k="s_chg(this);" onMouseOver="mouse_on(this);" onMouseOut="mouse_of(this);">服务</td>
<td width="80" id="s_td_3" class="s_of" onClick="s_chg(this);" onMouseOver="mouse_on(this);" onMouseOut="mouse_of(this);">销售合同</td>
<td width="80" id="s_td_4" class="s_of" onClick="s_chg(this);" onMouseOver="mouse_on(this);" onMouseOut="mouse_of(this);">销售记录</td>
<td width="80" id="s_td_5" class';
echo '="s_of" onClick="location=\'index.php\'" onMouseOver="mouse_on(this);" onMouseOut="mouse_of(this);">客户列表</td>
<td> </td>
</tr>
</table>
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr align="center" valign="middle">
<td id="btn1"> <iframe id="EDIT_HTML1" width="100%" SRC="linkmanlist.php?CUSTOMER_ID=';
echo $CUSTOMER_ID;
echo '" frameborder=0 height="350"></iframe></td>
</tr>
</table>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -