37 lines
1.7 KiB
PHP
37 lines
1.7 KiB
PHP
<?php
|
|
$satker=$_POST['satker'];
|
|
?>
|
|
|
|
<li>
|
|
<a href="#" id="un_satker"><i class="mdi mdi-email-outline"></i>Undangan
|
|
|
|
<?php
|
|
include('../koneksi.php');
|
|
/*
|
|
$data = pg_query("SELECT p.id
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (k.id=p.riwayat_kegiatan_id)
|
|
WHERE k.st_persiapan='Ready' AND p.st_terima IS NULL
|
|
AND
|
|
(SELECT d.satuan_kerja FROM data_pegawai d WHERE d.id=p.data_pegawai_id)='$satker'
|
|
AND k.st_batal IS NULL");
|
|
$j=pg_num_rows($data);
|
|
*/
|
|
|
|
$data = pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND p.st_terima IS NULL AND k.st_batal IS NULL");
|
|
while($r=pg_fetch_array($data)) {$j=$r[0];}
|
|
|
|
if ($j==0) {} else {
|
|
?>
|
|
<span class="badge up bg-danger" style="margin-top:-1px" id="bg_notif"><?php echo $j; ?></span>
|
|
<?php
|
|
}
|
|
?>
|
|
</a>
|
|
</li>
|