"; while($row_result = pg_fetch_array($result)) { $proses_sekretariat=$row_result['proses_sekretariat']; $urut=$row_result[9]; if ($urut==1) {} else { $patrap=$row_result['proses_sekretariat']; $m=explode("^", $patrap); $parap=$m[0]; $dari=$m[1]; if (isset($dari)) { $teko=pg_query("SELECT j.nama FROM jabatan_pegawai j WHERE j.id='$dari'"); while($oket=pg_fetch_array($teko)) {$sopo=$oket[0];} } if ($i > 1 && $i % 10 == 0) echo ''; else if ($i) echo ''; ++$i; // echo the tds and their data. echo ""; echo ""; $g=2; $sub=pg_query("SELECT (SELECT j.nama FROM jabatan_pegawai j WHERE j.id=k.kepada) FROM kirim k INNER JOIN surat s ON (k.surat_id=s.id) WHERE k.surat_id='$surat_id' AND k.kepada IS NOT NULL AND LEFT(k.isi,1)='#' AND proses_sekretariat='$proses_sekretariat' ORDER BY k.id ASC "); if(pg_num_rows($sub) > 0) { echo ""; } else { echo ""; } echo ""; echo ""; echo ""; $no++; } } echo ''; ?>

No	Tgl	Kepada	Isi Disposisi	Dari	Paraf
"; echo $no.'.'; echo "	"; echo date('d-m-Y H:i',strtotime($row_result[0])); echo "	"; echo '1 - '.$row_result[2]; while($h=pg_fetch_array($sub)) { echo ' '.$g.' - '.$h[0]; $g++; } echo "	"; echo $row_result[2]; echo "	"; echo str_replace("#","",$row_result['isi']); echo "	"; echo $sopo; echo "	"; if ((empty($parap)) || ($parap=="") || ($parap==null)) { echo ""; } else { echo ""; } echo "