📄 showdetail.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_field.php" );
echo "<style type=\"text/css\">\r\n.s_on{background:url(v2_nav_a.gif) no-repeat top; background-color:#ffc52e; font-weight:bold; color:#fff;}\r\n.s_of{background:url(v2_nav_a.gif) no-repeat center; background-color:#f7f7f7;}\r\n.m_on{background:url(v2_nav_a.gif) no-repeat bottom; cursor:pointer; font-weight:bold;}\r\n.bk_n{height:22px; width:100%; font-size:14px;}\r\n.bk_n1{height:22px; width:50%; font-size:14px;}\r\n.eg{color:#999999; font-size:12px;}\r\n.pt2{padding-top:2px;}\r\n.pl5{padding-left:5px;}\r\n.blbr1d9{border-left:1px solid #d9d9d9; border-right:1px solid #d9d9d9;}\r\n</style>\r\n<script type=\"text/javascript\">\r\n\r\nfunction ControlContent06(){\r\n if (contentid06.style.display == 'none'){\r\n\t contentid06.style.display = '';\r\n\t\timgarrow06.src = '/images/arrow_up.gif';\r\n\t}\r\n else {\r\n\t contentid06.style.display = 'none';\r\n\t\timgarrow06.src = '/images/arrow_down.gif';\r\n\t}\t\r\n\r\n}\r\n\r\nfunction s_chg(td_now)\r\n{\r\n\ts_td_1.className = s_td_2.className = s_td_3.className = s_td_4.className = s_td_5.className=\"s_of\";\r\n\ttd_now.className = \"s_on\";\r\n\r\n\tif(td_now.id == \"s_td_1\")\r\n\t{\t \t\r\n btn1.innerHTML = \"<iframe id='EDIT_HTML1' width='100%' SRC='linkmanlist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "' frameborder=0 height='350'></iframe>\"\r\n\t}\r\n\tif(td_now.id == \"s_td_2\")\r\n\t{\t \t\t\r\n btn1.innerHTML = \"<iframe id='EDIT_HTML1' width='100%' SRC='contactlist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "' frameborder=0 height='350'></iframe>\"\r\n\t}\r\n\tif(td_now.id == \"s_td_3\")\r\n\t{\t\t\t\r\n btn1.innerHTML = \"<iframe id='EDIT_HTML1' width='100%' SRC='contractlist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "' frameborder=0 height='350'></iframe>\"\r\n\t}\r\n\tif(td_now.id == \"s_td_4\")\r\n\t{\t \t\t\r\n btn1.innerHTML = \"<iframe id='EDIT_HTML1' width='100%' SRC='historylist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "' frameborder=0 height='350'></iframe>\" \r\n\t}\r\n\tif(td_now.id == \"s_td_5\")\r\n\t{\t \t\t\r\n btn1.innerHTML = \"<iframe id='EDIT_HTML1' width='100%' SRC='costslist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "' frameborder=0 height='350'></iframe>\"\r\n\t}\r\n\t\r\n}\r\n\r\nfunction mouse_on(td_now)\r\n{\r\n\tif(td_now.className == \"s_on\") return false;\r\n\telse td_now.className = \"m_on\";\r\n}\r\nfunction mouse_of(td_now)\r\n{\r\n\tif(td_now.className == \"s_on\") return false;\r\n\telse td_now.className = \"s_of\";\r\n}\r\n</script>\r\n<html>\r\n<head>\r\n<title>客户信息查看</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"0\" leftmargin=\"0\">\r\n";
$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,\r\n a.CUSTOMER_CODE as CUSTOMER_CODE,a.TEL_NO as TEL_NO,a.FAX_NO as FAX_NO,a.CUSTOMER_WWW as CUSTOMER_WWW,\r\n a.EMAIL as EMAIL,b.CODE_NAME as CUSTOMER_AREA ,a.CUSTOMER_ADD as CUSTOMER_ADD,a.POSTALCODE as POSTALCODE,\r\n a.MEMO as MEMO,a.SELLER as SELLER,c.CODE_NAME as SOURCE,d.CODE_NAME as KIND,e.CODE_NAME as SELLMODE,\r\n f.CODE_NAME as ATTRIBUTE,g.CODE_NAME as ENTERTYPE,a.ENTERMEMO as ENTERMEMO,a.MEMO1 as MEMO1,a.USERDEF1 as USERDEF1,\r\n a.USERDEF2 as USERDEF2,a.USERDEF3 as USERDEF3,a.USERDEF4 as USERDEF4,a.USERDEF5 as USERDEF5,\r\n count(DISTINCT h.LINKMAN_ID) AS LINKMANCOUNT,count(DISTINCT i.CONTACT_ID) AS CONTACTCOUNT,\r\n count(DISTINCT j.CONTRACT_ID) AS CONTRACTCOUNT,count(DISTINCT k.HISTORY_ID) AS HISTORYCOUNT\r\n from CUSTOMER a\r\n LEFT OUTER JOIN SYS_CODE b ON a.CUSTOMER_AREA=b.CODE_NO AND b.PARENT_NO = 'AREA'\r\n LEFT OUTER JOIN SYS_CODE c ON a.SOURCE=c.CODE_NO AND c.PARENT_NO = 'CRM_SOURCE'\r\n LEFT OUTER JOIN SYS_CODE d ON a.KIND=d.CODE_NO AND d.PARENT_NO = 'CRM_KIND'\r\n LEFT OUTER JOIN SYS_CODE e ON a.SELLMODE=e.CODE_NO AND e.PARENT_NO = 'SELL_MODE'\r\n LEFT OUTER JOIN SYS_CODE f ON a.ATTRIBUTE=f.CODE_NO AND f.PARENT_NO = 'CRM_ATTRIBUTE'\r\n LEFT OUTER JOIN SYS_CODE g ON a.ENTERTYPE=g.CODE_NO AND g.PARENT_NO = 'CRM_TYPE'\r\n LEFT OUTER JOIN LINKMAN h ON a.CUSTOMER_ID=h.CUSTOMER_ID\r\n LEFT OUTER JOIN CONTACT i ON a.CUSTOMER_ID=i.CUSTOMER_ID\r\n LEFT OUTER JOIN CONTRACT j ON a.CUSTOMER_ID=j.CUSTOMER_ID\r\n LEFT OUTER JOIN SALE_HISTORY k ON a.CUSTOMER_ID=k.CUSTOMER_ID\r\n 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'];
$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 "\r\n\r\n<table border=\"0\" cellspacing=\"1\" class=\"small\" cellpadding=\"3\" align=\"center\" width=\"100%\">\t\t\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"6\" align=\"left\">\r\n 基本信息：\r\n </td>\r\n\t</tr>\r\n <tr>\r\n\t<td nowrap class=\"TableData\" align=\"right\">客户编码： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_CODE1;
echo " </td>\r\n\t<td nowrap class=\"TableData\" align=\"right\">客户简称： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_SHORT1;
echo " </td>\r\n <td nowrap class=\"TableData\" align=\"right\">客户名称： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_NAME1;
echo " </td> \r\n </tr>\r\n <tr> \r\n <td nowrap class=\"TableData\" align=\"right\">电 话： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $TEL_NO1;
echo " </td>\r\n <td nowrap class=\"TableData\" align=\"right\">传 真： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $FAX_NO1;
echo " </td>\r\n\t <td nowrap class=\"TableData\" align=\"right\">网 址： </td>\r\n <td nowrap class=\"TableData\">\r\n <A HREF=\"";
echo $CUSTOMER_WWW1;
echo "\" target=\"blank\" class=\"cc\" title=\"点击进入\">";
echo $CUSTOMER_WWW1;
echo "</A>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\" align=\"right\">电子邮件： </td>\r\n <td nowrap class=\"TableData\">\r\n <A HREF=\"mailto:";
echo $EMAIL1;
echo "\" class=\"cc\" title=\"发送邮件\">";
echo $EMAIL1;
echo "</A>\r\n </td>\r\n <td nowrap class=\"TableData\" align=\"right\">地 区： </td>\r\n <td nowrap class=\"TableData\">\r\n \t ";
echo $CUSTOMER_AREA1;
echo " </td>\r\n\t <td nowrap class=\"TableData\" align=\"right\">邮政编码： </td>\r\n\t\t<td nowrap class=\"TableData\">\r\n\t\t ";
echo $POSTALCODE1;
echo "\t\t</td>\r\n\t </tr>\r\n\t <tr>\r\n <td nowrap class=\"TableData\" align=\"right\">详细地址： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n \t ";
echo $CUSTOMER_ADD1;
echo " </td> \r\n\t<td nowrap class=\"TableData\" align=\"right\">销 售 员：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $SELLER1_NAME;
echo " </td> \r\n </tr>\r\n <tr class=\"TableHeader\" height=\"25\">\r\n <td nowrap colspan=\"6\"><span>点击查看详细信息</span> <img src=\"/images/arrow_down.gif\" border=\"0\" id=\"imgarrow06\" title=\"展开/收缩\" onClick=\"ControlContent06();\" style=\"cursor:hand\"></td>\r\n </tr>\r\n <tr style=\"display:none\" id=\"contentid06\">\r\n <td colspan=\"6\" valign=\"top\">\r\n<div width=\"100%\">\r\n<table cellpadding=0 cellspacing=1 align=center class=\"small\" width=\"100%\">\r\n <tr height=\"22\">\r\n <td nowrap class=\"TableHeader\" colspan=\"6\" align=\"left\">\r\n 企业概况：\r\n </td>\r\n\t</tr>\r\n\t<tr height=\"22\">\r\n\t <td nowrap class=\"TableData\" align=\"right\">行业属性： </td>\r\n <td nowrap class=\"TableData\" >\r\n ";
echo $ATTRIBUTE1;
echo " </td>\r\n <td nowrap class=\"TableData\" align=\"right\">企业性质： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $ENTERTYPE1;
echo " </td>\r\n <td nowrap class=\"TableData\" align=\"right\">企业描述： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $ENTERMEMO1;
echo " </td>\r\n\t</tr>\r\n <tr height=\"22\">\r\n <td nowrap class=\"TableHeader\" colspan=\"6\" align=\"left\">\r\n 客户类型：\r\n </td>\r\n\t</tr>\r\n <tr height=\"22\">\r\n <td nowrap class=\"TableData\" align=\"right\">客户来源： </td>\r\n <td nowrap class=\"TableData\">\r\n \t";
echo $SOURCE1;
echo " </td>\r\n\t <td nowrap class=\"TableData\" align=\"right\">客户类别： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $KIND1;
echo " </td>\r\n <td nowrap class=\"TableData\" align=\"right\">销售方式： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $SELLMODE1;
echo " </td> </tr>\r\n\t <tr height=\"22\">\r\n <td nowrap class=\"TableControl\" colspan=\"6\" align=\"left\">\r\n 其它信息：\r\n </td>\r\n\t</tr>\r\n\t<tr height=\"22\"> \r\n <td nowrap class=\"TableHeader\" width=\"250\" colspan=\"6\" align=\"left\">备注1：\r\n </td>\r\n </tr>\r\n <tr height=\"22\"> \r\n<td class=\"TableData\" colspan=\"6\">\r\n ";
echo $MEMO11;
echo " </td>\r\n </tr>\r\n\t<tr height=\"22\">\r\n <td nowrap class=\"TableHeader\" colspan=\"6\">备注2： </td>\r\n </tr>\r\n\t<tr height=\"22\">\r\n <td class=\"TableData\" colspan=\"6\">\r\n ";
echo $MEMO12;
echo " </td>\r\n </tr> \r\n <tr>\r\n <td class=\"TableData\" colspan=\"8\">\r\n ";
echo get_field_table( get_field_text( "CUSTOMER", $CUSTOMER_ID ) );
echo " </td>\r\n </tr>\r\n</table>\r\n</div>\r\n</td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" width=\"100%\" height=\"27\" cellpadding=\"0\" cellspacing=\"0\" background=\"/images/line1.gif\">\r\n\t\t\t<tr align=\"center\">\r\n\t\t\t\t<td width=\"8\"></td>\r\n\t\t\t\t<td width=\"80\" id=\"s_td_1\" class=\"s_on\" onClick=\"s_chg(this);\" onMouseOver=\"mouse_on(this);\" onMouseOut=\"mouse_of(this);\">联系人</td>\t\t\t\r\n\t\t\t\t<td width=\"80\" id=\"s_td_2\" class=\"s_of\" onClick=\"s_chg(this);\" onMouseOver=\"mouse_on(this);\" onMouseOut=\"mouse_of(this);\">服务</td>\t\r\n\t\t\t\t<td width=\"80\" id=\"s_td_3\" class=\"s_of\" onClick=\"s_chg(this);\" onMouseOver=\"mouse_on(this);\" onMouseOut=\"mouse_of(this);\">销售合同</td>\r\n\t\t\t\t<td width=\"80\" id=\"s_td_4\" class=\"s_of\" onClick=\"s_chg(this);\" onMouseOver=\"mouse_on(this);\" onMouseOut=\"mouse_of(this);\">销售记录</td>\r\n <td width=\"80\" id=\"s_td_5\" class=\"s_of\" onClick=\"location='index.php'\" onMouseOver=\"mouse_on(this);\" ";
if ( $SEARCH_CENTER_FLAG == "1" )
{
echo "style=display:none";
}
echo " onMouseOut=\"mouse_of(this);\">客户列表</td>\r\n\t\t\t\t<td> </td>\r\n\t\t\t</tr>\r\n\t\t</table>\t\t\t\r\n\t\t<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n\t\t\t<tr align=\"center\" valign=\"middle\">\r\n\t\t\t\t<td id=\"btn1\"> <iframe id=\"EDIT_HTML1\" width=\"100%\" SRC=\"linkmanlist.php?CUSTOMER_ID=";
echo $CUSTOMER_ID;
echo "\" frameborder=0 height=\"350\"></iframe></td>\r\n\t\t\t</tr>\r\n\t\t</table>\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -