if(!file_exists($foto)) $foto = $fotodir.$nipeg.".gif";*/ /* cari data keluarga */ $sql1 = "select hubungan, nama, kelamin from $tbl_bio10 where nipeg='$nipeg' and (hubungan=1 or tunjangan=1) and (stat_sipil < 4) order by no_urut"; $q1 = mysql_query($sql1); $datakeluarga = ""; while(list($hubungan, $namakeluarga, $kelamin) = mysql_fetch_row($q1)) { if($hubungan == 1) { if($kelamin == 1) $datakeluarga = "Suami : ".$namakeluarga; if($kelamin == 2) $datakeluarga = "Istri : ".$namakeluarga; } else $datakeluarga .= "<br>Anak : ".$namakeluarga; } if(!$datakeluarga) $datakeluarga = " "; $posisi = sebutposisi ($kd_posisi); print " <tr bgcolor=$warna> <td valign=top><font size=1>$nama </font></td> <td align=center valign=top><font size=2> <a href=cek-pegawai.php?session=$session&nipeg=$nipeg&pos=$kd_posisi>$nipeg</a> </font> </td> <td valign=top><font size=1>$jabatan </font></td> <td align=left valign=top><font size=1>$posisi </font></td> <td valign=top><font size=1>$alamat </font></td> <td valign=top><font size=1>$gol_darah </font></td> <td valign=top><font size=1>$datakeluarga </font></td> "; /* trap nama file foto pegawai */
<? /* riwayat jabatan */ $urut = 1; $sql1 = "select jabatan, kd_unit, unit_kerja, barea, parea ,tgl_jabat, tgl_akhir,grade_sk from $tbl_bio03 where nipeg='$nipeg' order by tgl_jabat ASC"; $q1 = mysql_query($sql1); while(list($jabatan, $kd_unit, $unit_kerja, $barea, $parea, $tgl_jabat, $tgl_akhir, $grade_sk, $no_sk) = mysql_fetch_row($q1)) { /* rapihkan tampilan */ $tgl_jabat = tgl2ind($tgl_jabat); $tgl_akhir = tgl2ind($tgl_akhir); //if (strlen($kd_unit) >= 5) //if (substr($kd_unit,4,1) = '0') // $kd_unit = substr($kd_unit,0,3); //else $kd_unit = substr($kd_unit,0,3); $posisi2 = sebutposisi($kd_unit); /*$peringkat = ($peringkat == 0) ? "" : $peringkat; */ /* $sql2 = "select posisi from $tbl_posisi where kode = rtrim('$kd_unit')"; $q2 = mysql_query($sql2); list($posisi) = mysql_fetch_row($q2); */ print " <tr bgcolor= white> <td align=left>$urut</td> <td>$jabatan </td> <td>$unit_kerja</td> <td>$barea</td> <td>$parea</td> <td align=left>$tgl_jabat</td>