function EditRemedial($jdwlrem)
{
$opt_filter_grade = GetOption2('nilai', "Nama", 'Nama', $_SESSION['_rem_filter_grade'], "KodeID='" . KodeID . "' and BisaRemedial='Y' and ProdiID='{$jdwlrem['ProdiID']}'", 'Nama', 0, 0);
echo AmbilHeader($jdwlrem);
$filter_tahun = empty($_SESSION['_rem_filter_tahun']) ? "" : "and a.TahunID = '{$_SESSION['_rem_filter_tahun']}'";
$filter_grade = empty($_SESSION['_rem_filter_grade']) ? "" : "and a.GradeNilai = '{$_SESSION['_rem_filter_grade']}'";
$filter_mkkode = empty($_SESSION['_rem_filter_mkkode']) ? "" : "and a.MKKode = '{$_SESSION['_rem_filter_mkkode']}'";
$s1 = "select a.MhswID, m.Nama as _Mhsw, d.Nama as _Dosen, a.TahunID as _Tahun, a.KRSID, a.GradeNilai , a.SedangRemedial, a.MKKode, a.Nama,\r\n\t\t\t\tkr.KRSRemedialID, kr.Final, k.KHSID as _KHSIDTahunIni\r\n\t\t\t\tfrom krs a\r\n\t\t\t\t\tleft outer join mhsw m on a.MhswID=m.MhswID and m.KodeID='" . KodeID . "'\r\n\t\t\t\t\tleft outer join statusmhsw sm on sm.StatusMhswID=m.StatusMhswID and sm.KodeID='" . KodeID . "'\r\n\t\t\t\t\tleft outer join dosen d on a.DosenID=d.Login and d.KodeID='" . KodeID . "'\r\n\t\t\t\t\tleft outer join khs k on k.TahunID='{$jdwlrem['TahunID']}' and k.MhswID=a.MhswID and k.KodeID='" . KodeID . "' \r\n\t\t\t\t\tleft outer join krsremedial kr on kr.KRSID=a.KRSID and kr.TahunID='{$jdwlrem['TahunID']}' and kr.KodeID='" . KodeID . "'\r\n\t\twhere a.KodeID='" . KodeID . "'\r\n\t\t\tand a.Final = 'Y'\r\n\t\t\tand sm.Keluar = 'N'\r\n\t\t\t{$filter_tahun}\r\n\t\t\t{$filter_grade}\r\n\t\t\t{$filter_mkkode}\r\n\t\t\torder by a.MKKode, m.Nama\r\n\t\t";
$r1 = _query($s1);
loadJavaScripts();
echo "\r\n\t\t<table class=box cellspacing=1 align=center width=800>\r\n\t\t <form action='?' method=POST>\r\n\t\t\t<input type=hidden name='gos' value='RemedialSav' \\>\r\n\t\t\t<input type=hidden name='id' value='{$jdwlrem['JadwalRemedialID']}' \\>\r\n\t\t\t<table class=box cellspacing=1 align=center border=1 width=650>\r\n\t\t\t\r\n\t\t\t";
$counting = 0;
$currentMKKode = '938w5y39nbvwp9ent';
while ($w1 = _fetch_array($r1)) {
if ($currentMKKode != $w1['MKKode']) {
echo "<br>\r\n\t\t\t\t <tr><th class=ttl colspan=7>{$w1['MKKode']} - {$w1['Nama']}</th></tr>";
echo "<tr><th class=ttl width=20>#</th>\r\n\t\t\t\t<th class=ttl width=80>NIM</th>\r\n\t\t\t\t<th class=ttl width>Nama</th>\r\n\t\t\t\t<th class=ttl width=50>Tahun</th>\r\n\t\t\t\t<th class=ttl width=200>Dosen MK</th>\r\n\t\t\t\t<th class=ttl width=30>Grade</th>\r\n\t\t\t\t<th class=ttl width=20>Check</th>";
$currentMKKode = $w1['MKKode'];
}
$counting++;
$class = $w1['_KHSIDTahunIni'] + 0 == 0 ? 'class=wrn' : '';
$check = empty($w1['KRSRemedialID']) ? '' : 'checked';
$grade = empty($w1['GradeNilai']) ? '-' : $w1['GradeNilai'];
$pilihancheck = $w1['Final'] == 'Y' || $w1['_KHSIDTahunIni'] + 0 == 0 ? "<input type=checkbox name='Unused[]' value='{$w1['KRSID']}' {$check} readonly=true disabled=true>" : "<input type=checkbox name='Pilihan[]' value='{$w1['KRSID']}' {$check}>";
echo "<tr><td align=right {$class}>{$counting}.</td>\r\n\t\t\t\t<td {$class}>{$w1['MhswID']}</td>\r\n\t\t\t\t<td {$class}>{$w1['_Mhsw']}</td>\r\n\t\t\t\t<td {$class} align=center>{$w1['_Tahun']}</td>\r\n\t\t\t\t<td {$class}>{$w1['_Dosen']}</td>\r\n\t\t\t\t<td {$class} align=center>{$w1['GradeNilai']}</td>\r\n\t\t\t\t<td {$class} align=center>{$pilihancheck}\r\n\t\t\t\t\t<input type=hidden name='SemuaPilihan[]' value='{$w1['KRSID']}~{$w1['MhswID']}~{$w1['SedangRemedial']}'></td>\r\n\t\t\t</tr>";
}
echo "<tr><td class=ul1 colspan=7 align=center><input type=submit name='Simpan' value='Simpan yang Dicentang'></td></tr>\r\n\t\t\t</table>";
}
function LihatPerRuang($gel)
{
$optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['_usm_prodi'], "KodeID='" . KodeID . "'", 'ProdiID');
$usmpmbopt = GetOption2('pmbusm', "concat(PMBUSMID, ' - ', Nama)", 'PMBUSMID', $_SESSION['_usm_pmbusm'], "KodeID='" . KodeID . "'", 'PMBUSMID');
$pmbusmstring = empty($_SESSION['_usm_pmbusm']) ? "" : "and pu.PMBUSMID='{$_SESSION['_usm_pmbusm']}'";
$s = "select distinct(ru.RuangID) as _RuangID \r\n\t\t\tfrom ruangusm ru left outer join prodiusm pu on ru.ProdiUSMID=pu.ProdiUSMID\r\n\t\t\twhere ru.KodeID='" . KodeID . "' and ru.PMBPeriodID='{$gel}' {$pmbusmstring} order by ru.RuangID";
$r = _query($s);
$w = _fetch_array($r);
$ruangdef = $w['_RuangID'];
$arrruang[] = $w['_RuangID'];
while ($w = _fetch_array($r)) {
$arrruang[] = $w['_RuangID'];
}
//$ruangdef = (!empty($_SESSION['_usm_ruang']))? $_SESSION['_usm_ruang'] : ((empty($ruangdef))? "" : $ruangdef);
//$ruangopt = GetOptionsFromData($arrruang, $ruangdef, 1);
//$_SESSION['_usm_ruang'] = $ruangdef;
CetakKartuScript();
$classHadir = $_SESSION['_usm_jenisx'] == 0 ? 'class=menuaktif' : 'class=menuitem';
$classNilai = $_SESSION['_usm_jenisx'] == 1 ? 'class=menuaktif' : 'class=menuitem';
echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n\t <form action='?' method=POST>\r\n\t <input type=hidden name='mnux' value='{$_SESSION['mnux']}'>\r\n\t <tr><td {$classHadir}><a href='?mnux={$_SESSION['mnux']}&gos=&_usm_jenisx=0'>Daftar Hadir</a></td><td rowspan=3 class='wrn'></td>\r\n\t\t <td class=inp>Periode :</td><td class=ul1 colspan=2><input type=text name=tahunpmb value='{$gel}' size=10 disabled></td></tr>\r\n\t <tr><td {$classNilai}><a href='?mnux={$_SESSION['mnux']}&gos=&_usm_jenisx=1'>Daftar Nilai</a></td><td class=inp>Program Studi:</td>\r\n\t\t <td class=ul1 colspan=2><select name='_usm_prodi' onChange='this.form.submit()'>{$optprodi}</select><br></td></tr>\r\n\t <tr><td class=ul1 align=center></td><td class=inp>Mata Uji:</td>\r\n\t <td class=ul1 colspan=2><select name='_usm_pmbusm' onChange='this.form.submit()'>{$usmpmbopt}</select></td>\r\n\t\t <td class=ul1 rowspan=2 width=50 align=center valign=center><a href='#' onClick=\"javascript:CetakDHU('{$gel}', '{$_SESSION['_usm_ruang']}', '{$_SESSION['_usm_prodi']}')\" /><img title='Print Denah USM' src='img/printer2.gif' />\r\n\t </tr>\t \r\n\t </form></table></p>";
$reltitle = empty($_SESSION['_usm_pmbusm']) ? "" : "<th class=ttl width=40>Hadir?</th>";
$topbutton = empty($_SESSION['_usm_pmbusm']) ? "" : "<input type=button name='CheckAllMember' value='Hadir Semua' onClick=\"CheckAll('Hadir')\" />";
$botbutton = empty($_SESSION['_usm_pmbusm']) ? "" : "<input type=button name='SubmitButton' value='Simpan' onClick=\"ignoreCheckBoxDisable('Hadir', this.form)\" />";
$botbutton2 = empty($_SESSION['_usm_pmbusm']) ? "" : "<input type=button name='UnCheckAllMember' value='Clear Semua' onClick=\"UnCheckAll('Hadir')\" />";
loadJavaScripts();
$ProdiUSMID = GetaField('prodiusm', "INSTR(concat('|', ProdiID, '|'), concat('|', '{$_SESSION['_usm_prodi']}', '|'))!=0 and PMBUSMID='{$_SESSION['_usm_pmbusm']}' and PMBPeriodID = '{$gel}' and KodeID", KodeID, 'ProdiUSMID');
if (empty($ProdiUSMID)) {
echo ErrorMsg("Tidak ada data", "Tidak ada jadwal USM yang ditemukan.<br>\r\n\t\t\t\t\t\t\t\t\tHarap menghubungi Kepala PMB untuk men-setup jadwal terlebih dahulu");
} else {
echo "<Iframe name='frame{$n}' src='{$_SESSION['mnux']}.frame.php?ProdiUSMID={$ProdiUSMID}&gel={$gel}' align=center width=800 height=750 frameborder=0></Iframe>";
}
}
function ListWawancara($gelombang)
{
$s1 = "select * from `pmb` \r\n\t\t\twhere (PMBID like '%{$_SESSION['_wawanEntry']}%'\r\n\t\t\t\tor Nama like '%{$_SESSION['_wawanEntry']}%')\r\n\t\t\t\tand PMBPeriodID='{$gelombang}'\r\n\t\t\t\tand KodeID='" . KodeID . "'\r\n\t\t\torder by PMBID";
$r1 = _query($s1);
$n1 = _num_rows($r1);
$x1 = 0;
loadJavaScripts();
if ($n1 == 0) {
// Jika nama calon mahasiswa/no.PMB tidak diketemukan dalam table pmb
if (!empty($_REQUEST['_wawanEntry'])) {
echo "<br>Nama/No. Pmb: <b>{$_REQUEST['_wawanEntry']}</b> tidak diketemukan. Silakan mencoba lagi";
}
} else {
echo "<p>\r\n\t\t\t\t\t<table class=box cellspacing=1 cellpadding=4 width=800>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th class=ttl width=80 rowspan=2 valign=center>No. PMB (Daftar)</th>\r\n\t\t\t\t\t\t<th class=ttl width=200 rowspan=2 valign=center>Nama Calon Mahasiswa</th>\r\n\t\t\t\t\t\t<th class=ttl width=20 rowspan=2 valign=center>Prodi</th>\r\n\t\t\t\t\t\t<th class=ttl width=600 colspan=7>Data Wawancara</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th class=ttl width=20 align=center>#</th>\r\n\t\t\t\t\t\t<th class=ttl width=80>Tgl.</th>\r\n\t\t\t\t\t\t<th class=ttl width=240>Pewawancara</th>\r\n\t\t\t\t\t\t<th class=ttl width=20>Saran</th>\r\n\t\t\t\t\t\t<th class=ttl width=100>Rekomendasi</th>\r\n\t\t\t\t\t\t<th class=ttl width=20></th>\r\n\t\t\t\t\t\t<th class=ttl width=20></th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t";
while ($w1 = _fetch_array($r1)) {
// Jika nama calon mahasiswa/no.PMB ditemukan
$s = "select * from `wawancara` \r\n\t\t\t\t\twhere PMBID = '{$w1['PMBID']}' and KodeID='" . KodeID . "' and PMBPeriodID='{$gelombang}'";
$r = _query($s);
$n = _num_rows($r);
$x = 0;
if ($n == 0) {
echo "<tr>\r\n\t\t\t\t\t\t<td class=ul1 align=center><b>{$w1['PMBID']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 align=center><b>{$w1['Nama']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 valign=center align=center>{$w1['Pilihan1']}<br><hr color=green><br>{$w1['Pilihan2']}</td>\r\n\t\t\t\t\t<td class=ul1 colspan=4 align=center><b> - Belum ada wawancara -</b></td>\r\n\t\t\t\t\t<td colspan=3 align=right>\t\t\r\n\t\t\t\t\t\t<input type=button name='Tambah' value='Tambah Wawancara'\r\n\t\t\t\t\t\t\tonClick=\"javascript:fnEditCama('{$gelombang}', 1, '{$w1['PMBID']}')\" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=10>\r\n\t\t\t\t\t\t\t<hr color=green width=100%>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>";
} else {
if ($n < 3) {
$n_row = 3;
} else {
$n_row = $n + 1;
}
//Set Variable bila Nama/No.PMB ada/tidak ada di dalam table `wawancara`
$x1++;
echo "<tr>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center><b>{$w1['PMBID']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center><b>{$w1['Nama']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$w1['Pilihan1']}<br><hr color=green><br>{$w1['Pilihan2']}</td>";
while ($arr = _fetch_array($r)) {
$x++;
if ($n == 0) {
$n_row = 2;
} else {
if ($n == 1) {
$n_row = 2;
} else {
$n_row = 1;
}
}
$tanggalwawancara = substr($arr['TanggalWawancara'], 0, 16);
echo "\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=right>{$x}.</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$tanggalwawancara}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center >{$arr['Pewawancara']} , {$arr['Pewawancara2']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$arr['SaranProgram']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$arr['HasilWawancara']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center ><a href=\"javascript:fnEditCama('{$gelombang}', 0, '{$arr['WawancaraID']}')\"><img src='img/edit.png' border=0></a></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center ></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t";
if ($n < 2) {
echo "</tr><tr>";
}
}
echo "\t<td colspan=7 align=right>\t\t\r\n\t\t\t\t\t\t<input type=button name='Tambah' value='Tambah Wawancara'\r\n\t\t\t\t\t\t\tonClick=\"javascript:fnEditCama('{$gelombang}', 1, '{$w1['PMBID']}')\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=10>\r\n\t\t\t\t\t\t\t<hr color=green width=100%>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t";
}
}
echo "</table></p>";
}
}
function TampilkanRemedial()
{
$TahunID = $_SESSION['_remTahun'];
$ProdiID = $_SESSION['_remProdi'];
$ProgramID = $_SESSIOn['_remProg'];
$whr_prodi = empty($ProdiID) ? "" : "and ProdiID='{$ProdiID}'";
$whr_tahun = empty($TahunID) ? "" : "and TahunID='{$TahunID}'";
$whr_prog = empty($ProgramID) ? "" : "and ProgramID='{$ProgramID}'";
// Paging Parameters
$limit = 20;
$start_page = $limit * $_SESSION['_remPage'];
$counting = $start_page;
$s = "select * from jadwalremedial \r\n\t\t\twhere KodeID='" . KodeID . "'\r\n\t\t\t\t{$whr_tahun}\r\n\t\t\t\t{$whr_prodi}\r\n\t\t\t\t{$whr_prog}";
$r = _query($s);
loadJavaScripts();
echo "<p><table class=box cellspacing=1 align=center width=900>\r\n\t\t\t<form action='?' method=POST>\r\n\t\t\t\t\r\n\t\t\t\t<tr><td class=ul1 align=center>\r\n\t\t\t\t\t\t<input type=button name='Laporan' value='Laporan Daftar Remedial Mahasiswa' onClick=\"fnDaftarRemedial()\">\r\n\t\t\t\t\t\t<input type=button name='CetakJadwal' value='Cetak Semua Jadwal' onClick=\"fnCetakJadwal()\">\r\n\t\t\t\t\t\t<input type=button name='CetakMahasiswa' value='Cetak Semua Peserta Remedial' onClick=\"fnCetakPeserta()\">\r\n\t\t\t\t\t\t<input type=button name='Gagal' value='Cetak Mahasiswa Gagal' onClick=\"fnGagalRemedial()\"></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t</form>\t\r\n\t\t</table></p>";
echo "<p><table class=box cellspacing=1 align=center width=900>\r\n\t\t\t<form action='?' method=POST>\r\n\t\t\t\t<tr><th class=ttl width=20 colspan=2>#</th>\r\n\t\t\t\t\t<th class=ttl width=200>Matakuliah</th>\r\n\t\t\t\t\t<th class=ttl width=40>SKS</th>\r\n\t\t\t\t\t<th class=ttl width=120>Tanggal Penting</th>\r\n\t\t\t\t\t<th class=ttl width=70>&sum Mhsw</th>\r\n\t\t\t\t\t<th class=ttl width=70>Nilai</th>\r\n\t\t\t\t\t";
while ($w = _fetch_array($r)) {
$n++;
$TanggalPenting = AmbilTanggalPenting($w['JadwalRemedialID']);
$DetailMhsw = "{$w['JmlhMhsw']}\r\n\t\t\t\t\t\t<br><a href='#self' onClick=\"fnEditMhsw('{$w['JadwalRemedialID']}')\"><sup>Daftar Mhsw</sup></a>";
echo "<tr><td class=inp width=10>{$n}</td>\r\n\t\t\t\t\t<td class=ul1 width=10><a href='#' onClick=\"fnEditRemedial(0, '{$w['JadwalRemedialID']}')\"><img src='img/edit.png'></a></td>\r\n\t\t\t\t\t<td class=ul1 width=200>{$w['Nama']}</td>\r\n\t\t\t\t\t<td class=ul1 width=40 align=center>{$w['SKS']}</td>\r\n\t\t\t\t\t<td class=ul1>{$TanggalPenting}</td>\r\n\t\t\t\t\t<td class=ul1 width=70 align=center>{$DetailMhsw}</td>\r\n\t\t\t\t\t<td class=ul1 width=70 align=center><a href='#' onClick=\"fnIsiNilai('{$w['JadwalRemedialID']}')\"><img src='img/edit.jpg'></a></td>\r\n\t\t\t </tr>";
}
// Paging
$totalpage = floor($n / $limit) + 1;
$fontpage = $_SESSION['_remPage'] + 1 == 1 ? '<font color=red>1</font>' : '<font color=green>1</font>';
$tempmnux = $_SESSION['mnux'];
$pagestring = "<a href='#' onClick=\"changePage(1, '{$tempmnux}', this.form);\">{$fontpage}</a>";
for ($j = 2; $j <= $totalpage; $j++) {
$fontpage = $j == $_SESSION['_remPage'] + 1 ? '<font color=red>' : '<font color=green>';
$pagestring .= ", <a href='#' onClick=\"changePage({$j}, '{$tempmnux}', this.form);\">{$fontpage}{$j}</font></a>";
}
//$nextstartpage = $start_page+1;
echo "\r\n\t\t\r\n\t\t<tr>\r\n\t\t\t<td class=ul1 colspan=10 align=center><font color=green><b>Hal:</b></font> {$pagestring}</td>\r\n\t\t</tr>\r\n\t\t<tr>\r\n\t\t\t<td class=ul1 colspan=10 align=center><font color=green><b>Total:</b></font> <b>{$n}</b></td>\r\n\t\t</tr>";
echo "</form>\r\n\t\t</table></p>\r\n\t\t";
}
function ProdiEdt()
{
$md = $_REQUEST['md'] + 0;
if ($md == 0) {
$w = GetFields('prodi', 'ProdiID', $_REQUEST['prid'], '*');
$_prid = "<input type=hidden name='prid' value='{$w['ProdiID']}'><b>{$w['ProdiID']}</b>";
$jdl = 'Edit Program Studi';
} else {
$w = array();
$w['ProdiID'] = '';
$w['Nama'] = '';
$w['Nama_en'] = '';
$w['JenjangID'] = '';
$w['Gelar'] = '';
$w['FakultasID'] = $_SESSION['fid'];
$w['FormatNIM'] = '';
$w['GunakanNIMSementara'] = 'N';
$w['FormatNIMSementara'] = '';
$w['DapatPindahProdi'] = '';
$w['ProdiDiktiID'] = '';
$w['NamaSesi'] = "Semester";
$w['CekPrasyarat'] = 'Y';
$w['DefSKS'] = 0;
$w['DefKehadiran'] = 16;
$w['DefMaxAbsen'] = 4;
$w['TotalSKS'] = 0;
$w['BatasStudi'] = 0;
$w['JumlahSesi'] = 0;
$w['Akreditasi'] = '';
$w['NoSKDikti'] = '';
$w['TglSKDikti'] = date('Y-m-d');
$w['NoSKBAN'] = '';
$w['TglSKBAN'] = date('Y-m-d');
$w['PajakHonorDosen'] = 10;
$w['Pejabat'] = '';
$w['Jabatan'] = '';
$w['NA'] = 'N';
$_prid = "<input type=text name='prid' size=30 maxlength=20>";
$jdl = 'Tambah Program Studi';
}
CheckFormScript("prid,Nama,FormatNIM,DefSKS");
CariProdiDikti();
loadJavaScripts();
$NamaProdi = GetaField('prodidikti', 'ProdiDiktiID', $w['ProdiDiktiID'], 'Nama');
$TglSKDikti = GetDateOption($w['TglSKDikti'], 'TglSKDikti');
$TglSKBAN = GetDateOption($w['TglSKBAN'], 'TglSKBAN');
$gns = $w['GunakanNIMSementara'] == 'Y' ? 'checked' : '';
$dagns = $w['GunakanNIMSementara'] == 'Y' ? '' : 'disabled';
$na = $w['NA'] == 'Y' ? 'checked' : '';
$cp = $w['CekPrasyarat'] == 'Y' ? 'checked' : '';
$snm = session_name();
$sid = session_id();
$opt = GetOption2('fakultas', "concat(FakultasID, '. ', Nama)", 'FakultasID', $w['FakultasID'], '', 'FakultasID');
$optjen = GetOption2('jenjang', "concat(JenjangID, ' - ', Nama)", 'JenjangID', $w['JenjangID'], '', 'JenjangID');
//GetCheckboxes($table, $key, $Fields, $Label, $Nilai='', $Separator=',') {
$pind = GetCheckboxes("prodi", "ProdiID", "concat(ProdiID, ' - ', Nama) as NM", 'NM', $w['DapatPindahProdi'], '.', "ProdiID <> '{$w['ProdiID']}'");
return "<p><table class=box cellspacing=1 cellpadding=4 width=600>\r\n <form name='data' action='?' method=POST onSubmit=\"return CheckForm(data)\">\r\n <input type=hidden name='mnux' value='{$_SESSION['mnux']}'>\r\n <input type=hidden name='gos' value='ProdiSav'>\r\n <input type=hidden name='md' value='{$md}'>\r\n\r\n <tr><th colspan=2 class=ttl>{$jdl}</th></tr>\r\n <tr><td class=inp>Program Studi</td><td class=ul>{$_prid}</td></tr>\r\n <tr><td class=inp>Fakultas</td><td class=ul><select name='FakultasID'>{$opt}</select></td></tr>\r\n <tr><td class=inp>Nama</td><td class=ul><input type=text name='Nama' value='{$w['Nama']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Nama Inggris</td><td class=ul><input type=text name='Nama_en' value='{$w['Nama_en']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Jenjang</td><td class=ul><select name='JenjangID'>{$optjen}</select></td></tr>\r\n <tr><td class=inp>Gelar</td><td class=ul><input type=text name='Gelar' value='{$w['Gelar']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Format NIM</td><td class=ul><input type=text name='FormatNIM' value='{$w['FormatNIM']}' size=30 maxlength=100></td></tr>\r\n <tr><td class=inp>Gunakan NIM Sementara?</td><td class=ul><input type=checkbox name='GunakanNIMSementara' value='Y' onClick=\"ToggleNIMSementara()\" {$gns}>\r\n\t\t\t\t\t<input type=text name='FormatNIMSementara' value='{$w['FormatNIMSementara']}' size=30 maxlength=100 {$dagns}></td></tr>\r\n <tr><td class=inp>Dapat Pindah ke Prodi</td><td class=ul>{$pind}</td></tr>\r\n <tr><td class=inp>Nama Sesi</td>\r\n <td class=ul><input type=text name='NamaSesi' value='{$w['NamaSesi']}' size=20 maxlength=50> <sup>Misal: Semester, Cawu.</sup></td></tr>\r\n <tr><td class=inp>Cek Prasyarat</td>\r\n <td class=ul><input type=checkbox name='CekPrasyarat' value='Y' {$cp}> <sup>*) Jika dicentang, <br />\r\n maka pengambilan KRS akan mengecek MK prasyarat</sup>\r\n </td></tr>\r\n <tr><td class=inp>Total SKS Lulus</td><td class=ul><input type=text name='TotalSKS' value='{$w['TotalSKS']}' size=5 maxlength=4></td></tr>\r\n <tr><td class=inp>Default SKS</td><td class=ul><input type=text name='DefSKS' value='{$w['DefSKS']}' size=3 maxlength=3></td></tr>\r\n <tr><td class=inp>Default Kehadiran</td><td class=ul><input type=text name='DefKehadiran' value='{$w['DefKehadiran']}' size=4 maxlength=3></td></tr>\r\n <tr><td class=inp>Default Maksimum Absen</td><td class=ul><input type=text name='DefMaxAbsen' value='{$w['DefMaxAbsen']}' size=4 maxlength=3></td></tr>\r\n <tr><td class=inp>Kode Prodi Dikti</td><td class=ul><input type=text name='ProdiDiktiID' value='{$w['ProdiDiktiID']}' size=10 maxlength=20>\r\n <input type=text name='NamaProdi' value='{$NamaProdi}' size=30 maxlength=50>\r\n <a href='javascript:cariprodidikti(data)'>Cari</a></td></tr>\r\n <tr><td class=inp>Pajak Honor Dosen</td><td class=ul><input type=text name='PajakHonorDosen' value='{$w['PajakHonorDosen']}' size=3 maxlength=3></td></tr>\r\n <tr><td class=inp>Tidak aktif?</td><td class=ul><input type=checkbox name='NA' value='Y' {$na}></td></tr>\r\n \r\n <tr><td class=ul colspan=2><b>Pejabat Jurusan</b></td></tr>\r\n <tr><td class=inp>Nama Pejabat</td><td class=ul><input type=text name='Pejabat' value='{$w['Pejabat']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Nama Jabatan</td><td class=ul><input type=text name='Jabatan' value='{$w['Jabatan']}' size=30 maxlength=50></td></tr>\r\n \r\n <tr><td class=ul colspan=2><b>Batas Studi</b></td></tr>\r\n <tr><td class=inp>Batas Studi</td><td class=ul><input type=text name='BatasStudi' value='{$w['BatasStudi']}' size=3 maxlength=2> Sesi/Semester</td></tr>\r\n <tr><td class=inp>Jml Sesi/tahun</td><td class=ul><input type=text name='JumlahSesi' value='{$w['JumlahSesi']}' size=3 maxlength=2> per tahun</td></tr>\r\n \r\n <tr><td class=ul colspan=2><b>Surat Keputusan</b></td></tr>\r\n <tr><td class=inp>No SK Dikti</td><td class=ul><input type=text name='NoSKDikti' value='{$w['NoSKDikti']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Tanggal SK Dikti</td><td class=ul>{$TglSKDikti}</td></tr>\r\n <tr><td class=inp>No SK BAN</td><td class=ul><input type=text name='NoSKBAN' value='{$w['NoSKBAN']}' size=30 maxlength=50></td></tr>\r\n <tr><td class=inp>Tanggal SK BAN</td><td class=ul>{$TglSKBAN}</td></tr>\r\n <tr><td class=inp>Akreditasi</td><td class=ul><input type=text name='Akreditasi' value='{$w['Akreditasi']}' size=5 maxlength=10></td></tr>\r\n <tr><td colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan'>\r\n <input type=reset name='Reset' value='Reset'>\r\n <input type=button name='Batal' value='Batal' onClick=\"location='?mnux={$_SESSION['mnux']}&{$snm}={$sid}'\"></td></tr>\r\n </form></table></p>";
}
<?php
//Author: Irvandy Goutama
// Start: 8 Januari 2009
// Email: irvandygoutama@gmail.com
// *** Parameters ***
$md = $_REQUEST['md'];
$opk_kelas = GetSetVar('opk_kelas', '');
$prodi = GetSetVar('prodi', '');
$program = GetSetVar('program', '');
$kelamin_by = GetSetVar('kelamin_by', '');
$nilai_dari = GetSetVar('nilai_dari', '0');
$nilai_sampai = GetSetVar('nilai_sampai', '100');
loadJavaScripts();
// *** Main ***
$sub = empty($_REQUEST['sub']) ? 'HalamanUtamaOPK' : $_REQUEST['sub'];
$sub();
// *** Helper Functions ***
function GetOptionsFromData($sourceArray, $chosen)
{
$optresult = "";
if ($chosen == '' or empty($chosen)) {
$optresult .= "<option value='' selected></option>";
} else {
$optresult .= "<option value=''></option>";
}
for ($i = 0; $i < count($sourceArray); $i++) {
if ($chosen == $sourceArray[$i]) {
$optresult .= "<option value='{$sourceArray[$i]}' selected>{$sourceArray[$i]}</option>";
} else {
$optresult .= "<option value='{$sourceArray[$i]}'>{$sourceArray[$i]}</option>";
function EditRemedial($JadwalRemedialID)
{
$MKID = $_REQUEST['MKID'] + 0;
if ($JadwalRemedialID == 0) {
$tahunstring = empty($_SESSION['TahunID']) ? "" : "and j.TahunID='{$_SESSION['TahunID']}'";
$prodistring = empty($_SESSION['_remedialProdiID']) ? "" : "and j.ProdiID='{$_SESSION['_remedialProdiID']}'";
$s = "select j.MKKode, j.Nama, j.SKS, j.ProdiID, j.TahunID, d.Nama as _Dosen \r\n\t\t\t\tfrom jadwal j left outer join dosen d on j.DosenID=d.Login and j.KodeID=d.KodeID\r\n\t\t\t\twhere j.MKID='{$MKID}' {$tahunstring} {$prodistring} and j.KodeID='" . KodeID . "'";
$r = _query($s);
$w = _fetch_array($r);
$w['TglTatapMuka1'] = date('Y-m-d') . " 00:00:00";
$w['AkhirTglTatapMuka1'] = date('Y-m-d') . " 00:00:00";
$w['TglTatapMuka2'] = date('Y-m-d') . " 00:00:00";
$w['AkhirTglTatapMuka2'] = date('Y-m-d') . " 00:00:00";
$w['TglUjian'] = date('Y-m-d') . " 00:00:00";
$w['AkhirTglUjian'] = date('Y-m-d') . " 00:00:00";
//$gos = 'JadwalRemedialSav';
} else {
$s = "select jd.*, d.Nama as _Dosen \r\n\t\t\tfrom jadwalremedial jd left outer join dosen d on jd.DosenID=d.Login and jd.KodeID=d.KodeID\r\n\t\t\twhere jd.KodeID='" . KodeID . "' and jd.JadwalRemedialID='{$JadwalRemedialID}'";
$r = _query($s);
$w = _fetch_array($r);
//$gos = 'RemedialSav';
}
$tglTatap1 = GetDateOption($w['TglTatapMuka1'], 'TglTatapMuka1');
$tempjamtatap1 = substr($w['TglTatapMuka1'], 11, 5);
$jamTatap1 = GetTimeOption($tempjamtatap1, 'TglTatapMuka1');
$tempakhirjamtatap1 = substr($w['AkhirTglTatapMuka1'], 11, 5);
$akhirjamTatap1 = GetTimeOption($tempakhirjamtatap1, 'AkhirTglTatapMuka1');
$tglTatap2 = GetDateOption($w['TglTatapMuka2'], 'TglTatapMuka2');
$tempjamtatap2 = substr($w['TglTatapMuka2'], 11, 5);
$jamTatap2 = GetTimeOption($tempjamtatap2, 'TglTatapMuka2');
$tempakhirjamtatap2 = substr($w['AkhirTglTatapMuka2'], 11, 5);
$akhirjamTatap2 = GetTimeOption($tempakhirjamtatap2, 'AkhirTglTatapMuka2');
$tglUjian = GetDateOption($w['TglUjian'], 'TglUjian');
$tempjamUjian = substr($w['TglUjian'], 11, 5);
$jamUjian = GetTimeOption($tempjamUjian, 'TglUjian');
$tempakhirjamujian = substr($w['AkhirTglUjian'], 11, 5);
$akhirjamUjian = GetTimeOption($tempakhirjamujian, 'AkhirTglUjian');
$optruangtatap1 = GetOption2('ruang', 'RuangID', 'RuangID', $w['RuangIDTatapMuka1'], "KodeID='" . KodeID . "'", 'RuangID');
$optruangtatap2 = GetOption2('ruang', 'RuangID', 'RuangID', $w['RuangIDTatapMuka2'], "KodeID='" . KodeID . "'", 'RuangID');
$optruangujian = GetOption2('ruang', 'RuangID', 'RuangID', $w['RuangIDUjian'], "KodeID='" . KodeID . "'", 'RuangID');
$optdosen = GetOption2('dosen', 'Nama', 'Nama', $w['DosenID'], "KodeID='" . KodeID . "' and INSTR(ProdiID, '.{$w['ProdiID']}.')>0", 'Login');
CheckDatesScript();
echo "<table class=box cellspacing=1 align=center width=800>\r\n\t\t\t<form name='rem_form' action='?' method=POST onSubmit=\"return CheckHours(this)\">\r\n\t\t\t\t<input type=hidden name='gos' value='JadwalRemedialSav' \\>\r\n\t\t\t\t<input type=hidden name='JRID' value='{$JadwalRemedialID}' \\>\r\n\t\t\t\t<input type=hidden name='MKID' value='{$_REQUEST['MKID']}' \\>\r\n\t\t\t\t<input type=hidden name='TahunID' value='{$_SESSION['TahunID']}' \\>\r\n\t\t\t\t<input type=hidden name='ProdiID' value='{$w['ProdiID']}' \\>\r\n\t\t\t\t<input type=hidden name='RemTahunID' value='{$_SESSION['_remedialTahunID']}' \\>\r\n\t\t\t\t\r\n\t\t\t\t<tr><td colspan=4><hr color=green size=2></hr></td><tr>\t\r\n\t\t\t\t<tr><td class=inp>Mata Kuliah:</td>\r\n\t\t\t\t\t<td class=ul1>{$w['MKKode']} - {$w['Nama']}</td>\r\n\t\t\t\t\t<td class=inp>SKS</td>\r\n\t\t\t\t\t<td class=ul1>{$w['SKS']}</td></tr>\r\n\t\t\t\t<tr><td class=inp width=100>Thn Akademik:</td>\r\n\t\t\t\t\t<td class=ul1 width=300>{$w['TahunID']}</td>\r\n\t\t\t\t\t<td class=inp width=100>Program Studi:</td>\r\n\t\t\t\t\t<td class=ul1 width=300>{$w['ProdiID']} - {$w['ProgramID']}</td></tr>\r\n\t\t\t\t<tr><td colspan=4><hr color=green size=2></hr></td><tr>\t\r\n\t\t\t\t<tr><td class=inp>Dosen Remedial:</td>\r\n\t\t\t\t\t<td class=ul1><select name='DosenID'>{$optdosen}</select></td></tr>\t\t\r\n\t\t\t\t<tr><td class=inp>Tanggal Kuliah:</td>\r\n\t\t\t\t\t<td class=ul1>{$tglTatap1}</td>\r\n\t\t\t\t\t<td class=ul1><font color=green>&</font></td>\r\n\t\t\t\t\t<td class=ul1>{$tglTatap2}</td></tr>\r\n\t\t\t\t<tr><td class=inp>Jam Kuliah:</td>\r\n\t\t\t\t\t<td class=ul1>{$jamTatap1} - {$akhirjamTatap1}</td>\r\n\t\t\t\t\t<td class=inp></td>\r\n\t\t\t\t\t<td class=ul1>{$jamTatap2} - {$akhirjamTatap2}</td></tr>\r\n\t\t\t\t<tr><td class=inp>Ruang Kuliah:</td>\r\n\t\t\t\t\t<td class=ul1><select name='RuangTatap1'>{$optruangtatap1}</select></td>\r\n\t\t\t\t\t<td class=inp></td>\r\n\t\t\t\t\t<td class=ul1><select name='RuangTatap2'>{$optruangtatap2}</select></td></tr>\r\n\t\t\t\t<tr><td class=inp>Tanggal Ujian:</td>\r\n\t\t\t\t\t<td class=ul1>{$tglUjian}</td></tr>\r\n\t\t\t\t<tr><td class=inp>Jam Ujian:</td>\r\n\t\t\t\t\t<td class=ul1>{$jamUjian} - {$akhirjamUjian}</td></tr>\r\n\t\t\t\t<tr><td class=inp>Ruang Ujian:</td>\r\n\t\t\t\t\t<td class=ul1><select name='RuangUjian'>{$optruangujian}</td></tr>\r\n\t\t\t\t<tr><td colspan=4><hr color=green size=2></hr></td><tr>";
if ($JadwalRemedialID == 0) {
echo "\t\t<tr><td colspan=4 align=center><input type=submit name='Simpan' value='Simpan dan Proses Remedial'>\r\n\t\t\t\t\t\t\t\t <input type=button name='Batal' value='Batal' onClick=\"self.close()\"</td></tr>";
echo "\t</form>\r\n\t\t</table>";
} else {
echo "\t\t<tr><td colspan=4 align=center><input type=submit name='Simpan' value='Simpan Jadwal'></td></tr>";
echo "\t</form>\r\n\t\t\t</table>";
loadJavaScripts();
echo "\r\n\t\t\t<table class=box cellspacing=1 align=center width=800>\r\n\t\t\t <form action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='gos' value='RemedialSav' \\>\r\n\t\t\t\t<input type=hidden name='JRID' value='{$JadwalRemedialID}' \\>\r\n\t\t\t\t<input type=hidden name='MKID' value='{$_REQUEST['MKID']}' \\>\r\n\t\t\t\t<input type=hidden name='TahunID' value='{$_SESSION['TahunID']}' \\>\r\n\t\t\t\t<input type=hidden name='ProdiID' value='{$_SESSION['_remedialProdiID']}' \\>\r\n\t\t\t\t<input type=hidden name='RemTahunID' value='{$_SESSION['_remedialTahunID']}' \\>\r\n\t\t\t <tr><td width=800>\r\n\t\t\t\t<table class=box cellspacing=1 align=center border=1 width=650>\r\n\t\t\t\t<tr><th class=ttl width=20>#</th>\r\n\t\t\t\t\t<th class=ttl width=80>NIM</th>\r\n\t\t\t\t\t<th class=ttl width>Nama</th>\r\n\t\t\t\t\t<th class=ttl width=50>Tahun</th>\r\n\t\t\t\t\t<th class=ttl width=200>Dosen MK</th>\r\n\t\t\t\t\t<th class=ttl width=30>Grade</th>\r\n\t\t\t\t\t<th class=ttl width=20>Check</th>\r\n\t\t\t\t";
$s1 = "select a.MhswID, m.Nama, a.RemedialID, d.Nama as _Dosen, a.TahunID as _Tahun, a.KRSID, a.GradeNilai, r.Final, r.RemedialSet \r\n\t\t\t\t\t\t\t\t from krs a \r\n\t\t\t\t\t\t\t\t\t\tleft outer join khs b on a.KHSID=b.KHSID and a.KodeID=b.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join mhsw m on m.MhswID=a.MhswID and a.KodeID=m.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join jadwal j on a.JadwalID=j.JadwalID and a.KodeID=j.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join dosen d on j.DosenID=d.Login and a.KodeID=d.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join remedial r on a.RemedialID=r.RemedialID\r\n\t\t\twhere (a.GradeNilai='D' or a.GradeNilai='E') and a.TidakLengkap='N' and a.Final='Y' and a.KodeID='" . KodeID . "' and a.MKID='{$MKID}'\r\n\t\t\t\tand (r.TahunID='{$_SESSION['_remedialTahunID']}' or r.TahunID is NULL)\r\n\t\t\t\torder by a.Nama\r\n\t\t\t";
$r1 = _query($s1);
$counting = 0;
while ($w1 = _fetch_array($r1)) {
$counting++;
$check = empty($w1['RemedialID']) ? '' : 'checked';
$disabled = ($w1['Final'] == 'Y' or $w1['RemedialSet'] == 'Y') ? 'disabled' : '';
$grade = empty($w1['GradeNilai']) ? '-' : $w1['GradeNilai'];
echo "<tr><td>{$counting}.</td>\r\n\t\t\t\t\t<td>{$w1['MhswID']}</td>\r\n\t\t\t\t\t<td>{$w1['Nama']}</td>\r\n\t\t\t\t\t<td align=center>{$w1['_Tahun']}</td>\r\n\t\t\t\t\t<td>{$w1['_Dosen']}</td>\r\n\t\t\t\t\t<td align=center>{$w1['GradeNilai']}</td>\r\n\t\t\t\t\t<td align=center><input type=checkbox id='Norm{$counting}' name='Pilihan[]' value='{$w1['KRSID']}' {$check} {$disabled}>\r\n\t\t\t\t\t\t\t\t\t <input type=hidden name='SemuaPilihan[]' value='{$w1['KRSID']}'></td>\r\n\t\t\t\t\t </td></tr>";
}
$s1 = "select r.MhswID, m.Nama, r.RemedialID, d.Nama as _Dosen, r.TahunID as _Tahun, r.KRSID, r.GradeNilai, \r\n\t\t\t\t\tr.RemedialLanjutanID, r2.Final, r2.RemedialSet\r\n\t\t\t\t\t\t\t\t from remedial r\r\n\t\t\t\t\t\t\t\t\t\tleft outer join krs k on r.KRSID=k.KRSID and r.KodeID=k.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join mhsw m on m.MhswID=r.MhswID and r.KodeID=m.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join jadwalremedial jd on jd.JadwalRemedialID=r.JadwalRemedialID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join dosen d on jd.DosenID=d.Login and r.KodeID=d.KodeID\r\n\t\t\t\t\t\t\t\t\t\tleft outer join remedial r2 on r.RemedialLanjutanID=r2.RemedialID\r\n\t\t\twhere (r.GradeNilai='D' or r.GradeNilai='E') and r.Final='Y' and r.RemedialLanjutanID=0 and r.KodeID='" . KodeID . "' and k.MKID='{$MKID}'\r\n\t\t\t\tand (r.TahunID!='{$_SESSION['_remedialTahunID']}')\r\n\t\t\t\torder by m.Nama\r\n\t\t\t";
$countNORM = $counting;
$countREM = 0;
$r1 = _query($s1);
while ($w1 = _fetch_array($r1)) {
$counting++;
$countREM++;
$check = $w1['RemedialLanjutanID'] == 0 ? '' : 'checked';
$disabled = ($w1['Final'] == 'Y' or $w1['RemedialSet'] == 'Y') ? 'disabled' : '';
$grade = empty($w1['GradeNilai']) ? '-' : $w1[GradeNilai];
echo "<tr><td>{$counting}.</td>\r\n\t\t\t\t\t<td>{$w1['MhswID']}</td>\r\n\t\t\t\t\t<td>{$w1['Nama']}(REM)</td>\r\n\t\t\t\t\t<td align=center>{$w1['_Tahun']}</td>\r\n\t\t\t\t\t<td>{$w1['_Dosen']}</td>\r\n\t\t\t\t\t<td align=center>{$w1['GradeNilai']}</td>\r\n\t\t\t\t\t<td align=center><input type=checkbox id='Rem{$countREM}' name='PilihanRem[]' value='{$w1['RemedialID']}' {$check} {$disabled}>\r\n\t\t\t\t\t\t\t\t\t <input type=hidden name='SemuaPilihanRem[]' value='{$w1['RemedialID']}'></td>\r\n\t\t\t\t\t </td></tr>";
}
echo "\t\t</table></td></tr>";
echo "\t\t<tr><td colspan=4 align=center><input type=button name='SubmitButton' value='Simpan' onClick=\"ignoreCheckBoxDisable('Norm', 'Rem', this.form)\" />\r\n\t\t\t\t\t\t\t\t <input type=button name='Batal' value='Batal' onClick=\"self.close()\" />\r\n\t\t\t\t\t\t\t\t <input type=hidden id='JumlahNorm' name='JumlahNorm' value='{$countNORM}' >\r\n\t\t\t\t\t\t\t\t <input type=hidden id='JumlahRem' name='JumlahRem' value='{$countREM}' >\r\n\t\t\t\t\t\t\t\t </td></tr></table>";
}
}
function ListKelas()
{
loadJavaScripts();
$opttahun = GetOption2('tahun', "TahunID", 'TahunID', $_SESSION['opk_tahun'], '', 'TahunID');
$commonwidth = 25;
$kelaminwidth = 3 * $commonwidth;
$prodiwidth = $n * $commonwidth;
$nilaiwidth = 2 * $commonwidth;
$s = "select ProdiID, Nama from prodi where KodeID='" . KodeID . "' order by ProdiID";
$r = _query($s);
$n = _num_rows($r);
while ($w = _fetch_array($r)) {
$prodititle .= "<th class=ttl width={$commonwidth}>{$w['ProdiID']}</th>";
}
$ss = "select * from kelas where TahunID='{$_SESSION['opk_tahun']}' and KodeID='" . KodeID . "' order by Nama";
$rr = _query($ss);
$nn = _num_rows($rr) + 2;
// Total statistik berdasarkan kelamin
$s1 = "select m.MhswID, m.Kelamin\r\n\t\t\t\tfrom mhsw m left outer join kelas mk on m.KelasID=mk.KelasID \r\n\t\t\t\twhere m.KodeID='" . KodeID . "' and mk.KodeID='" . KodeID . "' and mk.TahunID='{$_SESSION['opk_tahun']}'";
$r1 = _query($s1);
$pria = 0;
$wanita = 0;
$nogender = 0;
while ($w1 = _fetch_array($r1)) {
if ($w1['Kelamin'] == 'P') {
$pria++;
} else {
if ($w1['Kelamin'] == 'W') {
$wanita++;
} else {
$nogender++;
}
}
}
// Total statistik berdasarkan prodi
$s1 = "select p.ProdiID, count(m.ProdiID) as _count from prodi p \r\n\t\t\t\tleft outer join mhsw m on p.ProdiID=m.ProdiID\r\n\t\t\t\tleft outer join kelas mk on m.KelasID=mk.KelasID\r\n\t\t\t\twhere m.KodeID='" . KodeID . "' and mk.KodeID='" . KodeID . "' and p.KodeID='" . KodeID . "' and mk.TahunID='{$_SESSION['opk_tahun']}' group by m.ProdiID";
$r1 = _query($s1);
$w1 = _fetch_array($r1);
$r = _query($s);
$prodistring = '';
while ($w = _fetch_array($r)) {
if ($w1['ProdiID'] == $w['ProdiID']) {
$prodistring .= "{$w['ProdiID']}: <b>{$w1['_count']}</b> • ";
$w1 = _fetch_array($r1);
} else {
$prodistring .= "{$w['ProdiID']}: <b>0</b> • ";
}
}
// Total statistik berdasarkan nilai
$s1 = "select MhswID, NilaiUjian \r\n\t\t\t\tfrom mhsw m left outer join kelas mk on m.KelasID=mk.KelasID\r\n\t\t\t\twhere mk.TahunID='{$_SESSION['opk_tahun']}' and m.KodeID='" . KodeID . "' and mk.KodeID='" . KodeID . "'";
$r1 = _query($s1);
$n1 = _num_rows($r1);
$total = 0;
while ($w1 = _fetch_array($r1)) {
$total += $w1['NilaiUjian'];
}
$average = $n1 == 0 ? 0 : number_format($total / $n1, 2);
// Make the title names
echo "<table class=box cellspacing=1 align=center width=800>\r\n\t\t\t<form action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}' />\r\n\t\t\t\t<input type=hidden name='gos' value='' />\r\n\t\t\t\t\r\n\t\t\t\t<tr><td class=inp>Tahun Akademik:</td>\r\n\t\t\t\t\t<td class=ul1><input type=text name='opk_tahun' value='{$_SESSION['opk_tahun']}' size=3 maxlength=10>\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=submit name='Set' value='Set'></td></tr>\r\n\t\t\t</form>\r\n\t\t </table>\r\n\t\t \r\n\t\t <table class=box cellspacing=1 align=center width=800>\r\n\t\t\t\t<input type=hidden name='gos' value='' />\r\n\t\t\t\t\r\n\t\t\t\t<tr><td class=ul1 align=center colspan=10><font color=green><b>STATISTIK TOTAL SELURUH KELAS:</b><font></td></tr>\r\n\t\t\t\t<tr><td class=inp>Total Peserta:</td>\r\n\t\t\t\t\t<td class=ul1><b>{$n1}</b></td>\r\n\t\t\t\t<tr><td class=inp>Berdasarkan Kelamin:</td>\r\n\t\t\t\t\t<td class=ul1>Pria: <b>{$pria}</b> • Wanita: <b>{$wanita}</b></td></tr>\r\n\t\t\t\t<tr><td class=inp>Berdasarkan Prodi:</td>\r\n\t\t\t\t\t<td class=ul1>{$prodistring}</td></tr>\r\n\t\t\t\t<tr><td class=inp>Berdasarkan Nilai:</td>\r\n\t\t\t\t\t<td class=ul1>Total Nilai: <b>{$total}</b> • Rata-rata Nilai: <b>{$average}</b></td></tr> \r\n\t\t</table>\t\t\t\t\t\t\t\r\n\t\t\t\r\n\t\t<table class=box cellspacing=1 align=center width=800>\r\n\t\t\t\t<tr><td>{$nbsp}</td></tr>\r\n\t\t\t\t<tr><th class=ttl rowspan=2 width=15>#</th>\r\n\t\t\t\t\t<th class=ttl rowspan=2 width=80>Nama Kelas</th>\r\n\t\t\t\t\t<th class=ttl rowspan=2 width=30>Kapasitas Sekarang</th>\r\n\t\t\t\t\t<th class=ttl rowspan=2 width=30>Kapasitas Maksimum</th>\r\n\t\t\t\t\t<td rowspan={$nn} width=5> </th>\r\n\t\t\t\t\t<th class=ttl colspan=3 width={$kelaminwidth}>Berdasarkan Kelamin</th>\r\n\t\t\t\t\t<td rowspan={$nn} width=5> </th>\r\n\t\t\t\t\t<th class=ttl colspan={$n} width={$prodiwidth}>Berdasarkan Program Studi</th>\r\n\t\t\t\t\t<td rowspan={$nn} width=5> </th>\r\n\t\t\t\t\t<th class=ttl colspan=2 width={$nilaiwidth}>Berdasarkan Nilai</th>\r\n\t\t\t\t\t<td rowspan={$nn} width=5> </th>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<th class=ttl width={$commonwidth}><img src='../img/P.bmp'></img></th>\r\n\t\t\t\t\t<th class=ttl width={$commonwidth}><img src='../img/W.bmp'></img></th>\r\n\t\t\t\t\t<th class=ttl width={$commonwidth}>×</th>\r\n\t\t\t\t\t{$prodititle}\r\n\t\t\t\t\t<th class=ttl width={$commonwidth}>Total</th>\r\n\t\t\t\t\t<th class=ttl width={$commonwidth}>Rata2</th>\r\n\t\t\t\t</tr>";
$counting = 0;
// Fill the table
while ($ww = _fetch_array($rr)) {
$counting++;
echo "<tr>\r\n\t\t\t\t<td class=ul1 align=right><a href='#' onClick=\"javascript:fnEditKelas(0, {$ww['KelasID']})\" />\r\n\t\t\t\t\t<img title='Edit Kelas' src='../img/edit.png' /></a> {$counting}.</td>\r\n\t\t\t\t<td class=ul1>{$ww['Nama']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$ww['KapasitasSekarang']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$ww['KapasitasMaksimum']}</td>";
$s1 = "select MhswID, Kelamin from mhsw where KelasID='{$ww['KelasID']}' and KodeID='" . KodeID . "'";
$r1 = _query($s1);
$pria = 0;
$wanita = 0;
$nogender = 0;
while ($w1 = _fetch_array($r1)) {
if ($w1['Kelamin'] == 'P') {
$pria++;
} else {
if ($w1['Kelamin'] == 'W') {
$wanita++;
} else {
$nogender++;
}
}
}
echo " <td class=ul1 align=center>{$pria}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$wanita}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$nogender}</td>";
$s1 = "select m.ProdiID, p.Nama, count(m.ProdiID) as _count \r\n\t\t\t\t\tfrom prodi p left outer join mhsw m on m.ProdiID=p.ProdiID\r\n\t\t\t\twhere m.KelasID='{$ww['KelasID']}' and m.KodeID='" . KodeID . "' and p.KodeID='" . KodeID . "' group by p.ProdiID order by p.ProdiID";
$r1 = _query($s1);
$r = _query($s);
$w1 = _fetch_array($r1);
while ($w = _fetch_array($r)) {
if ($w1['ProdiID'] == $w['ProdiID']) {
echo "<td class=ul1 align=center>{$w1['_count']}</td>";
$w1 = _fetch_array($r1);
} else {
echo "<td class=ul1 align=center>0</td>";
}
}
$s2 = "select MhswID, NilaiUjian from mhsw where KelasID='{$ww['KelasID']}' and KodeID='" . KodeID . "'";
$r2 = _query($s2);
$n2 = _num_rows($r2);
$total = 0;
while ($w2 = _fetch_array($r2)) {
$total += $w2['NilaiUjian'];
}
echo "<td class=ul1 align=center>{$total}</td>";
$average = $n2 == 0 ? 0 : number_format($total / $n2, 2);
echo "<td class=ul1 align=center>{$average}</td>";
echo "</tr>";
//echo "<td class=ul1 align=center><img src='../img/book$ww[NA].gif' /></td>";
}
echo "\t <tr><td class=ul1 colspan=20 align=center><input type=button name='Kembali' value='Kembali' onClick=\"self.close()\" ></td></tr>\r\n\t\t <table>";
}
