npm install axios --save  # 用于發(fā)送請(qǐng)求
npm install js-cookie --save  # 用于識(shí)別用戶

import axios from 'axios';
import Cookies from 'js-cookie';

const Tracker = {
  // 初始化用戶ID（如果不存在）
  initUserId() {
    let userId = Cookies.get('user_id');
    if (!userId) {
      userId = 'user_' + Math.random().toString(36).substr(2, 9);
      Cookies.set('user_id', userId, { expires: 365 });
    }
    return userId;
  },

  // 發(fā)送頁(yè)面訪問(wèn)埋點(diǎn)
  trackPageView() {
    const userId = this.initUserId();
    const data = {
      userId: userId,
      eventType: 'pageview',
      pageUrl: window.location.href,
      timestamp: new Date().toISOString()
    };
    this.sendData(data);
  },

  // 發(fā)送模塊點(diǎn)擊埋點(diǎn)
  trackModuleClick(moduleName) {
    const userId = this.initUserId();
    const data = {
      userId: userId,
      eventType: 'module_click',
      moduleName: moduleName,
      timestamp: new Date().toISOString()
    };
    this.sendData(data);
  },

  // 發(fā)送數(shù)據(jù)到后端
  sendData(data) {
    axios.post('/api/track', data)
      .catch(error => {
        console.error('Tracking error:', error);
      });
  }
};

export default Tracker;

import Tracker from './utils/tracker';
import router from './router';

// 頁(yè)面訪問(wèn)埋點(diǎn)
router.afterEach((to, from) => {
  Tracker.trackPageView();
});

// 掛載到Vue原型，方便組件內(nèi)使用
Vue.prototype.$tracker = Tracker;

<template>
  <div>
    <button @click="handleClick('module1')">模塊1</button>
    <button @click="handleClick('module2')">模塊2</button>
  </div>
</template>

<script>
export default {
  methods: {
    handleClick(moduleName) {
      // 業(yè)務(wù)邏輯...
      
      // 埋點(diǎn)
      this.$tracker.trackModuleClick(moduleName);
    }
  }
}
</script>

