function DftrAlumni()
{
TampilkanHeaderAlumni();
TampilkanFotoScript();
// setup where-statement
$whr = array();
$ord = '';
if ($_SESSION['srcmhswkey'] != 'Reset' && !empty($_SESSION['srcmhswkey']) && !empty($_SESSION['srcmhswval'])) {
$whr[] = "m.{$_SESSION['srcmhswkey']} like '%{$_SESSION['srcmhswval']}%' ";
$ord = "order by m.{$_SESSION['srcmhswkey']}";
}
if (!empty($_SESSION['prodi'])) {
$whr[] = "m.ProdiID='{$_SESSION['prodi']}'";
}
if (!empty($_SESSION['prid'])) {
$whr[] = "m.ProgramID='{$_SESSION['prid']}'";
}
if (!empty($whr)) {
$strwhr = "and " . implode(' and ', $whr);
}
$strwhr = str_replace('NPM', "MhswID", $strwhr);
$ord = str_replace('NPM', "MhswID", $ord);
// Tampilkan
include_once "class/dwolister.class.php";
$lst = new dwolister();
$lst->maxrow = 10;
$lst->page = $_SESSION['alumnipage'] + 0;
$lst->pageactive = "=PAGE=";
$lst->pages = "<a href='?mnux={$_SESSION['mnux']}&alumnipage==PAGE='>=PAGE=</a>";
$lst->tables = "alumni a\r\n left outer join mhsw m on m.MhswID = a.MhswID and m.KodeID = '" . KodeID . "'\r\n left outer join prodi prd on m.ProdiID=prd.ProdiID\r\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\r\n where a.KodeID = '" . KodeID . "'\r\n {$strwhr} {$ord}";
$lst->fields = "m.MhswID, m.Nama, m.StatusAwalID, m.StatusMhswID,\r\n m.Kelamin,\r\n m.Telepon, m.Handphone, m.Email, \r\n if (m.Foto is NULL or m.Foto = '', 'img/tux001.jpg', m.Foto) as _Foto,\r\n m.ProgramID, m.ProdiID, m.Alamat, m.Kota,\r\n prd.Nama as PRD, sm.Nama as SM, sm.Keluar";
$lst->headerfmt = "<p><table class=box cellspacing=1 cellpadding=4 width=700>\r\n <tr><th class=ttl>No.</th>\r\n <th class=ttl>NPM</th>\r\n <th class=ttl>Nama</th>\r\n <th class=ttl>Program Studi</th>\r\n <th class=ttl>Status</th>\r\n <th class=ttl>Telp/HP</th>\r\n </tr>";
$lst->footerfmt = "</table></p>";
$lst->detailfmt = "<tr>\r\n <td class=inp width=10><a name='=MhswID='>=NOMER=</a></td>\r\n <td class=cna=Keluar= width=100>\r\n <a href='?mnux={$_SESSION['mnux']}.edt&mhswbck={$_SESSION['mnux']}&gos=fnEdit&mhswid==MhswID='><img src='img/edit.png'>\r\n =MhswID=</a>\r\n <img src='img/=Kelamin=.bmp' align=right />\r\n </td>\r\n <td class=cna=Keluar= nowrap>\r\n <b>=Nama=</b>\r\n <a href='#' onClick=\"javascript:TampilkanFoto('=MhswID=', '=Nama=', '=_Foto=')\" title='=_Foto='>\r\n <img src='=_Foto=' width=30 align=right /></a>\r\n </td>\r\n <td class=cna=Keluar=>=ProgramID= \r\n <hr size=1 color=silver />\r\n =PRD= </td>\r\n <td class=cna=Keluar= width=60 align=center>=SM=</td>\r\n <td class=cna=Keluar=>=Telepon= \r\n <hr size=1 color=silver />\r\n =Handphone= </td>\r\n </tr>\r\n <tr><td bgcolor=silver colspan=6 height=1></td></tr>";
echo $lst->TampilkanData();
echo $ttl;
echo "<p>Hal.: " . $lst->TampilkanHalaman() . "<br />" . "Total: " . number_format($lst->MaxRowCount) . "</p>";
}
$k['KeluarKerja'] = date('Y-m-d');
$k['Alamat'] = '';
$k['Kota'] = '';
$k['KodePos'] = '';
$k['Propinsi'] = '';
$k['Negara'] = '';
$k['Telepon'] = '';
$k['Facsimile'] = '';
$k['Website'] = '';
$k['NA'] = 'N';
$jdl = "Tambah Pekerjaan Baru";
}
$MK = GetDateOption($k['MulaiKerja'], 'MK');
$KK = GetDateOption($k['KeluarKerja'], 'KK');
$na = $k['NA'] == 'Y' ? 'checked' : '';
// Tampilkan form
echo "<p><table class=box>\r\n <form action='?' method=POST>\r\n <input type=hidden name='mnux' value='alumni.det'>\r\n <input type=hidden name='AlumniID' value='{$a['MhswID']}'>\r\n <input type=hidden name='alumnisub' value='AlumniKrj'>\r\n <input type=hidden name='slnt' value='alumni.sav'>\r\n <input type=hidden name='slntx' value='AlumniKrjSav'>\r\n <input type=hidden name='AlumniKerjaID' value='{$k['AlumniKerjaID']}'>\r\n <input type=hidden name='md' value='{$md}'>\r\n \r\n <tr><th class=ttl colspan=2>{$jdl}</th></tr>\r\n <tr><td class=inp>Nama Perusahaan</td>\r\n <td class=ul><input type=text name='Nama' value='{$k['Nama']}' size=40 maxlength=50></td>\r\n </tr>\r\n <tr><td class=inp>Jabatan/Pekerjaan</td>\r\n <td class=ul><input type=text name='Jabatan' value='{$k['Jabatan']}' size=40 maxlength=50></td>\r\n </tr>\r\n <tr><td class=inp>Alamat Prsh</td>\r\n <td class=ul><textarea name='Alamat' cols=40 rows=3>{$k['Alamat']}</textarea></td>\r\n </tr>\r\n <tr><td class=inp>Kota</td>\r\n <td class=ul><input type=text name='Kota' value='{$k['Kota']}' size=20 maxlength=20></td>\r\n </tr>\r\n <tr><td class=inp>Kode Pos</td>\r\n <td class=ul><input type=text name='KodePos' value='{$k['KodePos']}' size=20 maxlength=20></td>\r\n </tr>\r\n <tr><td class=inp>Propinsi</td>\r\n <td class=ul><input type=text name='Propinsi' value='{$k['Propinsi']}' size=20 maxlength=50></td>\r\n </tr>\r\n <tr><td class=inp>Negara</td>\r\n <td class=ul><input type=text name='Negara' value='{$k['Negara']}' size=20 maxlength=30></td>\r\n </tr>\r\n <tr><td class=inp>Telepon</td>\r\n <td class=ul><input type=text name='Telepon' value='{$k['Telepon']}' size=40 maxlength=40></td></tr>\r\n <tr><td class=inp>Facsimile</td>\r\n <td class=ul><input type=text name='Facsimile' value='{$k['Facsimile']}' size=40 maxlength=40></td></tr>\r\n <tr><td class=inp>Website</td>\r\n <td class=ul><input type=text name='Website' value='{$k['Website']}' size=40 maxlength=50></td></tr>\r\n \r\n <tr><td class=inp>Mulai Kerja</td>\r\n <td class=ul>{$MK}</td></tr>\r\n <tr><td class=inp>Keluar Kerja</td>\r\n <td class=ul>{$KK}</td></tr>\r\n <tr><td class=inp>Sudah keluar?</td>\r\n <td class=ul><input type=checkbox name='NA' value='Y' {$na}></td></tr>\r\n <tr><td class=ul colspan=2><input type=submit name='Simpan' value='Simpan'>\r\n <input type=reset name='Reset' value='Reset'>\r\n <input type=button name='Batal' value='Batal' onClick=\"location='?mnux=alumni.det&alumnisub=AlumniKrj'\">\r\n </td></tr>\r\n </form>\r\n </table></p>";
}
// *** Parameters ***
$AlumniID = GetSetVar('AlumniID');
$AlumniSUB = GetSetVar('alumnisub', 'AlumniEdt');
// *** Main ***
TampilkanJudul("Detail Alumni");
$alumni = GetFields("mhsw m\r\n left outer join program prg on m.ProgramID=prg.ProgramID\r\n left outer join prodi prd on m.ProdiID=prd.ProdiID", "m.MhswID", $AlumniID, "m.*, prg.Nama as PRG, prd.Nama as PRD");
if (!empty($alumni)) {
TampilkanMenuAlumni();
TampilkanHeaderAlumni($alumni);
$AlumniSUB($alumni);
} else {
echo ErrorMsg("Data Tidak Ditemukan", "Data alumni tidak ditemukan. Hubungi bagian BAA atau SIM untuk informasi lebih lanjut");
}
