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); }
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(); } }
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(); }
function TampilkanDaftarMhsw1() { TampilkanDaftarMhsw("?mnux=klinik.biyar&gos=Biyar&MhswID==MhswID="); }