function fnDftrJdwl()
{
TampilkanHeaderJadwal();
$whr_prog = $_SESSION['_jdwlProg'] == '' ? '' : "and j.ProgramID='{$_SESSION['_jdwlProg']}' ";
$whr_hari = $_SESSION['_jdwlHari'] == '' ? '' : "and j.HariID = '{$_SESSION['_jdwlHari']}' ";
$s = "select j.*,\r\n left(j.Nama, 50) as _Nama,\r\n left(j.JamMulai, 5) as _JM,\r\n left(j.JamSelesai, 5) as _JS,\r\n d.Nama as NamaDosen, d.Gelar\r\n from jadwal j\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n where j.KodeID = '" . KodeID . "'\r\n and j.ProdiID = '{$_SESSION['_jdwlProdi']}'\r\n and j.TahunID = '{$_SESSION['_jdwlTahun']}'\r\n and j.{$_SESSION['_jdwlU']}RuangID = ''\r\n {$whr_prog}\r\n {$whr_hari}\r\n order by j.HariID, j.JamMulai, j.JamSelesai";
$r = _query($s);
$n = 0;
$hdr = "<tr><th class=ttl width=10>#</th>\r\n <th class=ttl width=70>Jam Kuliah</th>\r\n <th class=ttl>Matakuliah blm dijadwalkan ujian</th>\r\n <th class=ttl>Kelas</th>\r\n <th class=ttl>Prodi</th>\r\n <th class=ttl width=10>{$_SESSION['_jdwlU']}</th>\r\n </tr>";
RandomStringScript();
echo <<<ESD
<table class=box cellspacing=1 width=100%>
<script>
function RefreshAll() {
parent.RefreshAll();
}
function JadwalkanUjian(jid) {
var _rnd = randomString();
lnk = "../{$_SESSION['mnux']}.edit.php?jid="+jid;
win2 = window.open(lnk, "", "width=500, height=400, scrollbars, status");
if (win2.opener == null) childWindow.opener = self;
}
</script>
ESD;
$hr = '-1';
while ($w = _fetch_array($r)) {
$n++;
if ($hr != $w['HariID']) {
$hr = $w['HariID'];
$_hr = GetaField('hari', 'HariID', $hr, 'Nama');
echo "<tr><td class=ul1 colspan=6><font size=+1>{$_hr}</font></td></tr>";
echo $hdr;
}
echo <<<ESD
<tr><td class=inp width=10>{$n}</td>
<td class=ul width=70><sup>{$w['_JM']}</sup>~<sub>{$w['_JS']}</sub></td>
<td class=ul>
<sup>{$w['MKKode']} − {$w['SKS']} sks</sup><br />
{$w['_Nama']}
<div align=right>
<sub>{$w['NamaDosen']}, {$w['Gelar']}</sub>
</div>
</td>
<td class=ul align=center>
{$w['NamaKelas']}<br />
{$w['JumlahMhsw']} <sub>mhs</sub>
</td>
<td class=ul align=center>
<sup>{$w['ProgramID']}</sup><br />
{$w['ProdiID']}
</td>
<td class=ul width=10 align=center>
<a href='#' onClick="javascript:JadwalkanUjian({$w['JadwalID']})"><img src='../img/check.gif' /></a>
</td>
</tr>
ESD;
}
echo "</table>";
}
<?php
// Author : SIAKAD TEAM
// Email : setio.dewo@gmail.com
// Start : 21 Agustus 2008
// *** Parameters ***
$_jdwlProdi = GetSetVar('_jdwlProdi');
$_jdwlProg = GetSetVar('_jdwlProg');
$_jdwlTahun = GetSetVar('_jdwlTahun');
$_jdwlHari = GetSetVar('_jdwlHari');
$_jdwlKelas = GetSetVar('_jdwlKelas');
$_jdwlSemester = GetSetVar('_jdwlSemester');
$_jdwlMKKode = GetSetVar('_jdwlMKKode');
// *** Main ***
TampilkanJudul("Jadwal Kuliah");
TampilkanHeaderJadwal();
RandomStringScript();
// validasi
if (!empty($_jdwlTahun) && !empty($_jdwlProdi)) {
$gos = empty($_REQUEST['gos']) ? 'DftrKuliah' : $_REQUEST['gos'];
$gos();
}
// *** Functions ***
function TampilkanHeaderJadwal()
{
// Edit: Ilham
$s = "select DISTINCT(TahunID) from tahun where KodeID='" . KodeID . "' order by TahunID DESC";
$r = _query($s);
$opttahun = "<option value=''></option>";
while ($w = _fetch_array($r)) {
$ck = $w['TahunID'] == $_SESSION['_jdwlTahun'] ? "selected" : '';
function PraKRS()
{
$JadwalID = $_REQUEST['JadwalID'];
$jdwl = GetFields('jadwal', 'JadwalID', $JadwalID, '*');
TampilkanHeaderJadwal($jdwl);
DaftarMhswPraKRS($jdwl);
}
$jml = GetaField('presensi', "JadwalID", $JadwalID, "count(*)") + 0;
$s2 = "update jadwal set Kehadiran={$jml} where JadwalID={$JadwalID}";
$r2 = _query($s2);
echo "<script>window.location = '?mnux=jadwal.pres'; </script>";
}
// *** Parameters ***
$tahun = GetSetVar('tahun');
$DosenID = GetSetVar('dosen');
$JadwalID = GetSetVar('JadwalID');
if (!empty($_REQUEST['Kirim'])) {
$JadwalID = 0;
$_SESSION['JadwalID'] = 0;
}
$gos = empty($_REQUEST['gos']) ? 'DftrPres' : $_REQUEST['gos'];
$Tanggal_y = GetSetVar('Tanggal_y', date('Y'));
$Tanggal_m = GetSetVar('Tanggal_m', date('m'));
$Tanggal_d = GetSetVar('Tanggal_d', date('d'));
$Tanggal = "{$Tanggal_y}-{$Tanggal_m}-{$Tanggal_d}";
$_SESSION['Tanggal'] = $Tanggal;
// *** Main ***
TampilkanJudul("Presensi Kuliah");
TampilkanHeaderDosenMK('jadwal.pres');
$jdwl = GetFields("jadwal j\r\n left outer join dosen d on j.DosenID=d.Login\r\n left outer join jenisjadwal jj on j.JenisJadwalID=jj.JenisJadwalID\r\n left outer join hari h on j.HariID=h.HariID\r\n left outer join ruang r on j.RuangID=r.RuangID\r\n left outer join kampus k on r.KampusID=k.KampusID", 'JadwalID', $JadwalID, "j.*, d.Nama as NamaDosen, concat(d.Nama, ', ', d.Gelar) as DSN, \r\n h.Nama as HR, k.Nama as KMP, jj.Nama as JENIS,\r\n time_format(j.JamMulai, '%H:%i') as JM,\r\n time_format(j.JamSelesai, '%H:%i') as JS");
if (!empty($jdwl)) {
if ($jdwl['JumlahMhsw'] >= 0) {
TampilkanHeaderJadwal($jdwl);
$gos($jdwl);
} else {
echo ErrorMsg("Tidak Ada Mhsw", "Tidak ada mahasiswa yang mendaftar KRS Matakuliah ini.<br />\r\n Tidak dapat mendatakan presensi dosen dan mahasiswa.");
}
}
