23 lines
967 B
PHP
23 lines
967 B
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$key2=$_POST['key2'];
|
|
if ($key2=='cek_status_und'){
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$str=$_POST['str'];
|
|
$d=pg_query("SELECT COUNT(DISTINCT status) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'
|
|
AND status IN ('Pending','',null) GROUP BY status");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
} else
|
|
if ($key2=='cek_status_spt'){
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$d=pg_query("SELECT COUNT(DISTINCT status) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'
|
|
AND status IN ('Pending','',null) GROUP BY status");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
} else
|
|
if ($key2=='cek_pending'){
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$d=pg_query("SELECT COUNT(status) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'
|
|
AND status IN ('Pending','',null)");
|
|
while($r=pg_fetch_array($d)) {echo $r[0];}
|
|
}
|
|
?>
|