include_once "../sisfokampus1.php"; HeaderSisfoKampus("Cari Dosen"); // *** Parameters *** $ProdiID = GetSetVar('ProdiID'); $frm = GetSetVar('frm'); $div = GetSetVar('div'); $Nama = GetSetVar('Nama'); $indexKompre = GetSetVar('indexKompre') + 0; // cek Nama Dosen dulu if (empty($Nama)) { die(ErrorMsg('Error', "Masukkan terlebih dahulu Nama Dosen sebagai kata kunci pencarian.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n Opsi: <a href='#' onClick=\"javascript:toggleBox('{$div}', 0)\">Tutup</a>")); } $prd = GetaField('prodi', "KodeID='" . KodeID . "' and ProdiID", $ProdiID, 'Nama'); // *** Main *** TampilkanJudul("Cari Dosen - {$prd} <sup>({$ProdiID})</sup><br /><font size=-1><a href='#' onClick=\"toggleBox('{$div}', 0)\">(× Close ×)</a></font>"); TampilkanDaftar(); // *** Functions *** function TampilkanDaftar() { //echo $ProdiID; $s = "select d.Login, d.Nama, d.Gelar, d.NA\r\n from dosen d\r\n where d.KodeID = '" . KodeID . "'\r\n and d.Nama like '%{$_SESSION['Nama']}%'\r\n and INSTR(d.ProdiID, '{$_SESSION['ProdiID']}') > 0\r\n order by d.Nama"; $r = _query($s); $i = 0; echo "<table class=bsc cellspacing=1 width=100%>"; echo "<tr>\r\n <th class=ttl>#</th>\r\n <th class=ttl>Kode/NIP</th>\r\n <th class=ttl>Nama Dosen</th>\r\n <th class=ttl>NA</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $i++; if ($w['NA'] == 'Y') { $c = "class=nac"; $d = "{$w['Nama']} <sup>{$w['Gelar']}</sup>"; } else {
// Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 10 Sept 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Cari Jadwal"); // *** Parameters *** $JadwalID = $_REQUEST['JadwalID']; $ProdiID = $_REQUEST['ProdiID']; $frm = GetSetVar('frm'); $div = GetSetVar('div'); $prd = GetaField('prodi', "KodeID='" . KodeID . "' and ProdiID", $ProdiID, 'Nama'); // *** Main *** TampilkanJudul("Cari Jadwal - {$prd} <sup>({$ProdiID})</sup><br /><font size=-1><a href='#' onClick=\"toggleBox('{$div}', 0)\">(× Close ×)</a></font>"); TampilkanDaftar($JadwalID, $ProdiID); // *** Functions *** function TampilkanDaftar($JadwalID, $ProdiID) { $jdwl = GetFields('jadwal', 'JadwalID', $JadwalID, '*'); $s = "select j.*,\r\n left(j.JamMulai, 5) as _JM, left(j.JamSelesai, 5) as _JS,\r\n h.Nama as HR, d.Nama as DSN, d.Gelar\r\n from jadwal j\r\n left outer join hari h on h.HariID = j.HariID\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n where j.NA = 'N'\r\n and j.JadwalID <> {$JadwalID}\r\n and j.ProdiID = '{$jdwl['ProdiID']}'\r\n order by j.HariID, j.JamMulai, j.JamSelesai"; $r = _query($s); $n = 0; $hari = ';alksdfj;asdf'; echo "<table class=bsc cellspacing=1 width=100%>"; echo "<tr>\r\n <th class=ttl width=20>#</th>\r\n <th class=ttl>Jam</th>\r\n <th class=ttl>Kode</th>\r\n <th class=ttl>Matakulah</th>\r\n <th class=ttl>Kelas<hr size=1 color=white>Peserta</th>\r\n <th class=ttl>Dosen</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $n++; if ($hari != $w['HariID']) { $hari = $w['HariID']; echo "<tr>\r\n <td class=ul colspan=10>\r\n <font size=+1>{$w['HR']}</font>\r\n </td>\r\n </tr>";