"Januari", 2=>"Februari", 3=>"Maret", 4=>"April", 5=>"Mei", 6=>"Juni", 7=>"Juli", 8=>"Agustus", 9=>"September", 10=>"Oktober", 11=>"November", 12=>"Desember" ]; // Ambil bulan & tahun dari filter $bulan = isset($_GET['bulan']) && $_GET['bulan'] !== "" ? (int)$_GET['bulan'] : null; $tahun = isset($_GET['tahun']) && $_GET['tahun'] !== "" ? (int)$_GET['tahun'] : null; $hasFilter = $bulan !== null && $tahun !== null; // Ambil range tahun otomatis dari database $sqlYear = "SELECT MIN(YEAR(report_date)) as minYear, MAX(YEAR(report_date)) as maxYear FROM daily_report"; $resYear = $conn->query($sqlYear); $minYear = date("Y")-3; $maxYear = date("Y")+1; if($resYear && $rowYear = $resYear->fetch_assoc()){ if($rowYear['minYear']) $minYear = $rowYear['minYear']; if($rowYear['maxYear']) $maxYear = $rowYear['maxYear']; } // Default data $stat = ["total_driver"=>0,"total_kendaraan"=>0,"total_data"=>0]; $lokasi = $totalMH = $totalPerson = $totalKM = $totalUnit = []; if($hasFilter){ // Statistik $sqlStat = "SELECT SUM(personil) AS total_driver, COUNT(DISTINCT unit_id) AS total_kendaraan, COUNT(*) AS total_data FROM daily_report WHERE MONTH(report_date)='$bulan' AND YEAR(report_date)='$tahun'"; $resStat = $conn->query($sqlStat); if($resStat) $stat = $resStat->fetch_assoc(); // Data chart $sql = "SELECT lokasi, SUM(man_hour) as total_mh, SUM(personil) as total_person, SUM(km_driven) as total_km, COUNT(DISTINCT unit_id) as total_unit FROM daily_report WHERE MONTH(report_date)='$bulan' AND YEAR(report_date)='$tahun' GROUP BY lokasi"; $result = $conn->query($sql); while($row = $result->fetch_assoc()){ $lokasi[] = $row['lokasi']; $totalMH[] = $row['total_mh']; $totalPerson[] = $row['total_person']; $totalKM[] = $row['total_km']; $totalUnit[] = $row['total_unit']; } } ?> <?= $title ?>

📊 Dashboard Monitoring KM & HM

Sistem pengelolaan data aktivitas kendaraan PT Mobilkom

📈
👤
Driver
🚗
Kendaraan
📊
Data