php项目怎么看两队的中场控制力对比？

PHP项目：两队中场控制力对比分析

要在PHP项目中实现"两队中场控制力对比"，核心是定义可量化的指标 + 数据采集 + 算法计算 + 可视化展示，下面给你一套完整方案。

中场控制力的量化指标设计

中场控制力本质是"谁能掌控比赛节奏和球权"，推荐用以下指标组合：

综合控制力指数公式：

中场控制力 = Σ(指标归一化值 × 权重)

数据库设计（MySQL）

-- 球队比赛数据表
CREATE TABLE match_stats (
    id INT PRIMARY KEY AUTO_INCREMENT,
    match_id INT,
    team_id INT,
    possession DECIMAL(5,2),        -- 控球率 %
    passes INT,                      -- 传球总数
    pass_accuracy DECIMAL(5,2),      -- 传球成功率
    forward_passes INT,              -- 向前传球
    key_passes INT,                  -- 关键传球
    interceptions INT,               -- 拦截
    tackles INT,                     -- 抢断
    recoveries INT,                  -- 夺回球权
    final_third_passes INT,          -- 进攻三区传球
    created_at TIMESTAMP
);
-- 中场球员明细表
CREATE TABLE midfield_players_stats (
    id INT PRIMARY KEY AUTO_INCREMENT,
    match_id INT,
    team_id INT,
    player_id INT,
    position VARCHAR(10),            -- CM/CDM/CAM
    passes INT,
    pass_accuracy DECIMAL(5,2),
    progressive_passes INT,          -- 推进传球
    duels_won INT,                   -- 对抗成功
    rating DECIMAL(3,1)              -- 评分
);

核心PHP计算类

<?php
class MidfieldControlAnalyzer
{
    // 指标权重配置
    private array $weights = [
        'possession'        => 0.15,
        'pass_accuracy'     => 0.15,
        'forward_ratio'     => 0.15,
        'key_passes'        => 0.15,
        'interceptions'     => 0.15,
        'tackles'           => 0.10,
        'recoveries'        => 0.10,
        'final_third_ratio' => 0.05,
    ];
    /**
     * 计算单队中场控制力得分（0-100）
     */
    public function calcControlScore(array $stats, array $benchmarks): float
    {
        $score = 0;
        // 控球率
        $score += $this->normalize($stats['possession'], 0, 100) 
                  * $this->weights['possession'] * 100;
        // 传球成功率
        $score += $this->normalize($stats['pass_accuracy'], 60, 95)
                  * $this->weights['pass_accuracy'] * 100;
        // 向前传球占比
        $forwardRatio = $stats['passes'] > 0 
            ? $stats['forward_passes'] / $stats['passes'] * 100 : 0;
        $score += $this->normalize($forwardRatio, 20, 50)
                  * $this->weights['forward_ratio'] * 100;
        // 关键传球（按基准最大值归一）
        $score += $this->normalize($stats['key_passes'], 0, $benchmarks['max_key_passes'])
                  * $this->weights['key_passes'] * 100;
        // 拦截
        $score += $this->normalize($stats['interceptions'], 0, $benchmarks['max_interceptions'])
                  * $this->weights['interceptions'] * 100;
        // 抢断
        $score += $this->normalize($stats['tackles'], 0, $benchmarks['max_tackles'])
                  * $this->weights['tackles'] * 100;
        // 夺回球权
        $score += $this->normalize($stats['recoveries'], 0, $benchmarks['max_recoveries'])
                  * $this->weights['recoveries'] * 100;
        // 进攻三区传球占比
        $finalThirdRatio = $stats['passes'] > 0 
            ? $stats['final_third_passes'] / $stats['passes'] * 100 : 0;
        $score += $this->normalize($finalThirdRatio, 15, 40)
                  * $this->weights['final_third_ratio'] * 100;
        return round($score, 2);
    }
    /**
     * 对比两队，返回对比结果
     */
    public function compare(array $teamA, array $teamB, array $benchmarks): array
    {
        $scoreA = $this->calcControlScore($teamA, $benchmarks);
        $scoreB = $this->calcControlScore($teamB, $benchmarks);
        // 计算控制力差距百分比
        $total = $scoreA + $scoreB;
        $ratioA = $total > 0 ? round($scoreA / $total * 100, 1) : 50;
        $ratioB = 100 - $ratioA;
        return [
            'team_a' => [
                'score'    => $scoreA,
                'share'    => $ratioA,   // 控制力占比 %
            ],
            'team_b' => [
                'score'    => $scoreB,
                'share'    => $ratioB,
            ],
            'advantage' => $scoreA > $scoreB ? 'team_a' : ($scoreA < $scoreB ? 'team_b' : 'draw'),
            'gap'       => round(abs($scoreA - $scoreB), 2),
            'breakdown' => $this->getBreakdown($teamA, $teamB, $benchmarks),
        ];
    }
    /**
     * 分项明细对比（用于雷达图）
     */
    private function getBreakdown(array $a, array $b, array $bms): array
    {
        return [
            '控球率'   => [$a['possession'], $b['possession']],
            '传球成功率'=> [$a['pass_accuracy'], $b['pass_accuracy']],
            '关键传球' => [$a['key_passes'], $b['key_passes']],
            '拦截'     => [$a['interceptions'], $b['interceptions']],
            '抢断'     => [$a['tackles'], $b['tackles']],
            '夺回球权' => [$a['recoveries'], $b['recoveries']],
        ];
    }
    /**
     * 归一化到 0~1
     */
    private function normalize(float $value, float $min, float $max): float
    {
        if ($max <= $min) return 0;
        $n = ($value - $min) / ($max - $min);
        return max(0, min(1, $n));
    }
}

