98 lines
2.7 KiB
PHP
98 lines
2.7 KiB
PHP
<?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
|
|
));
|
|
?>
|