php项目统计落叶球射门成功率如何?

wen PHP项目 1

PHP项目统计"落叶球"射门成功率方案

落叶球(Knuckleball)是足球中一种特殊的射门方式,球在空中几乎不旋转、轨迹飘忽,下面给出一个完整的PHP实现思路。

php项目统计落叶球射门成功率如何?

数据模型设计

首先需要设计数据表结构,关键字段是射门类型和结果。

CREATE TABLE shots (
    id INT AUTO_INCREMENT PRIMARY KEY,
    player_id INT NOT NULL,
    match_id INT NOT NULL,
    shot_type ENUM('knuckleball','curve','power','chip','normal') NOT NULL,
    is_goal TINYINT(1) NOT NULL DEFAULT 0,   -- 是否进球
    is_on_target TINYINT(1) DEFAULT 0,        -- 是否射正
    distance DECIMAL(5,2),                    -- 射门距离(米)
    minute INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_type (shot_type),
    INDEX idx_player (player_id)
);

核心统计逻辑

基础成功率统计(SQL)

<?php
class ShotStatistics
{
    private PDO $pdo;
    public function __construct(PDO $pdo)
    {
        $this->pdo = $pdo;
    }
    /**
     * 统计指定射门类型的成功率
     * 成功率 = 进球数 / 射门总数 * 100%
     */
    public function successRate(string $shotType): array
    {
        $sql = "SELECT 
                    COUNT(*) AS total_shots,
                    SUM(is_goal) AS goals,
                    SUM(is_on_target) AS on_target,
                    ROUND(SUM(is_goal) / COUNT(*) * 100, 2) AS goal_rate,
                    ROUND(SUM(is_on_target) / COUNT(*) * 100, 2) AS on_target_rate
                FROM shots
                WHERE shot_type = :type";
        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([':type' => $shotType]);
        return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
    }
}

计算要点:

  • 成功率分母必须是该类型射门总次数,不能只算射正次数
  • 使用 ROUND(..., 2) 保留两位小数
  • SUM(is_goal) 因为字段是 0/1,直接求和即进球数

分类对比统计

public function compareAllTypes(): array
{
    $sql = "SELECT 
                shot_type,
                COUNT(*) AS total,
                SUM(is_goal) AS goals,
                ROUND(SUM(is_goal)/COUNT(*)*100, 2) AS rate
            FROM shots
            GROUP BY shot_type
            ORDER BY rate DESC";
    return $this->pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}

按球员统计落叶球成功率

public function playerKnuckleballStats(int $playerId): array
{
    $sql = "SELECT 
                p.name,
                COUNT(s.id) AS total,
                SUM(s.is_goal) AS goals,
                CASE WHEN COUNT(s.id) = 0 THEN 0
                     ELSE ROUND(SUM(s.is_goal)/COUNT(s.id)*100, 2)
                END AS rate
            FROM players p
            LEFT JOIN shots s 
                ON s.player_id = p.id AND s.shot_type = 'knuckleball'
            WHERE p.id = :pid
            GROUP BY p.id";
    $stmt = $this->pdo->prepare($sql);
    $stmt->execute([':pid' => $playerId]);
    return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
}

关键陷阱与处理

问题 处理方式
除以零 用 CASE WHEN COUNT(*)=0 THEN 0,或 PHP 层判断 $total > 0
样本量太小 低于 10 次射门不建议展示胜率,加阈值过滤 HAVING total >= 10
射正 vs 进球定义 明确"成功"定义:进球率 / 射正率,二者分开统计
数据一致性 进球数不要超过射门数,可加约束或定期校验
NULL 值 is_goal 建议 NOT NULL DEFAULT 0

防止小样本误导

public function reliableRate(string $type, int $minShots = 10): ?float
{
    $stats = $this->successRate($type);
    if (($stats['total_shots'] ?? 0) < $minShots) {
        return null; // 样本不足,前端显示"数据不足"
    }
    return (float) $stats['goal_rate'];
}

进阶:按距离区间细分

落叶球成功率与距离强相关,可分段统计:

public function knuckleballByDistance(): array
{
    $sql = "SELECT 
                CASE 
                    WHEN distance < 20 THEN '禁区外远射'
                    WHEN distance < 30 THEN '中距离'
                    ELSE '超远距离'
                END AS range_label,
                COUNT(*) AS total,
                SUM(is_goal) AS goals,
                ROUND(SUM(is_goal)/COUNT(*)*100, 2) AS rate
            FROM shots
            WHERE shot_type = 'knuckleball' AND distance IS NOT NULL
            GROUP BY range_label";
    return $this->pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
}

输出示例

$stats = new ShotStatistics($pdo);
print_r($stats->successRate('knuckleball'));

输出:

Array (
    [total_shots] => 120
    [goals] => 18
    [on_target] => 45
    [goal_rate] => 15.00
    [on_target_rate] => 37.50
)

核心公式是 落叶球成功率 = 落叶球进球数 / 落叶球总射门数 × 100%,实现重点在于:正确区分射门类型、处理除零、设置样本量阈值、区分"进球率"和"射正率"两种成功定义,如需进一步扩展,可按赛季、主客场、对手强度等维度做分层统计。

需要我补充某一部分(如前端图表展示、数据导入脚本、或 API 接口设计)吗?

抱歉,评论功能暂时关闭!

友情链接攻略窝 · 礼包窝 · 配置窝 · 换算窝 · 算法窝 · 查文窝 · 手册窝 · 问答窝 · 全文搜 · 手册库
相关站点礼包窝 · 查文窝