35 lines
2.1 KiB
PHP
35 lines
2.1 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$id=$_POST['id'];
|
|
$satker_pemilik_surat=$_POST['satker_pemilik_surat'];
|
|
$jabatan_pegawai_id=$_POST['jabatan_pegawai_id'];
|
|
?>
|
|
|
|
<table style="color:black;font-family:Inter;font-size:14px" border=0>
|
|
<?php
|
|
$d21=pg_query("SELECT
|
|
(SELECT j.nama FROM jabatan_pegawai j WHERE j.id=k.kepada),k.isi,k.kepada
|
|
FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id)
|
|
LEFT OUTER JOIN teruskan t ON (k.id=t.kirim_id_untuk)
|
|
WHERE k.kepada IS NOT NULL AND k.surat_id=$id AND t.jabatan_dari IS NULL AND
|
|
k.satuan_kerja_penginput=$satker_pemilik_surat
|
|
ORDER BY k.id ASC
|
|
");
|
|
while($rd21=pg_fetch_array($d21)) {
|
|
$isi=$rd21['isi'];
|
|
$kpds=$rd21['kepada'];
|
|
?>
|
|
<tr
|
|
<?php if ($kpds==$jabatan_pegawai_id) {?>style="font-family:InterSB;" <?php } else {} ?>
|
|
>
|
|
<td width="20"><i class="mdi mdi-apps m-r-5"></i></td><td>
|
|
<?php
|
|
echo 'Kepada '.$rd21[0];
|
|
if ($isi=='SM') {} else {echo '<span style="color:red"><i class="mdi mdi-map-marker m-l-5"></i></span>';}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
}
|
|
?>
|
|
</table>
|