示例#1
0
function KoreksiKelas()
{
    $jid = $_REQUEST['jid'];
    $jdwl = GetFields("jadwal j \r\n    left outer join dosen d on j.DosenID=d.Login\r\n    left outer join hari h on j.HariID=h.HariID", "j.JadwalID", $jid, "j.*, h.Nama as HR, concat(d.Nama, ', ', d.Gelar) as DSN,\r\n    time_format(j.JamMulai, '%H:%i') as JM,\r\n    time_format(j.JamSelesai, '%H:%i') as JS");
    TampilkanHeaderKoreksiKelas($jdwl);
    TampilkanDaftarMhsw($jdwl);
}
示例#2
0
function DaftarMhsw()
{
    if ($_SESSION['angk'] == '' || $_SESSION['prodi'] == '') {
        echo Konfirmasi("Masukkan Parameter", "Anda harus memasukkan Angkatan & Program Studi terlebih dulu.<br />\r\n      Setelah itu Anda dapat mengeset Dosen Penasehatnya.\r\n      <hr size=1 color=silver />\r\n      Hubungi Sysadmin untuk informasi lebih lanjut.");
    } else {
        TampilkanDaftarMhsw();
    }
}
示例#3
0
function TampilkanDaftarMhsw1()
{
    TampilkanDaftarMhsw('?mnux=klinik.history&MhswID==MhswID=&gos=DetailHistory');
}
    $_jj = empty($_SESSION['jenjad']) ? '' : "and j.JenisJadwalID='{$_SESSION['jenjad']}' ";
    $_SESSION['Kelas'] = strtoupper($_SESSION['Kelas']);
    $stemp = "select m.Nama as NamaM,krs.Mhswid as IDM, m.TempatLahir, m.TanggalLahir, ag.Nama \r\n    from krs as krs \r\n\t\t\tleft outer join mhsw m on m.MhswID = krs.MhswID\r\n\t\t\tleft outer join jadwal j on j.JadwalID = krs.JadwalID\r\n\t\t\tleft outer join agama ag on m.Agama = ag.Agama\r\n        where \r\n\t\tkrs.MKKode = '{$_SESSION['KodeMK']}' \r\n\t\tand j.NamaKelas = '{$_SESSION['Kelas']}'\r\n\t\tand krs.NA = 'N'\r\n\t\t{$_jj}\r\n\t\torder by krs.Mhswid";
    $s = "Select m.Nama as NamaM,krs.Mhswid as IDM, m.TempatLahir, m.TanggalLahir, ag.Nama  \r\n    from krstemp as krs \r\n\t\t\tleft outer join mhsw m on m.MhswID = krs.MhswID\r\n\t\t\tleft outer join jadwal j on j.JadwalID = krs.JadwalID\r\n\t\t\tleft outer join agama ag on m.Agama = ag.Agama\r\n        where \r\n\t\tkrs.MKKode = '{$_SESSION['KodeMK']}' \r\n\t\tand j.NamaKelas = '{$_SESSION['Kelas']}'\r\n\t\tand krs.NA = 'N'\r\n\t\t{$_jj}\r\n\t\torder by krs.Mhswid";
    $w = _query($stemp);
    $cek = _num_rows($w);
    if (empty($cek)) {
        $w = _query($s);
    }
    $NamaMK = GetaField('mk', 'MKKode', $_SESSION['KodeMK'], "Nama");
    $JenisJadwalnya = GetaField('jenisjadwal', 'JenisJadwalID', $_SESSION['jenjad'], 'Nama');
    $n = 0;
    echo "<p><table class=box><tr><td>Mata Kuliah</td><td>:</td><td><b>{$NamaMK}</b></td></tr>";
    echo "<tr><td>Kelas/Seksi</td><td>:</td><td><b>{$_SESSION['Kelas']}</b></td></tr>";
    echo "<tr><td>Jenis</td><td>:</td><td><b>{$JenisJadwalnya}</b></td></tr></table></p>";
    echo "<p><table class=box cellpadding=4 cellspacing=1>\r\n\t\t\t\t<tr><th class=ttl>#</th><th class=ttl>NPM</th><th class=ttl>Nama Mahasiswa</th><th class=ttl>Tempat Lahir</th><th class=ttl>Tanggal Lahir</th><th class=ttl>Agama</th></tr>";
    while ($r = _fetch_array($w)) {
        $n++;
        echo "<tr><td class=inp>{$n}.</td><td class=ul><a href=?mnux=mhsw.inq.det&mhswid={$r['IDM']}&mhsw.inq>{$r['IDM']}</a></td><td class=ul>{$r['NamaM']}</td><td class=ul>{$r['TempatLahir']}</td><td class=ul>{$r['TanggalLahir']}</td><td class=ul>{$r['Nama']}</td>";
    }
    echo "</table></p>";
}
$tahun = GetSetVar('tahun');
$KodeMK = GetSetVar('KodeMK');
$Kelas = GetSetVar('Kelas');
$jenjad = GetSetVar('jenjad');
TampilkanJudul('Inquiry Peserta Kuliah');
FilterInqMhswPerMK();
if (!empty($tahun) && !empty($KodeMK) && !empty($Kelas)) {
    TampilkanDaftarMhsw();
}
示例#5
0
function TampilkanDaftarMhsw1()
{
    TampilkanDaftarMhsw("?mnux=klinik.biyar&gos=Biyar&MhswID==MhswID=");
}