igamebox
/
mtb_crm_asp


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
							<?php
require_once 'conn.php';
checkLogin();
?>
<!DOCTYPE html>
<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 src="system/js/jquery-1.7.2.min.js"></script>
    <script src="js/js.js"></script>
    <style>
        body {
            margin: 0;
            padding: 20px;
            background: #fff;
        }
        #man_zone {
            margin-left: 0;
        }
    </style>
</head>
<body class="clear">
<?php // require_once 'panel.php'; ?>
<div id="man_zone">
    <div class="tagclound">
        <h1 class="tagCloundHead">自定义标签云</h1>
        <div class="tagArea">
        <?php
        $result = $conn->query("SELECT tagName, COUNT(DISTINCT c.cs_code) as count 
                               FROM tagtable t
                               LEFT JOIN customer c ON t.customerId = c.id 
                               WHERE t.employeeId = " . $_SESSION['employee_id'] . " 
                               GROUP BY tagName");
        
        if ($result) {
            while ($row = $result->fetch_assoc()) {
                echo '<a href="tag.php?tagName=' . urlencode($row['tagName']) . '" style="font-size:16px;">' . 
                     htmlspecialcharsFix($row['tagName']) . '(' . $row['count'] . ')</a>';
            }
        }
        ?>
            <a href="nullTag.php">无标签客户</a>
        </div>
    </div>
</div>
</body>
</html>