CREATE TABLE tracking_events (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id VARCHAR(255),
  event_type VARCHAR(50),
  page_url VARCHAR(500),
  module_name VARCHAR(100),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE daily_stats (
  id INT AUTO_INCREMENT PRIMARY KEY,
  date DATE UNIQUE,
  total_visits INT DEFAULT 0,
  unique_visitors INT DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE module_stats (
  id INT AUTO_INCREMENT PRIMARY KEY,
  module_name VARCHAR(100) UNIQUE,
  click_count INT DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

const express = require('express');
const bodyParser = require('body-parser');
const mysql = require('mysql2/promise');
const app = express();

// 數(shù)據(jù)庫(kù)連接配置
const pool = mysql.createPool({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'tracking_db',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

app.use(bodyParser.json());

// 埋點(diǎn)數(shù)據(jù)接收接口
app.post('/api/track', async (req, res) => {
  try {
    const { userId, eventType, pageUrl, moduleName } = req.body;
    
    // 1. 記錄原始事件
    await pool.query(
      'INSERT INTO tracking_events (user_id, event_type, page_url, module_name) VALUES (?, ?, ?, ?)',
      [userId, eventType, pageUrl, moduleName]
    );
    
    // 2. 如果是頁(yè)面訪問(wèn)，更新每日統(tǒng)計(jì)
    if (eventType === 'pageview') {
      await updateDailyStats(userId);
    }
    
    // 3. 如果是模塊點(diǎn)擊，更新模塊統(tǒng)計(jì)
    if (eventType === 'module_click' && moduleName) {
      await updateModuleStats(moduleName);
    }
    
    res.status(200).send('OK');
  } catch (error) {
    console.error('Tracking error:', error);
    res.status(500).send('Internal Server Error');
  }
});

// 更新每日統(tǒng)計(jì)
async function updateDailyStats(userId) {
  const today = new Date().toISOString().split('T')[0];
  
  // 檢查今天是否已有記錄
  const [rows] = await pool.query('SELECT * FROM daily_stats WHERE date = ?', [today]);
  
  if (rows.length === 0) {
    // 新的一天，創(chuàng)建新記錄
    await pool.query(
      'INSERT INTO daily_stats (date, total_visits, unique_visitors) VALUES (?, 1, 1)',
      [today]
    );
  } else {
    // 更新現(xiàn)有記錄
    // 檢查用戶今天是否已經(jīng)訪問(wèn)過(guò)
    const [visits] = await pool.query(
      'SELECT COUNT(DISTINCT user_id) as user_visited FROM tracking_events ' +
      'WHERE event_type = "pageview" AND DATE(created_at) = ? AND user_id = ?',
      [today, userId]
    );
    
    const isNewVisitor = visits[0].user_visited === 0;
    
    await pool.query(
      'UPDATE daily_stats SET total_visits = total_visits + 1, ' +
      'unique_visitors = unique_visitors + ? WHERE date = ?',
      [isNewVisitor ? 1 : 0, today]
    );
  }
}

// 更新模塊統(tǒng)計(jì)
async function updateModuleStats(moduleName) {
  await pool.query(
    'INSERT INTO module_stats (module_name, click_count) VALUES (?, 1) ' +
    'ON DUPLICATE KEY UPDATE click_count = click_count + 1',
    [moduleName]
  );
}

// 獲取統(tǒng)計(jì)數(shù)據(jù)的接口
app.get('/api/stats', async (req, res) => {
  try {
    // 總訪問(wèn)量
    const [totalVisits] = await pool.query('SELECT SUM(total_visits) as total FROM daily_stats');
    
    // 今日訪問(wèn)量
    const today = new Date().toISOString().split('T')[0];
    const [todayStats] = await pool.query('SELECT * FROM daily_stats WHERE date = ?', [today]);
    
    // 熱門(mén)模塊
    const [popularModules] = await pool.query(
      'SELECT module_name, click_count FROM module_stats ORDER BY click_count DESC LIMIT 5'
    );
    
    res.json({
      totalVisits: totalVisits[0].total || 0,
      todayVisits: todayStats[0] ? todayStats[0].total_visits : 0,
      todayUniqueVisitors: todayStats[0] ? todayStats[0].unique_visitors : 0,
      popularModules: popularModules
    });
  } catch (error) {
    console.error('Error fetching stats:', error);
    res.status(500).send('Internal Server Error');
  }
});

const PORT = 3000;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});

<template>
  <div class="stats-dashboard">
    <h1>網(wǎng)站訪問(wèn)統(tǒng)計(jì)</h1>
    
    <div class="stats-grid">
      <div class="stat-card">
        <h3>總訪問(wèn)量</h3>
        <p class="stat-value">{{ stats.totalVisits }}</p>
      </div>
      
      <div class="stat-card">
        <h3>今日訪問(wèn)量</h3>
        <p class="stat-value">{{ stats.todayVisits }}</p>
      </div>
      
      <div class="stat-card">
        <h3>今日獨(dú)立訪客</h3>
        <p class="stat-value">{{ stats.todayUniqueVisitors }}</p>
      </div>
    </div>
    
    <div class="popular-modules">
      <h2>熱門(mén)模塊</h2>
      <ul>
        <li v-for="(module, index) in stats.popularModules" :key="index">
          {{ module.module_name }}: {{ module.click_count }} 次點(diǎn)擊
        </li>
      </ul>
    </div>
  </div>
</template>

<script>
import axios from 'axios';

export default {
  data() {
    return {
      stats: {
        totalVisits: 0,
        todayVisits: 0,
        todayUniqueVisitors: 0,
        popularModules: []
      }
    };
  },
  mounted() {
    this.fetchStats();
  },
  methods: {
    async fetchStats() {
      try {
        const response = await axios.get('/api/stats');
        this.stats = response.data;
      } catch (error) {
        console.error('Error fetching stats:', error);
      }
    }
  }
};
</script>

<style>
.stats-dashboard {
  max-width: 1200px;
  margin: 0 auto;
  padding: 20px;
}

.stats-grid {
  display: grid;
  grid-template-columns: repeat(3, 1fr);
  gap: 20px;
  margin-bottom: 30px;
}

.stat-card {
  background: #f5f5f5;
  padding: 20px;
  border-radius: 8px;
  text-align: center;
}

.stat-value {
  font-size: 24px;
  font-weight: bold;
  margin: 10px 0 0;
}

.popular-modules ul {
  list-style: none;
  padding: 0;
}

.popular-modules li {
  padding: 10px;
  background: #f0f0f0;
  margin-bottom: 5px;
  border-radius: 4px;
}
</style>