Example #1
0
  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 = "&nbsp;";
  $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 */
Example #2
0
  <?
/* 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&nbsp;</td>
    <td>$unit_kerja</td>
	 <td>$barea</td>
	  <td>$parea</td>
    <td align=left>$tgl_jabat</td>