function Edit($md, $jid, $krsid, $krsresid, $jenis)
{
if ($md == 0) {
// Mode Edit
$jdl = "Edit Jadwal Tambahan";
} elseif ($md == 1) {
// Mode Tambah
$jdl = "Tambah Jadwal Tambahan";
} else {
die(ErrorMsg("Error", "Mode tidak dikenali"));
}
$w = GetFields('jadwal', "JadwalID='{$jid}' and KodeID", KodeID, "*");
$w['Dosen'] = GetaField('dosen', "KodeID='" . KodeID . "' and Login", $w['DosenID'], 'Nama');
// Parameters
$NamaHari = GetaField('hari', 'HariID', $w['HariID'], 'Nama');
$NamaJenisJadwal = GetaField('jenisjadwal', "JenisJadwalID", $jenis, 'Nama');
// Tampilkan
TampilkanJudul($jdl);
echo <<<END
<table class=bsc cellspacing=1 width=100%>
<tr><td class=inp>Matakuliah:</td>
<td class=ul1>{$w['Nama']} <sup>{$w['MKKode']}</sup></td>
<td class=inp>Jenis Jadwal:</td>
\t <td class=ul1>{$jenis} - {$NamaJenisJadwal}</td>
\t </tr>
<tr><td class=inp>Dosen Pengajar:</td>
<td class=ul1>{$w['Dosen']} <sup>{$w['DosenID']}</sup></td>
<td class=inp>Kelas:</td>
<td class=ul1>{$w['NamaKelas']}</td>
</tr>
<tr><td colspan=4><hr color=silver size=3></td></tr>
</table>
END;
echo "<table class=bsc cellspacing=1 width=100%>\n <form name='frmJadwalTambahan' action='../{$_SESSION['mnux']}.resedit.php' method=POST>\n <input type=hidden name='gos' value='Simpan' />\n <input type=hidden name='md' value='{$md}' />\n <input type=hidden name='jid' value='{$jid}' />\n <input type=hidden name='krsid' value='{$krsid}' />\n <input type=hidden name='krsresid' value='{$krsresid}' />\n <input type=hidden name='jenis' value='{$jenis}' />";
echo "<tr>\n <th class=ttl width=10>Ambil</th>\n <th class=ttl>Keterangan</th>\n\t<th class=ttl width=15>Hari</th>\n <th class=ttl width=70>Jam<br />Kuliah</th>\n\t<th class=ttl width=80>Ruang</th>\n\t<th class=ttl width=50>Jmlh.<br>Siswa</th>\n <th class=ttl width=50>Kap.</th>\n\t</tr>";
$s1 = "select jr.JadwalID, jr.JadwalRefID, LEFT(jr.JamMulai, 5) as JM, LEFT(jr.JamSelesai, 5) as JS, \n\t\t\t\t\tjr.RuangID, jr.JumlahMhsw, jr.Kapasitas, h.Nama as _NamaHari, jr.JenisJadwalID, jj.Nama as _NamaJenisJadwal\n\t\t\t\tfrom jadwal jr left outer join hari h on jr.HariID=h.HariID\n\t\t\t\t\t\t\t\tleft outer join jenisjadwal jj on jj.JenisJadwalID=jr.JenisJadwalID\n\t\t\t\twhere jr.JadwalRefID='{$jid}' and jr.KodeID='" . KodeID . "' and jr.JenisJadwalID='{$jenis}'\n\t\t\t\torder by jr.HariID, jr.JamMulai, jr.JamSelesai";
$r1 = _query($s1);
$n1 = 0;
while ($w1 = _fetch_array($r1)) {
$n1++;
$class = 'ul1';
$ada = GetaField('krs', "JadwalID='{$w1['JadwalID']}' and KodeID", KodeID, "KRSID");
$checked = empty($ada) ? "" : "checked";
echo "<tr>\n\t\t\t <td class={$class} align=right>\n\t\t\t\t<input type=checkbox id='JdwlRes{$w['JadwalID']}of{$n1}' name='jresid[]' value='{$w1['JadwalID']}' onChange=\"ChooseLab('{$w['JadwalID']}', '{$n1}')\" {$checked}/>\n\t\t\t\t</td>\n\t\t\t <td class={$class} align=left width=50><b>{$w1['_NamaJenisJadwal']} #{$n1}</b></td>\n\t\t\t <td class={$class} align=center>{$w1['_NamaHari']}</td>\n\t\t\t <td class={$class}><sup>{$w1['JM']}</sup>−<sub>{$w1['JS']}</sub></td>\n\t\t\t <td class={$class} align=center>{$w1['RuangID']} </td>\n\t\t\t <td class={$class} align=right>{$w1['JumlahMhsw']} </td>\n\t\t\t <td class={$class} align=right>{$w1['Kapasitas']} </td>\n\t\t\t </tr>";
}
echo "<tr><td colspan=4><input type=submit name='Simpan' value='Simpan'></td></tr>";
echo "<input type=hidden id='JdwlResCount{$w['JadwalID']}' name='JdwlResCount{$w['JadwalID']}' value='{$n1}'>";
PilihLabKRSScript();
}
function DftrJadwal($mhswid, $khsid)
{
$khs = GetFields('khs', 'KHSID', $khsid, '*');
TampilkanFilterProgram($khs);
PilihLabKRSScript();
// filtering the listing
$whr_prg = $_SESSION['_krsProgramID'] == '' ? '' : "and j.ProgramID = '{$_SESSION['_krsProgramID']}' ";
$whr_kls = $_SESSION['_krsKelasID'] == '' ? '' : "and kl.Nama like '{$_SESSION['_krsKelasID']}%' ";
$whr_smt = $_SESSION['_krsSemester'] == '' ? '' : "and mk.Sesi = '{$_SESSION['_krsSemester']}' ";
$whr_jenisjadwal = AmbilJenisJadwal();
$whr_krs = AmbilDaftarKRS($mhswid, $khsid);
$s = "select j.JadwalID, j.MKID, j.MKKode, j.Nama, j.SKS, j.HariID, j.AdaResponsi,\r\n LEFT(j.JamMulai, 5) as JM, LEFT(j.JamSelesai, 5) as JS,\r\n j.DosenID, concat(d.Nama, ' <sup>', d.Gelar, '</sup>') as DSN,\r\n j.RuangID, j.NamaKelas, j.ProgramID, j.JumlahMhsw, j.Kapasitas, kl.Nama as NamaKelas, mk.Sesi\r\n from jadwal j\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n left outer join mk on mk.MKID = j.MKID\r\n left outer join kelas kl on kl.KelasID = j.NamaKelas\r\n where j.KodeID = '" . KodeID . "'\r\n and j.TahunID = '{$khs['TahunID']}'\r\n and j.ProdiID = '{$khs['ProdiID']}'\r\n and j.NA = 'N'\r\n {$whr_prg}\r\n {$whr_krs}\r\n {$whr_kls}\r\n {$whr_smt}\r\n\t {$whr_jenisjadwal}\r\n order by j.HariID, j.JamMulai, j.NamaKelas";
$r = _query($s);
$n = 0;
// Jika tidak ada yg ditawarkan:
if (_num_rows($r) == 0) {
die(TampilkanWarning("Tidak ada matakuliah yang dijadwalkan.\r\n <hr size=1 color=white />\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
}
// Tampilkan
echo "<table class=bsc cellspacing=1 width=100%>";
echo "<form action='../{$_SESSION['mnux']}.ambil.php' method=POST>\r\n <input type=hidden name='gos' value='Ambil' />\r\n <input type=hidden name='mhswid' value='{$mhswid}' />\r\n <input type=hidden name='khsid' value='{$khsid}' />";
$hdr = "<tr>\r\n <th class=ttl colspan=2>Ambil</th>\r\n <th class=ttl width=80>Kode <sup title='Semester'>Smt</sup></th>\r\n <th class=ttl>Matakuliah <sup title='SKS MK'>SKS</sup></th>\r\n <th class=ttl width=200>Dosen</th>\r\n\t<th class=ttl width=80>Kelas <sup>Program</sup></th>\r\n <th class=ttl width=70>Jam<br />Kuliah</th>\r\n\t<th class=ttl width=80>Ruang</th>\r\n\t<th class=ttl width=50>Jmlh.<br>Siswa</th>\r\n <th class=ttl width=50>Kap.</th>\r\n\t</tr>";
$hr = -32;
$btn = "<input type=submit name='Simpan' value='Ambil Yg Dicentang' />\r\n <input type=button name='Batal' value='Batal' onClick=\"window.close()\" />";
while ($w = _fetch_array($r)) {
if ($hr != $w['HariID']) {
$hr = $w['HariID'];
$_hr = GetaField('hari', 'HariID', $hr, 'Nama');
$btn1 = $hr > 1 ? $btn : '';
echo "<tr>\r\n <td class=ul1 colspan=3>\r\n <b>{$_hr}</b> <sup>{$hr}</sup>\r\n </td>\r\n <td class=ul1 colspan=5>{$btn1}</td>\r\n </tr>";
echo $hdr;
}
$n++;
$checkboxjadwal = $w['JumlahMhsw'] < $w['Kapasitas'] ? "<input type=checkbox id='JdwlRes{$w['JadwalID']}' name='jid[]' value='{$w['JadwalID']}' onChange=\"ChooseJadwal('{$w['JadwalID']}')\"/>" : "×";
echo "<tr>\r\n <td class=inp>{$n}</td>\r\n <td class=ul1 width=5>\r\n {$checkboxjadwal}\r\n </td>\r\n \r\n <td class=ul1>{$w['MKKode']}<sup>{$w['Sesi']}</sup></td>\r\n <td class=ul1>{$w['Nama']} <sup>{$w['SKS']}</sup></td>\r\n <td class=ul1>{$w['DSN']} </td>\r\n\t <td class=ul1>{$w['NamaKelas']} <sup>{$w['ProgramID']}</sup></td>\r\n\t <td class=ul1><sup>{$w['JM']}</sup>−<sub>{$w['JS']}</sub></td>\r\n\t <td class=ul1 align=center>{$w['RuangID']} </td>\r\n\t <td class=ul1 align=right>{$w['JumlahMhsw']} </td>\r\n\t <td class=ul1 align=right>{$w['Kapasitas']} </td>\r\n\t </tr>";
if ($w['AdaResponsi'] == 'Y') {
$s1 = "select jr.JadwalID, jr.JadwalRefID, LEFT(jr.JamMulai, 5) as JM, LEFT(jr.JamSelesai, 5) as JS, \r\n\t\t\t\t\tjr.RuangID, jr.JumlahMhsw, jr.Kapasitas, h.Nama as _NamaHari, jr.JenisJadwalID, jj.Nama as _NamaJenisJadwal\r\n\t\t\t\tfrom jadwal jr left outer join hari h on jr.HariID=h.HariID\r\n\t\t\t\t\t\t\t\tleft outer join jenisjadwal jj on jj.JenisJadwalID=jr.JenisJadwalID\r\n\t\t\t\twhere jr.JadwalRefID='{$w['JadwalID']}' and jr.JumlahMhsw < jr.Kapasitas and jr.KodeID='" . KodeID . "'\r\n\t\t\t\torder by jj.JenisJadwalID, jr.HariID, jr.JamMulai, jr.JamSelesai";
$r1 = _query($s1);
$totallab = _num_rows($r1);
if ($totallab == 0) {
echo "<tr\r\n\t\t\t\t\t <td></td>\r\n\t\t\t\t\t <td class=inp>>></td>\r\n\t\t\t\t\t <td class=nac colspan=6 align=center><b>Belum ada jadwal Lab yang dibuat</b></td>\r\n\t\t\t\t\t </tr>";
} else {
$nx = 0;
// Counting the number of each type of extra
$jx = 'K';
// Storing the last type assessed
$typex = 0;
// Counting the number of types of extra
$n1 = 0;
while ($w1 = _fetch_array($r1)) {
if ($jx != $w1['JenisJadwalID']) {
if ($jx != 'K') {
echo "<input type=hidden id='JdwlResCount{$w['JadwalID']}of{$jx}' name='JdwlResCount{$w['JadwalID']}of{$jx}' value='{$nx}'>";
}
$nx = 0;
$typex++;
echo "<input type=hidden id='JdwlResType{$w['JadwalID']}of{$typex}' name='JdwlResType{$w['JadwalID']}of{$typex}' value='{$w1['JenisJadwalID']}'>";
$jx = $w1['JenisJadwalID'];
}
$nx++;
$n1++;
$class = 'cnaY';
echo "<tr>\r\n\t\t\t\t <td></td>\r\n\t\t\t\t <td class=inp>>></td>\r\n\t\t\t\t <td class={$class} width=5 align=right>\r\n\t\t\t\t\t<input type=checkbox id='JdwlRes{$w['JadwalID']}of{$w1['JenisJadwalID']}of{$nx}' name='jresid[]' value='{$w['JadwalID']}~{$w1['JadwalID']}' onChange=\"ChooseLab('{$w['JadwalID']}', '{$w1['JenisJadwalID']}', '{$nx}')\"/>\r\n\t\t\t\t\t</td>\r\n\t\t\t\t <td class={$class} align=left><b>{$w1['_NamaJenisJadwal']} #{$nx}</b></td>\r\n\t\t\t\t <td class={$class} colspan=2><b>Hari:</b> {$w1['_NamaHari']}</td>\r\n\t\t\t\t <td class={$class}><sup>{$w1['JM']}</sup>−<sub>{$w1['JS']}</sub></td>\r\n\t\t\t\t <td class={$class} align=center>{$w1['RuangID']} </td>\r\n\t\t\t\t <td class={$class} align=right>{$w1['JumlahMhsw']} </td>\r\n\t\t\t\t <td class={$class} align=right>{$w1['Kapasitas']} </td>\r\n\t\t\t\t </tr>";
}
echo "<input type=hidden id='JdwlResCount{$w['JadwalID']}of{$jx}' name='JdwlResCount{$w['JadwalID']}of{$jx}' value='{$nx}'>";
echo "<input type=hidden id='JdwlResCountType{$w['JadwalID']}' name='JdwlResCountType{$w['JadwalID']}' value='{$typex}'>";
}
}
}
echo "<tr><td class=ul1 colspan=3> </td><td class=ul1 colspan=5>{$btn}</td></tr>";
echo "</form></table>";
echo "<p align=center>Mata kuliah yang sudah diambil tidak ditampilkan lagi di sini.</p>";
}
