0) {} else {
$r=pg_query("SELECT tenaga_id,tenaga2_id FROM data_pegawai WHERE id='$selected'");
while($rr=pg_fetch_array($r)) {$tenaga_id=$rr[0];$tenaga2_id=$rr[1];}
$ins_peserta = pg_query("INSERT into riwayat_peserta (
riwayat_kegiatan_id,
data_pegawai_id,
sebagai_id,
status,
tanggal_reg,
satuan_kerja_id,
tenaga_id,
tenaga2_id
) values(
'$riwayat_kegiatan_id',
'$selected',
'1',
'Pending',
NOW(),
'$satuan_kerja_id',
'$tenaga_id',
'$tenaga2_id'
)
");
}
}
} else
if ($key=='delete_peserta') {
$id=$_POST['id'];
$del=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
} else
if ($key=='cek_quota') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$str=$_POST['str'];
$e=pg_query("SELECT DATE_PART('day', NOW()::timestamp - jatuh_tempo_reg::timestamp) FROM riwayat_kegiatan WHERE id='$riwayat_kegiatan_id'");
while($re=pg_fetch_array($e)) {$jhari=$re[0];}
$c=pg_query("SELECT DISTINCT tenaga_id,(SELECT nama FROM tenaga WHERE id=tenaga_id) FROM bidang WHERE satuan_kerja_id='$satuan_kerja_id'");
while(($rc=pg_fetch_array($c)) !== FALSE) {$n=$rc[1];
if ($rc[0]=='1') {
$j=pg_query("SELECT COALESCE(quota1,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_medis=$rj[0];}
if ($q_medis==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=1");
while($rk=pg_fetch_array($k)) {$tot_quo1=$rk[0];}
echo '';
}
} else
if ($rc[0]==2) {
$j=pg_query("SELECT COALESCE(quota2,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_nmedis=$rj[0];}
if ($q_nmedis==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=2");
while($rk=pg_fetch_array($k)) {$tot_quo2=$rk[0];}
echo '';
}
} else
if ($rc[0]==3) {
$j=pg_query("SELECT COALESCE(quota3,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_perawatan=$rj[0];}
if ($q_perawatan==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=3");
while($rk=pg_fetch_array($k)) {$tot_quo3=$rk[0];}
echo '
';
}
} else
if ($rc[0]==4) {
$j=pg_query("SELECT COALESCE(quota4,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_nperawatan=$rj[0];}
if ($q_nperawatan==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=4");
while($rk=pg_fetch_array($k)) {$tot_quo4=$rk[0];}
echo '';
}
} else
if ($rc[0]==5) {
$j=pg_query("SELECT COALESCE(quota5,0) FROM riwayat_quota WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str'");
while($rj=pg_fetch_array($j)) {$q_pekarya=$rj[0];}
if ($q_pekarya==0) {} else {
$k=pg_query("SELECT COALESCE(COUNT(*),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id' AND satuan_kerja_id='$str' AND tenaga_id=5");
while($rk=pg_fetch_array($k)) {$tot_quo5=$rk[0];}
echo '
';
}
}
}
} else
if ($key=='cek_vmentor') {
$id=$_POST['id'];
$upd=pg_query("UPDATE riwayat_peserta SET status_mentor='Ready' WHERE id='$id'");
} else
if ($key=='ditolak_vmentor') {
$id=$_POST['id'];
$upd=pg_query("UPDATE riwayat_peserta SET status_mentor='Ditolak' WHERE id='$id'");
} else
if ($key=='batal_vmentor') {
$id=$_POST['id'];
$upd=pg_query("UPDATE riwayat_peserta SET status_mentor='Pending' WHERE id='$id'");
}
?>