Esempio n. 1
0
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)\">(&times; Close &times;)</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 {
Esempio n. 2
0
// 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)\">(&times; Close &times;)</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>";