<td align=left><span class="style9 style2">Sebutan Profesi 2</span></td>
<td align=left><span class="style9 style2">Sejak</span></td>
<td align=left><span class="style9 style2">Hingga</span></td>
</tr>
<?
/* Data Riwayat Profesi 2 */
$urut = 1;
$sql1 = "select no_urut, nm_profesi, sb_profesi, tgl_mulai, tgl_akhir
from $tbl_profesi where nipeg='$nipeg' and jenis='2' order by tgl_mulai ASC";
$q1 = mysql_query($sql1);
while(list($no_urut, $nm_profesi, $sb_profesi, $tgl_mulai, $tgl_akhir) = mysql_fetch_row($q1)) {
$tgl_mulai = tgl2ind($tgl_mulai);
$tgl_akhir = tgl2ind($tgl_akhir);
print "
<tr bgcolor= white>
<td align=left>$no_urut</td>
<td>$nm_profesi</td>
<td>$sb_profesi</td>
<td align=left>$tgl_mulai</td>
<td align=left>$tgl_akhir</td>
</tr>
";
$urut++;
}
?>
</table>
</tr>
";
/* dozir */
$urut = 1;
if($urut%2) $warna = 'LIGHTGREY' ;
else $warna = 'WHITE';
$sql1 = "select keterangan, no_sk, namafile, tgl_sk,time,id
from $tbl_dozir where nipeg='$nipeg1'&& id_dozir='$id_dozir' order by tgl_SK ASC" ;
$q1 = mysql_query($sql1);
while(list($keterangan, $no_sk, $namafile, $tgl_sk,$time,$id) = mysql_fetch_row($q1)) {
$sql2 = "select nama_dozir from jenis_dozir where id_dozir='$id_dozir'";
$q2 = mysql_query($sql2);
list($nama_dozir) = mysql_fetch_row($q2);
$tgl_sk = tgl2ind($tgl_sk);
print "
<tr bgcolor= $warna>
<td align=left valign=top>$urut</td>
<td align=left valign=top>$nama_dozir</td>
<td align=left valign=top>$keterangan</td>
<td align=left valign=top>$no_sk</td>
<td align=left valign=top>$tgl_sk</td>
<td align=left valign=top>$namafile</td>
<td valign =top>
<a href='carinama2.php?session=$session && namafile=".$namafile." && nip = ".$nipeg." && time=".$time." && id_dozir=".$id_dozir." && no_sk=".$no_sk." && keterangan=".$keterangan." && id=".$id."'>Edit</a>
<a href='hapus.php?session=$session && namafile=".$namafile." && nip = ".$nipeg." && time=".$time." '>Delete</a>
</td>
</tr>
$tgl_sekarang = date("Y-m-d");
$tgl_sekarang=substr($tgl_sekarang,5);
$urut = 1;
$sql1 = "select nipeg,nama, jabatan,tgl_lahir
from $tbl_bio01 ";
$q1 = mysql_query($sql1);
while(list($nipeg,$nama, $jabatan, $tgl_lahir) = mysql_fetch_row($q1)) {
if($urut%2) $warna = "LIGHTGREY" ;
else $warna = "WHITE";
$tgl_lahir= substr($tgl_lahir,5);
if ($tgl_lahir == $tgl_sekarang) {
$nipeg = trim($nipeg, " ");
$foto = $fotodir.$nipeg.".jpg";
/* rapihkan tampilan */
$tgl_lahir = tgl2ind($tgl_lahir);
print "
<tr bgcolor=$warna>
<td align=left valign=top>$urut</td>
<td align=left valign=top>$nama</td>
<td align=left valign=top>$jabatan</td>
";
/* trap nama file foto pegawai */
if(file_exists($foto)) print "
<td valign=top><img src=$foto width=50 height=70> </td>
";
else print "
<td align=center> </td>
";
