📄 showdetail.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "<script Language=\"JavaScript\">\r\n function showlist(srcstr,CUSTOMER_ID,count)\r\n{\r\n if(count==0)count=1;\r\n document.all.EDIT_HTML.height=\"200%\";\r\n document.all.EDIT_HTML.src=srcstr+\"?\"+\"CUSTOMER_ID=\"+CUSTOMER_ID;\r\n document.all.list.style.display=\"\";\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=\"5\">\r\n";
$query = "SELECT CREATDATE,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'];
$CREATDATE = $ROW['CREATDATE'];
}
$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<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/customerdetail.gif\" align=\"absmiddle\"> <span class=\"big3\">客户信息查看</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n<table border=\"0\" cellspacing=\"1\" width=\"50\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\" align=\"center\" >\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"4\" align=\"left\">\r\n 基本信息：\r\n </td>\r\n <td nowrap class=\"TableHeader\" colspan=\"2\" width=\"200\" align=\"left\">\r\n 客户类型：\r\n </td>\r\n <td nowrap class=\"TableHeader\" width=\"250\" colspan=\"2\" align=\"left\">备注1：\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">销售员：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $SELLER1_NAME;
echo " </td>\r\n <td nowrap class=\"TableData\">记录时间：</td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CREATDATE;
echo " </td>\r\n <td nowrap class=\"TableData\">客户来源： </td>\r\n <td nowrap class=\"TableData\">\r\n \t";
echo $SOURCE1;
echo " </td>\r\n <td class=\"TableData\" colspan=\"2\" rowspan=\"3\">\r\n ";
echo $MEMO11;
echo " </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">客户名称： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n ";
echo $CUSTOMER_NAME1;
echo " </td>\r\n <td nowrap class=\"TableData\">客户类别： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $KIND1;
echo " </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">客户编码： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_CODE1;
echo " </td>\r\n\r\n <td nowrap class=\"TableData\">客户简称： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_SHORT1;
echo " </td>\r\n <td nowrap class=\"TableData\">销售方式： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $SELLMODE1;
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">电话： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $TEL_NO1;
echo " </td>\r\n <td nowrap class=\"TableData\">传真： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $FAX_NO1;
echo " </td>\r\n <td nowrap class=\"TableHeader\" colspan=\"2\" align=\"left\">\r\n 企业概况：\r\n </td>\r\n <td nowrap class=\"TableHeader\" colspan=\"2\">备注2： </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">网址： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $CUSTOMER_WWW1;
echo " </td>\r\n <td nowrap class=\"TableData\">电子邮件： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $EMAIL1;
echo " </td>\r\n <td nowrap class=\"TableData\">行业属性： </td>\r\n <td nowrap class=\"TableData\" >\r\n ";
echo $ATTRIBUTE1;
echo " </td>\r\n <td class=\"TableData\" rowspan=\"3\">\r\n ";
echo $MEMO12;
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">地区： </td>\r\n <td nowrap class=\"TableData\">\r\n \t ";
echo $CUSTOMER_AREA1;
echo " </td>\r\n <td nowrap class=\"TableData\">邮政编码： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $POSTALCODE1;
echo " </td>\r\n <td nowrap class=\"TableData\">企业性质： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $ENTERTYPE1;
echo " </td>\r\n </tr>\r\n\r\n <tr>\r\n <td nowrap class=\"TableData\">详细地址： </td>\r\n <td nowrap class=\"TableData\" colspan=\"3\">\r\n \t ";
echo $CUSTOMER_ADD1;
echo " </td>\r\n <td nowrap class=\"TableData\">企业描述： </td>\r\n <td nowrap class=\"TableData\">\r\n ";
echo $ENTERMEMO1;
echo " </td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableData\">附件： </td>\r\n <td nowrap class=\"TableData\" colspan=\"8\">\r\n";
if ( $ATTACHMENT_ID == "" )
{
echo "无";
}
else
{
echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 0, 0, 0, 1, 0, "" );
}
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 <tr>\r\n <td nowrap class=\"TableControl\" colspan=\"8\" align=\"left\">\r\n \t <input type=\"button\" value=\"联系人信息(记录数";
echo $LINKMANCOUNT;
echo ")\" class=\"SmallButton\" onclick=\"showlist('linkmanlist.php','";
echo $CUSTOMER_ID;
echo "','";
echo ceil( $LINKMANCOUNT / 4 );
echo "')\">\r\n \t <input type=\"button\" value=\"客户服务记录(记录数";
echo $CONTACTCOUNT;
echo ")\" class=\"SmallButton\" onclick=\"showlist('contactlist.php','";
echo $CUSTOMER_ID;
echo "','";
echo ceil( $CONTACTCOUNT / 4 );
echo "')\">\r\n \t <input type=\"button\" value=\"销售合同(记录数";
echo $CONTRACTCOUNT;
echo ")\" class=\"SmallButton\" onclick=\"showlist('contractlist.php','";
echo $CUSTOMER_ID;
echo "','";
echo ceil( $CONTRACTCOUNT / 4 );
echo "')\">\r\n \t <input type=\"button\" value=\"销售记录(记录数";
echo $HISTORYCOUNT;
echo ")\" class=\"SmallButton\" onclick=\"showlist('historylist.php','";
echo $CUSTOMER_ID;
echo "','";
echo ceil( $HISTORYCOUNT / 4 );
echo "')\">\r\n <input type=\"button\" value=\"关闭\" class=\"SmallButton\" onclick=\"window.close()\">\r\n </td>\r\n </tr>\r\n\r\n <tr id=\"list\" style=\"display:none\">\r\n <td nowrap class=\"TableData\" colspan=\"8\" align=\"center\" height=\"300%\">\r\n <table border=\"0\" width=\"100%\" align=\"center\">\r\n <tr>\r\n <td >\r\n <iframe id=\"EDIT_HTML\" width=\"100%\" frameborder=0 type=\"text/x-scriptlet\" VIEWASTEXT></iframe>\r\n </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n\r\n\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -