php项目统计斜长传精准度如何？

wen PHP项目 2026-08-07 88

本文目录导读：

php项目统计斜长传精准度如何？

数据库表设计
核心统计类
使用示例
前端展示（可选）
核心功能亮点：

我来帮你设计一个PHP项目统计斜长传精准度的方案,这里提供完整的数据结构和实现代码：

数据库表设计

-- 球员表
CREATE TABLE players (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    team_id INT,
    position VARCHAR(20)
);
-- 传球记录表
CREATE TABLE passes (
    id INT PRIMARY KEY AUTO_INCREMENT,
    player_id INT NOT NULL,
    match_id INT NOT NULL,
    pass_type ENUM('long_ball', 'through_ball', 'cross') DEFAULT 'long_ball',
    start_x DECIMAL(5,2),  -- 传球起始X坐标
    start_y DECIMAL(5,2),  -- 传球起始Y坐标
    end_x DECIMAL(5,2),    -- 传球落点X坐标
    end_y DECIMAL(5,2),    -- 传球落点Y坐标
    target_x DECIMAL(5,2), -- 预期目标X坐标
    target_y DECIMAL(5,2), -- 预期目标Y坐标
    is_success TINYINT(1) DEFAULT 0,  -- 是否成功
    pass_distance DECIMAL(5,2),       -- 传球距离
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_player_date (player_id, created_at)
);
-- 比赛信息表
CREATE TABLE matches (
    id INT PRIMARY KEY AUTO_INCREMENT,
    home_team VARCHAR(50),
    away_team VARCHAR(50),
    match_date DATE,
    competition VARCHAR(50)
);

核心统计类

