<?php
class TeamDashboard
{

    private $db;

    function __construct($db)
    {
        $this->db = $db;
    }

    function completedJobcards($team_id)
    {
        $res = $this->db->query(
            "jobcards",
            "SELECT COUNT(*) AS total 
             FROM jobcards 
             WHERE status = 1 AND team_assigned_id = '$team_id'"
        );
        return $res->fetch_assoc()['total'];
    }

    function metersByType($team_id, $type)
    {
        $users_res = $this->db->query(
            "users",
            "SELECT record_id FROM users WHERE team_id='$team_id'"
        );

        $user_ids = [];
        while ($u = $users_res->fetch_assoc()) {
            $user_ids[] = $u['record_id'];
        }

        if (empty($user_ids)) return 0;

        $user_ids_sql = implode(",", $user_ids);

        $res = $this->db->query(
            "jobcard_timeline",
            "SELECT SUM(meters) AS total
            FROM jobcard_timeline
            WHERE user_id IN ($user_ids_sql)
            AND type LIKE '$type%'"  // ✅ matches RIEMING_START, RIEMING_STOP, RIEMING_PAUSE etc.
        );

        return $res->fetch_assoc()['total'] ?? 0;
    }
}