<?php
include("app/koneksi.php");

// Hitung jumlah pelatihan yang belum diverifikasi
$query_count_pelatihan = pg_query("
    SELECT COUNT(*) AS total
    FROM riwayat_pel i
    WHERE i.id IS NOT NULL
      AND i.tgl_verifikasi IS NULL
      AND i.status IS NULL
");

$row_pelatihan = pg_fetch_assoc($query_count_pelatihan);
$count_pelatihan = $row_pelatihan['total'];

// Hitung jumlah SPO yang belum diverifikasi
$query_count_spo = pg_query(" 
    SELECT COUNT(*) AS total
    FROM riwayat_spo i
    WHERE i.id IS NOT NULL
      AND i.tgl_verifikasi IS NULL
      AND i.status IS NULL
");

$row_spo = pg_fetch_assoc($query_count_spo);
$count_spo = $row_spo['total'];

// Hitung jumlah Fellowship yang belum diverifikasi
$query_count_fellowship = pg_query(" 
  SELECT COUNT(*) AS total
  FROM riwayat_ship i
  WHERE i.id IS NOT NULL
    AND i.tgl_verifikasi IS NULL
    AND i.status IS NULL
");

$row_fellowship = pg_fetch_assoc($query_count_fellowship);
$count_fellowship = $row_fellowship['total'];

// Hitung jumlah Ijin Belajar yang belum diverifikasi
$query_count_ijin_belajar = pg_query(" 
  SELECT COUNT(*) AS total
  FROM riwayat_ibel i
  WHERE i.id IS NOT NULL
    AND i.tgl_verifikasi IS NULL
    AND i.status IS NULL
");

$row_ijin_belajar = pg_fetch_assoc($query_count_ijin_belajar);
$count_ijin_belajar = $row_ijin_belajar['total'];

// Hitung jumlah Tugas Belajar yang belum diverifikasi
$query_count_tugas_belajar = pg_query(" 
  SELECT COUNT(*) AS total
  FROM riwayat_tbel i
  WHERE i.id IS NOT NULL
    AND i.tgl_verifikasi IS NULL
    AND i.status IS NULL
");

$row_tugas_belajar = pg_fetch_assoc($query_count_tugas_belajar);
$count_tugas_belajar = $row_tugas_belajar['total'];

// Hitung jumlah Keterangan Ijin Belajar yang belum diverifikasi
$query_count_ket_ijin_belajar = pg_query(" 
  SELECT COUNT(*) AS total
  FROM riwayat_kbel i
  WHERE i.id IS NOT NULL
    AND i.tgl_verifikasi IS NULL
    AND i.status IS NULL
");

$row_ket_ijin_belajar = pg_fetch_assoc($query_count_ket_ijin_belajar);
$count_ket_ijin_belajar = $row_ket_ijin_belajar['total'];

// Hitung jumlah Pencantuman Gelar yang belum diverifikasi
$query_count_pencantuman_gelar = pg_query(" 
  SELECT COUNT(*) AS total
  FROM riwayat_jbel i
  WHERE i.id IS NOT NULL
    AND i.tgl_verifikasi IS NULL
    AND i.status IS NULL
");

$row_pencantuman_gelar = pg_fetch_assoc($query_count_pencantuman_gelar);
$count_pencantuman_gelar = $row_pencantuman_gelar['total'];

echo json_encode(array(
    'count_pelatihan' => $count_pelatihan,
  'count_spo' => $count_spo,
  'count_fellowship' => $count_fellowship,
  'count_ijin_belajar' => $count_ijin_belajar,
  'count_tugas_belajar' => $count_tugas_belajar,
  'count_ket_ijin_belajar' => $count_ket_ijin_belajar,
  'count_pencantuman_gelar' => $count_pencantuman_gelar
    ));
?>