<?php
class LongPassAnalyzer {
    private $pdo;
    private $playerId;
    public function __construct(PDO $pdo, $playerId) {
        $this->pdo = $pdo;
        $this->playerId = $playerId;
    }
    /**
     * 计算单次传球精准度
     */
    public function calculatePassAccuracy($pass) {
        // 目标位置与实际落点距离
        $targetDistance = $this->calculateDistance(
            $pass['target_x'], 
            $pass['target_y'], 
            $pass['end_x'], 
            $pass['end_y']
        );
        // 根据距离计算精准度 (0-100)
        $accuracy = max(0, 100 - $targetDistance * 2);
        return $accuracy;
    }
    /**
     * 获取球员所有传球统计
     */
    public function getPlayerStatistics($dateFrom = null, $dateTo = null) {
        $sql = "SELECT 
                    p.id,
                    p.pass_type,
                    p.is_success,
                    p.pass_distance,
                    p.start_x, p.start_y,
                    p.end_x, p.end_y,
                    p.target_x, p.target_y,
                    m.match_date,
                    m.competition
                FROM passes p
                INNER JOIN matches m ON p.match_id = m.id
                WHERE p.player_id = :playerId";
        if ($dateFrom && $dateTo) {
            $sql .= " AND m.match_date BETWEEN :dateFrom AND :dateTo";
            $params = [
                ':playerId' => $this->playerId,
                ':dateFrom' => $dateFrom,
                ':dateTo' => $dateTo
            ];
        } else {
            $params = [':playerId' => $this->playerId];
        }
        $sql .= " ORDER BY m.match_date DESC";
        $stmt = $this->pdo->prepare($sql);
        $stmt->execute($params);
        $passes = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $statistics = [
            'total_passes' => count($passes),
            'success_passes' => 0,
            'avg_accuracy' => 0,
            'distance_breakdown' => [],
            'type_breakdown' => [],
            'recent_trend' => []
        ];
        foreach ($passes as $pass) {
            // 统计成功率
            if ($pass['is_success']) {
                $statistics['success_passes']++;
            }
            // 计算精准度
            $accuracy = $this->calculatePassAccuracy($pass);
            $statistics['avg_accuracy'] += $accuracy;
            // 按距离分组统计
            $distanceCategory = $this->categorizeDistance($pass['pass_distance']);
            if (!isset($statistics['distance_breakdown'][$distanceCategory])) {
                $statistics['distance_breakdown'][$distanceCategory] = [
                    'count' => 0,
                    'accuracy_sum' => 0
                ];
            }
            $statistics['distance_breakdown'][$distanceCategory]['count']++;
            $statistics['distance_breakdown'][$distanceCategory]['accuracy_sum'] += $accuracy;
            // 按传球类型统计
            // ... 类似距离统计
        }
        // 计算平均精准度
        if ($statistics['total_passes'] > 0) {
            $statistics['avg_accuracy'] = round(
                $statistics['avg_accuracy'] / $statistics['total_passes'], 2
            );
        }
        // 计算成功率
        $statistics['success_rate'] = $statistics['total_passes'] > 0 
            ? round(($statistics['success_passes'] / $statistics['total_passes']) * 100, 1)
            : 0;
        // 近10场比赛趋势
        $statistics['recent_trend'] = $this->getRecentTrend($passes);
        return $statistics;
    }
    /**
     * 计算两点距离
     */
    private function calculateDistance($x1, $y1, $x2, $y2) {
        return sqrt(pow($x2 - $x1, 2) + pow($y2 - $y1, 2));
    }
    /**
     * 距离分类
     */
    private function categorizeDistance($distance) {
        if ($distance < 30) return 'short';
        if ($distance < 45) return 'medium';
        if ($distance < 60) return 'long';
        return 'very_long';
    }
    /**
     * 获取近期趋势
     */
    private function getRecentTrend($passes) {
        $trend = [];
        $summary = array_slice($passes, 0, 10); // 最近10场
        foreach ($summary as $pass) {
            $date = $pass['match_date'];
            if (!isset($trend[$date])) {
                $trend[$date] = [
                    'total' => 0,
                    'accuracy' => 0
                ];
            }
            $trend[$date]['total']++;
            $trend[$date]['accuracy'] += $this->calculatePassAccuracy($pass);
        }
        // 计算每日平均
        foreach ($trend as &$day) {
            $day['avg_accuracy'] = $day['total'] > 0 
                ? round($day['accuracy'] / $day['total'], 1) 
                : 0;
            unset($day['accuracy']);
        }
        return $trend;
    }
    /**
     * 多维度分析报告
     */
    public function generateReport() {
        $statistics = $this->getPlayerStatistics();
        return [
            'summary' => [
                'total_pass_attempts' => $statistics['total_passes'],
                'success_rate' => $statistics['success_rate'],
                'avg_accuracy' => $statistics['avg_accuracy']
            ],
            'performance_by_distance' => $this->formatDistanceBreakdown($statistics['distance_breakdown']),
            'strengths' => $this->identifyStrengths($statistics),
            'areas_for_improvement' => $this->identifyWeaknesses($statistics),
            'recommendations' => $this->generateRecommendations($statistics)
        ];
    }
    /**
     * 格式化距离统计
     */
    private function formatDistanceBreakdown($distanceStats) {
        $formatted = [];
        foreach ($distanceStats as $category => $data) {
            $formatted[$category] = [
                'attempts' => $data['count'],
                'avg_accuracy' => $data['count'] > 0 
                    ? round($data['accuracy_sum'] / $data['count'], 1)
                    : 0
            ];
        }
        return $formatted;
    }
    /**
     * 球员对标分析（与队内平均比较）
     */
    public function compareToTeamAverage($teamId, $dateFrom = null, $dateTo = null) {
        $playerStats = $this->getPlayerStatistics($dateFrom, $dateTo);
        // 获取队伍平均数据
        $sql = "SELECT AVG(is_success) * 100 as success_rate
                FROM passes p
                INNER JOIN players pl ON p.player_id = pl.id
                WHERE pl.team_id = :teamId";
        if ($dateFrom && $dateTo) {
            $sql .= " AND p.created_at BETWEEN :dateFrom AND :dateTo";
        }
        $stmt = $this->pdo->prepare($sql);
        $stmt->execute(['teamId' => $teamId]);
        $teamSuccessRate = $stmt->fetchColumn();
        return [
            'player' => $playerStats,
            'team_avg' => [
                'success_rate' => round($teamSuccessRate, 1)
            ],
            'comparison' => [
                'success_rate_diff' => round($playerStats['success_rate'] - $teamSuccessRate, 1)
            ]
        ];
    }
}

使用示例

<?php
// 初始化
$pdo = new PDO('mysql:host=localhost;dbname=football', 'user', 'pass');
$analyzer = new LongPassAnalyzer($pdo, 12345);
// 获取球员统计
$stats = $analyzer->getPlayerStatistics('2024-01-01', '2024-06-30');
// 生成完整报告
$report = $analyzer->generateReport();
// 与队伍对比
$teamComparison = $analyzer->compareToTeamAverage(678);
// 输出结果
echo json_encode($stats, JSON_PRETTY_PRINT);

前端展示（可选）

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<div class="pass-accuracy-chart">
    <canvas id="accuracyChart"></canvas>
</div>
<script>
const ctx = document.getElementById('accuracyChart').getContext('2d');
new Chart(ctx, {
    type: 'line',
    data: {
        labels: Object.keys(trendData),
        datasets: [{
            label: '精准度趋势',
            data: Object.values(trendData).map(d => d.avg_accuracy),
            borderColor: 'rgba(75, 192, 192, 1)',
            fill: false
        }]
    }
});
</script>