igamebox
/
mtb_crm_asp


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132
							<!--#include file="Conn.asp"--><%Checklogin()%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>管理区域</title>
<link rel="stylesheet" href="css/common.css" type="text/css" />
<link rel="stylesheet" href="css/alert.css" type="text/css" />
<script language="javascript" src="system/js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="js/js.js"></script>
</head>
<body class="clear">
<!--#include file="panel.asp"-->
<div id="man_zone">
	<div class="tagclound">
		<h1 class="tagCloundHead">自定义标签云</h1>
		<div class="tagArea">
	<%Set Rs=Server.CreateObject("ADODB.RecordSet")
		  Rs.Open "SELECT  tagName,count(Distinct cs_code) as count from tagTable left join customer on tagTable.customerid=customer.id where employeeId="&Session("employee_id")&" GROUP BY tagName",conn,1,1
		  Do while Not Rs.Bof And Not Rs.eof 
	%>
		<a href="tag.asp?tagName=<%=Server.urlEnCode(Rs("tagName"))%>" style="font-size:16px;"><%=Rs("tagName")%>(<%=Rs("count")%>)</a>
	<%    Rs.moveNext
		  loop
	%>
		<a href="nullTag.asp">无标签客户</a>
		</div>
	<%Rs.Close:Set Rs=Nothing:Conn.Close:Set Conn=Nothing%>
	</div>
</div>
</body>
</html>