调用示例

$analyzer = new MidfieldControlAnalyzer();
$teamA = [
    'possession'        => 58.5,
    'passes'            => 620,
    'pass_accuracy'     => 88.2,
    'forward_passes'    => 210,
    'key_passes'        => 12,
    'interceptions'     => 9,
    'tackles'           => 15,
    'recoveries'        => 42,
    'final_third_passes'=> 180,
];
$teamB = [
    'possession'        => 41.5,
    'passes'            => 430,
    'pass_accuracy'     => 81.0,
    'forward_passes'    => 120,
    'key_passes'        => 6,
    'interceptions'     => 14,
    'tackles'           => 22,
    'recoveries'        => 55,
    'final_third_passes'=> 95,
];
// 联赛基准值（可从数据库聚合历史数据得出）
$benchmarks = [
    'max_key_passes'   => 15,
    'max_interceptions'=> 20,
    'max_tackles'      => 28,
    'max_recoveries'   => 70,
];
$result = $analyzer->compare($teamA, $teamB, $benchmarks);
print_r($result);

输出示例：

team_a: score=72.4, share=56.3%
team_b: score=56.1, share=43.7%
advantage: team_a, gap: 16.3

可视化展示（前端）

控制力条（HTML/CSS）

<div class="control-bar">
  <div class="bar-a" style="width: <?= $result['team_a']['share'] ?>%">
    A队 <?= $result['team_a']['share'] ?>%
  </div>
  <div class="bar-b" style="width: <?= $result['team_b']['share'] ?>%">
    B队 <?= $result['team_b']['share'] ?>%
  </div>
</div>

雷达图（Chart.js）

new Chart(ctx, {
  type: 'radar',
  data: {
    labels: ['控球率','传球成功率','关键传球','拦截','抢断','夺回球权'],
    datasets: [
      { label: 'A队', data: [58.5,88.2,12,9,15,42], borderColor:'#e63946' },
      { label: 'B队', data: [41.5,81.0,6,14,22,55], borderColor:'#457b9d' }
    ]
  }
});

进阶优化建议

1. 基准动态化：$benchmarks 从联赛历史数据实时聚合，而非写死。

   $benchmarks = $pdo->query("SELECT MAX(key_passes) AS max_key_passes, 
       MAX(interceptions) AS max_interceptions FROM match_stats")->fetch();

2. 主客场加权：主队控球数据通常偏乐观，可加系数修正。

3. 时间演化趋势：按比赛分钟分段（0-15、16-30...）计算控制力，画折线图看"中场控制权转移"。

4. 球员级别贡献：midfield_players_stats 表按球员聚合，找出"谁在撑起中场"。

5. 数据来源对接：可用 API-Football、Football-Data.org 等接口抓取真实比赛数据，用 PHP Guzzle 定时同步。

6. 缓存：计算结果存 Redis/文件缓存，避免每次请求重复计算。

需要我把雷达图完整页面、API数据抓取脚本或按分钟分段控制力折线图再展开写吗？