function DaftarGagal()
{
include_once "../sisfokampus1.php";
HeaderSisfoKampus("Laporan Daftar Gagal Remedial Mahasiswa");
TampilkanJudul("Laporan Daftar Gagal Remedial Mahasiswa");
$tahunstring = empty($_SESSION['_remedialTahunID']) ? "" : "and r.TahunID='{$_SESSION['_remedialTahunID']}'";
$prodistring = empty($_SESSION['_remedialProdiID']) ? "" : "and mk.ProdiID='{$_SESSION['_remedialProdiID']}'";
$s = "select r.MhswID, r.TahunID, m.Nama, jd.MKKode, jd.Nama as _MKNama, jd.SKS, r.GradeNilai, r.BobotNilai\r\n\t\t\tfrom krsremedial r left outer join mhsw m on r.MhswID=m.MhswID and r.KodeID=m.KodeID\r\n\t\t\t\t\t\t\tleft outer join jadwalremedial jd on r.JadwalRemedialID=jd.JadwalRemedialID and r.KodeID=jd.KodeID\r\n\t\t\t\t\t\t\tleft outer join mk on mk.MKID=jd.MKID and mk.KodeID=r.KodeID\r\n\t\t\twhere r.Final='Y' and (r.GradeNilai = 'D' or r.GradeNilai = 'E') {$tahunstring} {$prodistring} and r.KodeID='" . KodeID . "' \r\n\t\t\torder by m.MhswID";
$r = _query($s);
$n = _num_rows($r);
echo "<table class=box cellspacing=1 align=center width=700>\r\n\t\t\t<form name='rem_form' action='?' method=POST onSubmit=\"\">\r\n\t\t\t\t<input type=hidden name='gos' value='CetakLaporanRemedialMahasiswa' \\>\r\n\t\t\t\t<input type=hidden name='TahunID' value='{$_SESSION['_remedialTahunID']}' \\>\r\n\t\t\t\t<input type=hidden name='ProdiID' value='{$_SESSION['_remedialProdiID']}' \\>\r\n\t\t\t\t\r\n\t\t\t\t<tr><td colspan=10 align=center>\r\n\t\t\t\t\t\t\t\t\t<input type=button name='Batal' value='Tutup' onClick=\"self.close()\" ></td></tr>\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=200>Nama</th>\r\n\t\t\t\t\t<th class=ttl width=>Mata Kuliah</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=40>Grade</th>\r\n\t\t\t\t\t<th class=ttl width=40>Bobot</th></tr>";
$count = 0;
$curID = '1knckosjkdfo2skdkj';
while ($w = _fetch_array($r)) {
$MhswID = '';
$Nama = '';
$counting = '';
$gantibaris = '';
if ($curID != $w['MhswID']) {
$MhswID = $w['MhswID'];
$Nama = $w['Nama'];
$curID = $MhswID;
$count++;
$counting = $count . ".";
$gantibaris = $count != 1 ? '<tr><td colspan=10><hr color=green size=1></hr></td></tr>' : '';
}
echo "\t{$gantibaris}\r\n\t\t\t\t<tr><td class=ul1 align=center>{$counting}</td>\r\n\t\t\t\t\t<td class=ul1>{$MhswID}</td>\r\n\t\t\t\t\t<td class=ul1>{$Nama}</td>\r\n\t\t\t\t\t<td class=ul1>{$w['_MKNama']}<sup>{$w['MKKode']}</sup></td>\r\n\t\t\t\t\t<td class=ul1 align=center>{$w['SKS']}</td>\r\n\t\t\t\t\t<td class=ul1>{$w['GradeNilai']}</td>\r\n\t\t\t\t\t<td class=ul1>{$w['BobotNilai']}</td>\r\n\t\t\t\t\t";
}
echo "\t</form>\r\n\t\t</table></p>";
}
function berhasil()
{
global $_ProductName, $_Version, $arrID;
// Tampilkan welcome
TampilkanJudul("Selamat Datang");
echo Konfirmasi("{$arrID['Nama']}", "<table class=bsc cellspacing=1 width=100%>\r\n <tr>\r\n <td class=ul1 colspan=2 nowrap>Selamat datang di {$_ProductName} - {$arrID['Nama']}</td>\r\n </tr>\r\n <tr>\r\n <td class=inp>Nama :</td>\r\n <td class=ul1><b>{$_SESSION['_Nama']}</b></td>\r\n </tr> \r\n <tr>\r\n <td class=inp>Pilihan:</td>\r\n <td class=ul1>\r\n <input type=button name='Logout' value='Logout' onClick=\"location='?mnux=loginprc&gos=lout'\" />\r\n </td>\r\n </tr>\r\n </table>");
}
function Edit($MhswID, $KHSID, $md, $BayarID)
{
$mhsw = GetFields('mhsw', "KodeID='" . KodeID . "' and MhswID", $MhswID, '*');
$khs = GetFields('khs', 'KHSID', $KHSID, '*');
if ($md == 0) {
$jdl = "Edit Pembayaran";
$w = GetFields('bayarmhsw', 'BayarMhswID', $BayarID, '*');
} elseif ($md == 1) {
$jdl = "Tambah Penarikan";
$w = array();
$rekening_def = GetaField('rekening', "Def = 'Y' and NA", 'N', 'RekeningID');
$w['RekeningID'] = $rekening_def;
$w['Tanggal'] = date('Y-m-d');
} else {
die(ErrorMsg('Error', "Mode edit <b>{$md}</b> tidak dikenali.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
}
// Tampilkan
BayarScript();
CheckFormScript('RekeningID,Bank');
$optrek = GetOption2('rekening', "concat(RekeningID, ' - ', Nama)", 'RekeningID', $w['RekeningID'], "KodeID='" . KodeID . "'", 'RekeningID');
$optTanggal = GetDateOption($w['Tanggal'], 'Tanggal');
TampilkanJudul($jdl);
echo "\r\n <table class=box cellspacing=1 width=100%>\r\n <form name='frmBayar' action='../{$_SESSION['mnux']}.tarik.php' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='MhswID' value='{$MhswID}' />\r\n <input type=hidden name='KHSID' value='{$KHSID}' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='BayarID' value='{$BayarID}' />\r\n \r\n <tr><td class=inp>Ditarik oleh:</td>\r\n <td class=ul1 colspan=3>\r\n <font size=+1>{$mhsw['Nama']}</font> <sup>(NIM: {$MhswID})</sup>\r\n </td>\r\n </tr>\r\n <tr><td class=inp>Dari Rekening:</td>\r\n <td class=ul1><select name='RekeningID'>{$optrek}</select></td>\r\n <td class=inp>Tgl Setor:</td>\r\n <td class=ul1>{$optTanggal}</td>\r\n </tr>\r\n <tr><td class=inp>Ditarik Dari:</td>\r\n <td class=ul1><input type=text name='Bank' value='{$w['Bank']}' size=30 maxlength=50 /> <a href='#' onClick=\"javascript:SetCash()\">Set CASH</a><br />\r\n <sup>Isi dengan `CASH` bila dibayarkan dengan Tunai</sup>\r\n </td>\r\n <td class=inp>No. Bukti Tarik:</td>\r\n <td class=ul1><input type=text name='BuktiSetoran' value='{$w['BuktiSetoran']}'\r\n size=30 maxlength=50 /><br />\r\n <sup>Kosongkan jika pembayaran cash</sup>\r\n </td>\r\n </tr>\r\n <tr><td class=inp>Catatan:</td>\r\n <td class=ul1 colspan=3><input type=text name='Keterangan' value='{$w['Keterangan']}'\r\n size=90 maxlength=50 />\r\n </td>\r\n </tr>\r\n </table>";
TampilkanDetailBiaya($MhswID, $mhsw, $khs, $md);
}
function Edit($md, $Kode, $bck)
{
if ($md == 0) {
$jdl = "Edit Komponen";
$w = GetFields('pmbusm', "KodeID='" . KodeID . "' and PMBUSMID", $Kode, "*");
$_usm = "<input type=hidden name='Kode' value='{$w['PMBUSMID']}' /><b>{$w['PMBUSMID']}</b>";
} elseif ($md == 1) {
$jdl = "Tambah Komponen";
$w = array();
$w['NA'] = 'N';
$_usm = "<input type=text name='Kode' size=10 maxlength=10 />";
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$na = $w['NA'] == 'Y' ? 'checked' : '';
if (empty($w['CaraPenempatan'])) {
$Urut = 'checked';
} else {
$Urut = $w['CaraPenempatan'] == 'Urut' ? 'checked' : '';
$Acak = $w['CaraPenempatan'] == 'Acak' ? 'checked' : '';
$Manual = $w['CaraPenempatan'] == 'Manual' ? 'checked' : '';
}
CheckFormScript('Kode,Nama');
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\n <form action='../{$_SESSION['mnux']}.usm.edit.php' method=POST onSubmit='return CheckForm(this)'>\n <input type=hidden name='gos' value='Simpan' />\n <input type=hidden name='md' value='{$md}' />\n <input type=hidden name='bck' value='{$bck}' />\n \n <tr><td class=inp>Kode USM:</td>\n <td class=ul1>{$_usm}</td>\n </tr>\n <tr><td class=inp>Nama Ujian:</td>\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}'\n size=30 maxlength=50 /></td>\n </tr>\r\n <tr><td class=inp>Cara Penempatan Cama:</td>\r\n\t <td class=ul1><input type=radio name='CaraPenempatan' value='Urut' {$Urut}>Urut\r\n\t\t\t\t<br><input type=radio name='CaraPenempatan' value='Acak' {$Acak}>Acak\r\n\t\t\t\t<br><input type=radio name='CaraPenempatan' value='Manual' {$Manual}>Manual</td>\r\n\t </tr>\n <tr><td class=inp>Keterangan:</td>\n <td class=ul1>\n <textarea name='Keterangan' cols=30 rows=4>{$w['Keterangan']}</textarea>\n </td></tr>\n <tr><td class=inp>NA (tidak aktif)?</td>\n <td class=ul1>\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\n </td>\n </tr>\n \n <tr><td class=ul1 colspan=2 align=center>\n <input type=submit name='Simpan' value='Simpan' />\n <input type=button name='Batal' value='Batal'\n onClick=\"window.close()\" />\n </td>\n </tr>\n </form>\n </table></p>";
}
function MKSTREDT($m)
{
$md = $_REQUEST['md'] + 0;
if ($md == 0) {
$w = GetFields('mhswpindahansetara', "KRSID", $_REQUEST['KRSID'], '*');
$jdl = "Edit Matakuliah yg Disetarakan";
} else {
$w = array();
$w['KRSID'] = 0;
$w['MhswPindahanID'] = $_SESSION['MPID'];
$w['TahunID'] = '00000';
$w['MKID'] = 0;
$w['MKKode'] = '';
$w['SKS'] = -1;
$w['GradeNilai'] = '';
$w['SetaraKode'] = '';
$w['SetaraGrade'] = '';
$w['SetaraNama'] = '';
$w['SetaraSKS'] = 0;
$w['NilaiAkhir'] = 0;
$jdl = "Tambah Matakuliah yg Disetarakan";
}
CheckFormScript('SetaraKode,SetaraGrade,SetaraNama');
TampilkanJudul($jdl);
$optn = GetOption2("nilai", "concat(Nama, ' (', Bobot, ')')", "Bobot desc", $w['GradeNilai'], "ProdiID='{$m['ProdiID']}'", 'Nama');
$kurid = GetaField('kurikulum', "NA='N' and ProdiID", $m['ProdiID'], 'KurikulumID');
$optm = GetOption2("mk", "concat(MKKode, ' - ', Nama, ' (', SKS, ')')", 'MKKode', $w['MKID'], "KurikulumID={$kurid}", 'MKID');
echo "<p><table class=box cellspacing=1>\r\n <form action='?' name='data' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='MKSTRSAV'>\r\n <input type=hidden name='md' value={$md}>\r\n <input type=hidden name='MPID' value='{$w['MhswPindahanID']}'>\r\n <input type=hidden name='KRSID' value='{$w['KRSID']}'>\r\n \r\n <tr><th class=ttl colspan=2>Matakuliah Asli</th>\r\n <th class=ul><img src='img/kanan.gif'></th>\r\n <th class=ttl colspan=2>Matakuliah {$_SESSION['KodeID']} (Setara)</th></tr>\r\n <tr><td class=inp>Kode Asli</td>\r\n <td class=ul><input type=text name='SetaraKode' value='{$w['SetaraKode']}' size=20 maxlength=30></td>\r\n <td class=ul><img src='img/kanan.gif'></td>\r\n <td class=inp>Kode MK</td>\r\n <td class=ul><select name='MKID'>{$optm}</select></td>\r\n </tr>\r\n <tr><td class=inp>Nama MK</td>\r\n <td class=ul><input type=text name='SetaraNama' value='{$w['SetaraNama']}' size=30 maxlength=50></td>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n </tr>\r\n <tr><td class=inp>SKS Asli</td>\r\n <td class=ul><input type=text name='SetaraSKS' value='{$w['SetaraSKS']}' size=10 maxlength=5>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n </tr>\r\n <tr><td class=inp>Nilai Asli</td>\r\n <td class=ul><input type=text name='NilaiAkhir' value='{$w['NilaiAkhir']}' size=10 maxlength=5>\r\n <td></td>\r\n <td></td>\r\n <td></td>\r\n </tr>\r\n <tr><td class=inp>Grade Nilai Asli</td>\r\n <td class=ul><input type=text name='SetaraGrade' value='{$w['SetaraGrade']}' size=10 maxlength=5>\r\n <td class=ul><img src='img/kanan.gif'></td>\r\n <td class=inp>Grade</td>\r\n <td class=ul><select name='GradeNilai'>{$optn}</select></td>\r\n </tr>\r\n <tr><td class=ul colspan=5>\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=pindahan.setara'\"></td></tr>\r\n </form></table></p>";
}
function Edit($md, $id, $bck)
{
if ($md == 0) {
$jdl = "Edit Formulir";
$w = GetFields('pmbformulir', "KodeID='" . KodeID . "' and PMBFormulirID", $id, "*");
} elseif ($md == 1) {
$jdl = "Tambah Formulir";
$w = array();
$w['JumlahPilihan'] = 1;
$w['USM'] = 'N';
$w['Wawancara'] = 'N';
$w['Prasyarat'] = 'N';
$w['NA'] = 'N';
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$optjml = GetNumberOption(1, 3, $w['JumlahPilihan']);
$na = $w['NA'] == 'Y' ? 'checked' : '';
$usmchecked = $w['USM'] == 'Y' ? 'checked' : '';
$wawancarachecked = $w['Wawancara'] == 'Y' ? 'checked' : '';
$prasyaratchecked = $w['Prasyarat'] == 'Y' ? 'checked' : '';
$prasyaratvisibility = $w['Prasyarat'] == 'Y' ? 'visible' : 'hidden';
$Prasyarat = GetPrasyarat($w['PrasyaratExtra']);
$webdefchecked = $w['WebDef'] == 'Y' ? 'checked' : '';
CheckFormScript('Nama,Harga');
//$TestMasuk = GetTestMasuk($w['USM']);
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\r\n <form action='../{$_SESSION['mnux']}.formulir.edit.php' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='id' value='{$id}' />\r\n <input type=hidden name='bck' value='{$bck}' />\r\n \r\n <tr><td class=inp>Formulir:</td>\r\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}'\r\n size=30 maxlength=50 />\r\n </td></tr>\r\n <tr><td class=inp>Jumlah Pilihan:</td>\r\n <td class=ul1><select name='JumlahPilihan'>{$optjml}</select></td>\r\n </tr>\r\n <tr><td class=inp>Harga:</td>\r\n <td class=ul1><input type=text name='Harga' value='{$w['Harga']}' size=10 maxlength=15 /></td>\r\n </tr>\r\n <tr><td class=inp>Ada USM?</td>\r\n <td class=ul1><input type=checkbox name='USM' value='Y' {$usmchecked}></td>\r\n </tr>\r\n <tr><td class=inp>Ada Wawancara?</td>\r\n\t <td class=ul1><input type=checkbox name='Wawancara' value='Y' {$wawancarachecked}></td>\r\n\t </tr>\r\n <tr><td class=inp>Ada Prasyarat?</td>\r\n\t <td class=ul1>\r\n\t <div style='float:left'><input type=checkbox name='Prasyarat' value='Y' {$prasyaratchecked} onClick=\"toggleDiv('PrasyaratPlus');\"></div>\r\n\t <div id='PrasyaratPlus' style='float:left; padding-left:15px; padding-right:15px; background-color:#DDDDDD; visibility:{$prasyaratvisibility};'>\r\n\t\t{$Prasyarat}\r\n\t </div>\r\n\t </td>\r\n\t </tr>\r\n <tr><td class=inp>Keterangan:</td>\r\n <td class=ul1>\r\n <textarea name='Keterangan' cols=30 rows=3>{$w['Keterangan']}</textarea>\r\n </td></tr>\r\n <tr><td class=inp>NA (tidak aktif)?</td>\r\n <td class=ul1>\r\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\r\n </td>\r\n </tr>\r\n \r\n <tr><td class=ul1 colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan' />\r\n <input type=button name='Batal' value='Batal'\r\n onClick=\"window.close()\" />\r\n </td>\r\n </tr>\r\n </form>\r\n </table></p>\r\n <script>\r\n\tfunction toggleDiv(name)\r\n\t{\tif(document.getElementById(name).style.visibility == 'hidden')\r\n\t\t\tdocument.getElementById(name).style.visibility = 'visible';\r\n\t\telse\r\n\t\t\tdocument.getElementById(name).style.visibility = 'hidden';\r\n\t}\r\n </script>";
}
function HalamanUtamaOPK()
{
TampilkanJudul("Pembagian Kelas");
TampilHeaderOPK();
echo "<Iframe name='frame1' src='{$_SESSION['mnux']}.frame1.php' align=left width=35.5% height=1500 frameborder=0></Iframe>";
echo "<Iframe name='frame2' src='{$_SESSION['mnux']}.frame2.php' align=right width=50.5% height=1500 frameborder=0></Iframe>";
}
function TampilkanHeader()
{
TampilkanJudul('Laporan Remedial Per Periode');
$prodiopt = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['_remedialProdiID'], "KodeID='".KodeID."'", 'ProdiID');
$p1 = (!empty($_REQUEST[periode1_y]))? $_REQUEST['periode1_y'].'-'.$_REQUEST['periode1_m'].'-'.$_REQUEST['periode1_d'] : date('Y-m-d');
$p2 = (!empty($_REQUEST[periode2_y]))? $_REQUEST['periode2_y'].'-'.$_REQUEST['periode2_m'].'-'.$_REQUEST['periode2_d'] : date('Y-m-d');
$periode1 = getDateOption($p1,'periode1');
$periode2 = getDateOption($p2,'periode2');
echo "<table class=box cellspacing=1 align=center width=800>
<form action='?' method=POST onSubmit=\"changePage(1, '$_SESSION[mnux]')\">
<input type=hidden name='gos' value=''>
<tr>
<td width=220><font color=green><b>Tahun Akademik: </b></font></td>
<td><input type=text name='TahunID' value='$_SESSION[TahunID]' size=4 maxlength=5 /></td>
</tr>
<tr>
<td><font color=green><b> Program Studi: </b></font></td>
<td><select name='_remedialProdiID'>$prodiopt</select\"></td>
</tr>
<tr>
<td><font color=green><b> Periode Remedial : </b></font></td>
<td>$periode1 s/d $periode2 <input type=submit name='Cari' value='Cari' ></td>
</tr>
</form>
</table>";
}
function Edit($md, $prd, $id)
{
$gelombang = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
if ($md == 0) {
$jdl = "Edit Wawancara USM";
$w = GetFields('wawancarausm', 'WawancaraUSMID', $id, '*');
} elseif ($md == 1) {
$jdl = "Tambah Wawancara";
$w = array();
$w['Tanggal'] = GetaField('pmbperiod', "KodeID='" . KodeID . "' and PMBPeriodID", $gelombang, 'UjianMulai');
$w['JamMulai'] = '09:00';
$w['JamSelesai'] = '09:50';
$w['PanjangWaktu'] = 0;
$w['Kapasitas'] = 0;
} else {
die(ErrorMsg('Error', "Terjadi kesalahan.<br />\r\n Mode edit <b>{$md}</b> tidak dikenali.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='Tutup' value='Tutup' onClick=\"window.close()\" />"));
}
// Tampilkan
TampilkanJudul($jdl);
$s1 = "select r.RuangID, r.KapasitasUjian, k.Nama as NamaKampus \r\n\t\t\tfrom ruang r left outer join kampus k on r.KampusID=k.KampusID\r\n\t\t\twhere r.UntukUSM = 'Y' \r\n\t\t\torder by r.KampusID, r.RuangID";
$r1 = _query($s1);
if (!empty($_SESSION['prodi'])) {
$gelombang = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
}
$jml = GetaField('pmb', "PMBPeriodID='{$gelombang}' and Pilihan1", $_SESSION['prodi'], "count(PMBID)");
$ruangopt = GetOption2('ruang', 'RuangID', 'RuangID', $w['RuangID'], "KodeID='" . KodeID . "'", 'RuangID');
$Tanggal = GetDateOption($w['Tanggal'], 'Tanggal');
$JamMulai = GetTimeOption($w['JamMulai'], 'JamMulai');
$JamSelesai = GetTimeOption($w['JamSelesai'], 'JamSelesai');
CheckFormScript('Ruang,Kapasitas,PanjangWaktu');
echo "<p><table class=bsc cellspacing=1 width=100%>\r\n <form name='wawancaraedit' action='../{$_SESSION['mnux']}.wawancarausm.edit.php' method=POST onSubmit='return CheckForm(this)'>\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='prd' value='{$prd}' />\r\n <input type=hidden name='id' value='{$id}' />\r\n <input type=hidden name='gos' value='Simpan' />\r\n \r\n <tr><td class=inp>Mata Uji:</td>\r\n <td class=ul1 colspan=3><input type=text name='xMataUji' value='Wawancara' disabled>\r\n\t\t\t\t\t\t\t <input type=hidden name='MataUji' value='Wawancara'></td>\r\n </tr>\r\n <tr><td class=inp>Tanggal Wawancara:</td>\r\n <td class=ul1 colspan=3>{$Tanggal}</td>\r\n </tr>\r\n <tr><td class=inp>Jam Wawancara:</td>\r\n <td class=ul1 colspan=3>{$JamMulai} s/d {$JamSelesai}</td>\r\n\t </tr>\r\n <tr><td class=inp>Panjang Waktu Wawancara:<br>(Per Cama)</td>\r\n\t <td class=ul1 colspan=3><input type=text name='PanjangWaktu' value='{$w['PanjangWaktu']}' size=2 maxlength=3 > menit \r\n\t\t\t<font color=red>*) Masukkan 0 untuk tidak ada pembatasan waktu</font></td>\r\n\t </tr>\r\n <tr><td class=inp>Kapasitas Cama:</td>\r\n <td class=ul1 colspan=3><input type=text name='Kapasitas' value='{$w['Kapasitas']}' size=2 maxlength=3 > orang \r\n\t\t\t<font color=red>*) Masukkan 0 untuk tidak ada pembatasan kuota</font></td>\r\n\t </tr>\r\n <tr><td class=inp>Ruang Wawancara:</td>\r\n\t <td class=ul1 colspan=3><select name='Ruang'>{$ruangopt}</select></td></tr>\r\n <tr><td class=ul1 colspan=4 align=center>\r\n <input type=submit name='Simpan' value='Simpan' onClick=\"return (CekJam() && CekPanjangWaktu()) \"/>\r\n <input type=button name='Batal' value='Batal' onClick=\"window.close()\" />\r\n </td></tr>\r\n </form>\r\n </table>\r\n <script>\r\n\tfunction CekJam()\r\n\t{\tcek = true;\r\n\t\tjammulai = wawancaraedit.JamMulai_h.value;\r\n\t\tmenitmulai = wawancaraedit.JamMulai_n.value;\r\n\t\tjamselesai = wawancaraedit.JamSelesai_h.value;\r\n\t\tmenitselesai = wawancaraedit.JamSelesai_n.value;\r\n\t\tif(jammulai > jamselesai)\r\n\t\t{\talert('Jam Mulai tidak boleh lebih telat dari atau sama dengan Jam Selesai');\r\n\t\t\tcek = false;\r\n\t\t}\r\n\t\telse if(jammulai == jamselesai)\r\n\t\t{\tif(menitmulai >= menitselesai)\r\n\t\t\t{\talert('Jam Mulai tidak boleh lebih telat dari atau sama dengan Jam Selesai');\r\n\t\t\t\tcek = false;\r\n\t\t\t}\r\n\t\t}\r\n\t\treturn cek;\r\n\t}\r\n\tfunction CekPanjangWaktu()\r\n\t{\tcek = true;\r\n\t\tjammulai = wawancaraedit.JamMulai_h.value;\r\n\t\tmenitmulai = wawancaraedit.JamMulai_n.value;\r\n\t\tjamselesai = wawancaraedit.JamSelesai_h.value;\r\n\t\tmenitselesai = wawancaraedit.JamSelesai_n.value;\r\n\t\tpanjangwaktu = wawancaraedit.PanjangWaktu.value;\r\n\t\t\r\n\t\trentangmenit = ((jamselesai - jammulai)*60)+(menitselesai-menitmulai);\r\n\t\tif(panjangwaktu > rentangmenit)\r\n\t\t{\talert('Panjang Waktu Wawancara tidak boleh lebih kecil dari selisih Jam Selesai dan Jam Mulai');\r\n\t\t\tcek = false;\r\n\t\t}\r\n\t\t\r\n\t\treturn cek;\r\n\t}\r\n </script>";
}
function EditKelas()
{
$md = $_REQUEST['md'] + 0;
$kid = $_REQUEST['kid'];
if ($md == 0) {
$jdl = 'Edit Kelas';
$w = GetFields('kelas', 'KelasID', $kid, '*');
$strkid = "\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Kelas ID: </td>\r\n\t\t\t\t<td class=ul1><input type=text name='dkid' value='{$kid}' size=2 disabled>\r\n\t\t\t\t\t\t\t<input type=hidden name='kid' value='{$kid}'></td>\t\t\t\t\r\n\t\t\t</tr>";
} else {
if ($md == 1) {
$jdl = 'Tambah Kelas';
$w = array();
$strkid = "";
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali. Hubungi Sysadmin untuk informasi lebih lanjut."));
}
}
TampilkanJudul($jdl);
echo "<br>";
$optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $w['ProdiID'], "KodeID='" . KodeID . "'", 'ProdiID');
$optprogram = GetOption2('program', "concat(ProgramID, ' - ', Nama)", 'ProgramID', $w['ProgramID'], "KodeID='" . KodeID . "'", 'ProgramID');
$opttahun = GetOption2('tahun', "concat(TahunID, ' (', ProdiID, if(ProdiID='','','-'), ProgramID, ')')", 'TahunID', $w['TahunID'], "NA='N'", 'TahunID');
CheckFormScript("InputNama,InputTahun,InputProdi,InputProgram,InputKapMax");
echo "<table class=box cellspacing=1 align=center>\r\n\t\t\t\t<form action='?' method=POST onSubmit=\"return CheckForm(this)\">\r\n\t\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}' />\r\n\t\t\t\t\t<input type=hidden name='gos' value='SavKelas' />\r\n\t\t\t\t\t<input type=hidden name='md' value='{$md}'/>\r\n\t\t\t\t\t<input type=hidden name='kid' value='{$kid}' />\r\n\t\t\t\t\t\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td class=inp>Nama Kelas:</td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputNama' value='{$w['Nama']}'></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 class=inp>Tahun Akademik:</td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputTahun' value='{$_SESSION['opk_tahun']}' size=3 maxlength=10></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 class=inp>Program Studi:</td>\r\n\t\t\t\t\t\t<td class=ul1><select name='InputProdi'>{$optprodi}</select></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 class=inp>Program:</td>\r\n\t\t\t\t\t\t<td class=ul1><select name='InputProgram'>{$optprogram}</select></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 class=inp>Kapasitas Maksimum Kelas: </td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputKapMax' value='{$w['KapasitasMaksimum']}' size=2 maxlength=4></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 class=ul1 colspan=2 align=center>\r\n\t\t\t\t\t\t\t<input type=submit name='SimpanKelas' value='Simpan Kelas' />\r\n\t\t\t\t\t\t\t<input type=reset name='Reset' value='Reset' />\r\n\t\t\t\t\t\t\t<input type=button name='Batal' value='Batal'\r\n\t\t\t\t\t\t\t\tonClick=\"self.close();\" /></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t</form>";
}
function berhasil()
{
include "atribut/header.php";
global $_ProductName, $_Version;
// Tampilkan welcome
TampilkanJudul("SISTEM INFORMASI JURUSAN PENDIDIKAN TEKNIK ELEKTRO UNIVERSITAS PENDIDIKAN INDONESIA");
echo Konfirmasi("Selamat Datang {$_SESSION['_Nama']}", "Anda Telah Login Sebagai :\n <hr size=5 color=green>\n <b><img src='{$_SESSION['_Foto']}'></b><br>\n Nama : <b>{$_SESSION['_Nama']}</b><br>\n\tID : <b>{$_SESSION['_Login']}</b><br>\n\t<hr size=5 color=green>\n Session : {$_SESSION['_Session']}\n <hr size=5 color=green>\n <a href='?slnt=loginprc&slntx=lout'><img src='img/keluar.png'></a>");
}
function Edit()
{
$md = $_REQUEST['md'] + 0;
$id = $_REQUEST['id'] + 0;
if ($md == 0) {
$jdl = "Edit Gelombang Wisuda";
$w = GetFields('wisuda', 'WisudaID', $id, '*');
} elseif ($md == 1) {
$jdl = "Tambah Gelombang Wisuda";
$w = array();
$w['TglMulai'] = date('Y-m-d');
$w['TglSelesai'] = date('Y-m-d');
$w['TglWisuda'] = date('Y-m-d');
} else {
die(ErrorMsg('Error', "Mode edit <b>{$md}</b> tidak dikenali.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n Opsi: <input type=button name='Tutup' value='Tutup'\r\n onClick='window.close()' />"));
}
// Tampilkan
TampilkanJudul($jdl);
$na = $w['NA'] == 'Y' ? 'checked' : '';
$TglMulai = GetDateOption($w['TglMulai'], 'TglMulai');
$TglSelesai = GetDateOption($w['TglSelesai'], 'TglSelesai');
$TglWisuda = GetDateOption($w['TglWisuda'], 'TglWisuda');
echo <<<ESD
<table class=bsc cellspacing=1 width=100%>
<form action='../{$_SESSION['mnux']}.edit.php' method=POST>
<input type=hidden name='md' value='{$md}' />
<input type=hidden name='id' value='{$id}' />
<input type=hidden name='gos' value='Simpan' />
<tr><td class=inp>Tahun/Gelombang:</td>
<td class=ul><input type=text name='TahunID' value='{$w['TahunID']}' size=5 maxlength=5 /></td>
</tr>
<tr><td class=inp>Keterangan:</td>
<td class=ul><input type=text name='Nama' value='{$w['Nama']}' size=30 maxlength=50 /></td>
</tr>
<tr><td class=inp>Mulai Pendaftaran:</td>
<td class=ul>{$TglMulai}</td>
</tr>
<tr><td class=inp>Akhir Pendaftaran:</td>
<td class=ul>{$TglSelesai}</td>
</tr>
<tr><td class=inp>Tanggal Wisuda:</td>
<td class=ul>{$TglWisuda}</td>
</tr>
<tr><td class=inp>Tidak Aktif? (NA)</td>
<td class=ul><input type=checkbox name='NA' value='Y' {$na} />
<font color=red> *) Centang bila tidak aktif.<br />
Hanya ada 1 gelombang yg aktif.</td>
</tr>
<tr><td class=ul colspan=2 align=center>
<input type=submit name='btnSimpan' value='Simpan' />
<input type=button name='Batal' value='Batal'
onClick="window.close()" />
</td></tr>
</form>
</table>
ESD;
}
function fnKonfirmasi($jid)
{
TampilkanJudul("Jadwalkan {$_SESSION['_jdwlU']}");
$w = GetFields('jadwal', 'JadwalID', $jid, '*');
$d = GetFields('dosen', "Login = '******'DosenID']}' and KodeID", KodeID, "Nama, Gelar");
$tgl = FormatTanggal($_SESSION['_jdwlTgl']);
echo <<<ESD
<table class=box width=100%>
<form name='frmUJIAN' action='../{$_SESSION['mnux']}.edit.php' method=POST>
<input type=hidden name='jid' value='{$jid}' />
<input type=hidden name='gos' value='fnSimpan' />
<input type=hidden name='_jdwlRuang' value='{$_SESSION['_jdwlRuang']}' />
<input type=hidden name='_jdwlTgl' value='{$_SESSION['_jdwlTgl']}' />
<input type=hidden name='_jdwlU' value='{$_SESSION['_jdwlU']}' />
<tr><td class=inp>Kode:</td>
<td class=ul>{$w['MKKode']} </td>
<td class=inp>Matakuliah:</td>
<td class=ul>{$w['Nama']} </td>
</tr>
<tr><td class=inp>SKS:</td>
<td class=ul>{$w['SKS']} <sup>sks</sup></td>
<td class=inp>Kelas:</td>
<td class=ul>{$w['NamaKelas']} </td>
</tr>
<tr><td class=inp>Prodi:</td>
<td class=ul>{$w['ProdiID']} <sup>{$w['ProgramID']}</sup></td>
<td class=inp>Dosen:</td>
<td class=ul>{$d['Nama']} <sup>{$d['Gelar']}</sup></td>
</tr>
<tr><th class=ttl colspan=4>Dijadwalkan Di:</th></tr>
<tr><td class=inp>Tanggal:</td>
<td class=ul>{$tgl}</td>
<td class=inp>Ruang:</td>
<td class=ul>{$_SESSION['_jdwlRuang']} </td>
</tr>
<tr><td class=inp>Jam Mulai:</td>
<td class=ul><input type=text name='JamMulai' size=5 maxlength=5 /></td>
<td class=inp>Selesai:</td>
<td class=ul><input type=text name='JamSelesai' size=5 maxlength=5 /></td>
</tr>
<tr><td class=ul colspan=4 align=center>
<input type=submit name='btnSimpan' value='Jadwalkan' />
<input type=button name='btnTutup' value='Tutup'
onClick="window.close()" />
</td></tr>
</form>
</table>
ESD;
}
function fnProses()
{
TampilkanJudul("Menvalidasi Tahun Mahasiswa");
$s = "select * from `krs` where left(MhswID, 4) > '2002' and (TahunID='0' or TahunID='' or TahunID IS NULL)";
$r = _query($s);
$x = 0;
echo "<table class=box align=center>";
echo "<tr align=center colspan=10><th>Tahun yang Kosong</tr>\r\n\t\t<tr><th class=ttl>No.</th>\r\n\t\t\t<th class=ttl>No. ID</th>\r\n\t\t\t<th class=ttl>Tahun</th>\r\n\t\t\t<th class=ttl>MkKode</th>\r\n\t\t\t<th class=ttl>KrsID</th>\r\n\t\t</tr>";
while ($w = _fetch_array($r)) {
$x++;
echo "<tr>\r\n\t\t\t\t<td col=ul1>{$x}</td>\r\n\t\t\t\t<td col=ul1>{$w['MhswID']}</td> \r\n\t\t\t\t<td col=ul1>{$w['TahunID']}</td>\t\r\n\t\t\t\t<td col=ul1>{$w['MKKode']}</td>\r\n\t\t\t\t<td col=ul1>{$w['KRSID']}</td>\r\n\t\t\t\t</tr>";
}
echo "</table>";
}
function fnProses()
{
TampilkanJudul("Menvalidasi Kurikulum");
$s = "select * from `mk` where KurikulumID='0' or KurikulumID='' or KurikulumID IS NULL";
$r = _query($s);
$x = 0;
echo "<table class=box align=center>";
echo "<tr align=center colspan=10><th>Tahun yang Kosong</tr>\r\n\t\t<tr><th class=ttl>No.</th>\r\n\t\t\t<th class=ttl>No. KurikulumID</th>\r\n\t\t\t<th class=ttl>No. MKID</th>\r\n\t\t\t<th class=ttl>No. ProdiID</th>\r\n\t\t\t<th class=ttl>MkKode</th>\r\n\t\t\t<th class=ttl>Nama</th>\r\n\t\t\t<th class=ttl>Singkatan</th>\r\n\t\t</tr>";
while ($w = _fetch_array($r)) {
$x++;
echo "<tr>\r\n\t\t\t\t<td col=ul1>{$x}</td>\r\n\t\t\t\t<td col=ul1>{$w['KurikulumID']}</td>\r\n\t\t\t\t<td col=ul1>{$w['MKID']}</td> \r\n\t\t\t\t<td col=ul1>{$w['ProdiID']}</td>\t\r\n\t\t\t\t<td col=ul1>{$w['MKKode']}</td>\r\n\t\t\t\t<td col=ul1>{$w['Nama']}</td>\r\n\t\t\t\t<td col=ul1>{$w['Singkatan']}</td>\r\n\t\t\t\t</tr>";
}
echo "</table>";
}
function berhasil()
{
global $_ProductName, $_Version, $arrID;
// Tampilkan welcome
$NamaLevel = GetaField('level', 'LevelID', $_SESSION['_LevelID'], 'Nama');
TampilkanJudul("Selamat Datang");
$pesan = "<table><tr><th colspan=3>Selamat datang di {$_ProductName}</th></tr>";
$pesan .= "<tr><td>Nama</td><td>:</td><td><b>{$_SESSION['_Nama']}</b></td>";
$pesan .= "<tr><td>Level</td><td>:</td><td><b>{$NamaLevel}</b></td>";
$pesan .= "<tr><td>Institusi</td><td>:</td><td><b>{$arrID['Nama']}</b></td>";
$pesan .= "<tr><td colspan=3>Pilihan : <a href='?slnt=loginprc&slntx=lout'>Logout</a></td></tr>";
$pesan .= "</table>";
echo Konfirmasi("Selamat Datang", $pesan);
}
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 ProsesMhswCuti0()
{
TampilkanJudul("Proses...");
$s = "select * from _mhswcuti order by TahunID, MhswID";
$r = _query($s);
$n = 0;
$_SESSION['CUTI-JML'] = _num_rows($r);
$_SESSION['CUTI-POS'] = 0;
while ($w = _fetch_array($r)) {
$n++;
$_SESSION['CUTI-MhswID-' . $n] = $w['MhswID'];
$_SESSION['CUTI-TahunID-' . $n] = $w['TahunID'];
$_SESSION['CUTI-StatusMhswID-' . $n] = $w['StatusMhswID'];
}
echo "<IFRAME src='_proses_mhsw_cuti.php?gos=ProsesMhswCuti' width=90% height=80%></IFRAME>";
}
function Edit($md, $id, $bck)
{
if ($md == 0) {
$jdl = "Edit Gelombang";
$w = GetFields('pmbperiod', "KodeID='" . KodeID . "' and PMBPeriodID", $id, "*");
$_id = "<input type=hidden name='id' value='{$id}' /><b>{$id}</b>";
} elseif ($md == 1) {
$jdl = "Tambah Gelombang";
$w = array();
$w['Tahun'] = date('Y');
$w['TglMulai'] = date('Y-m-d');
$w['TglSelesai'] = date('Y-m-d');
$w['UjianMulai'] = date('Y-m-d');
$w['UjianSelesai'] = date('Y-m-d');
$w['WawancaraMulai'] = date('Y-m-d');
$w['WawancaraSelesai'] = date('Y-m-d');
$w['BayarMulai'] = date('Y-m-d');
$w['BayarSelesai'] = date('Y-m-d');
$w['NA'] = 'N';
$_id = "<input type=text name='id' value='{$id}' size=10 maxlength=50 />";
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$arrTahun = array();
for ($i = date('Y') + 1; $i >= date('Y') - 5; $i--) {
$arrTahun[] = $i;
}
$opttahun = GetOptionsFromData($arrTahun, $w['Tahun'], 1);
$TglMulai = GetDateOption3($w['TglMulai'], 'TglMulai');
$TglSelesai = GetDateOption3($w['TglSelesai'], 'TglSelesai');
$UjianMulai = GetDateOption3($w['UjianMulai'], 'UjianMulai');
$UjianSelesai = GetDateOption3($w['UjianSelesai'], 'UjianSelesai');
$WawancaraMulai = GetDateOption3($w['WawancaraMulai'], 'WawancaraMulai');
$WawancaraSelesai = GetDateOption3($w['WawancaraSelesai'], 'WawancaraSelesai');
$BayarMulai = GetDateOption3($w['BayarMulai'], 'BayarMulai');
$BayarSelesai = GetDateOption3($w['BayarSelesai'], 'BayarSelesai');
CheckFormScript("id,Nama,Tahun,Urutan");
$NA = $w['NA'] == 'Y' ? 'checked' : '';
$arrDigitNoAplikan = array(3, 4, 5);
$arrDigitNoPMB = array(3, 4, 5);
$optdigitnoaplikan = GetDigitOption($arrDigitNoAplikan, $w['DigitNoAplikan']);
$optdigitnopmb = GetDigitOption($arrDigitNoPMB, $w['DigitNoPMB']);
// Tampilkan
echo "<p><table class=bsc cellspacing=1 width=100%>\r\n <form action='../{$_SESSION['mnux']}.gelombang.edit.php' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='bck' value='{$bck}' />\r\n \r\n <tr><td class=inp nowrap>Kode Gelombang:</td>\r\n <td class=ul1>{$_id}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Nama Gelombang:</td>\r\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}' size=30 maxlength=50 /></td>\r\n </tr>\r\n <tr><td class=inp nowrap>Tahun Gelombang:</td>\r\n <td class=ul1><select name='Tahun'>{$opttahun}</select></td>\r\n </tr>\r\n <tr><td class=inp nowrap>Urutan Gelombang:</td>\r\n\t <td class=ul1><input type=text name='Urutan' value='{$w['Urutan']}' size=3 maxlength=5 /></td>\r\n\t </tr>\r\n <tr><td class=inp nowrap>Format No. Aplikan:</td>\r\n\t <td class=ul1><input type=text name='FormatNoAplikan' value='{$w['FormatNoAplikan']}' size=6>\r\n\t\t\t\t <select name='DigitNoAplikan'>{$optdigitnoaplikan}</select></td></tr>\r\n <tr><td class=inp nowrap>Format No. Pendaftaran:</td>\r\n\t <td class=ul1><input type=text name='FormatNoPMB' value='{$w['FormatNoPMB']}' size=6>\r\n\t\t\t\t\t<select name='DigitNoPMB'>{$optdigitnopmb}</select></td></tr>\r\n <tr><td class=inp nowrap>Mulai Tgl:</td>\r\n <td class=ul1>{$TglMulai}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Selesai Tgl:</td>\r\n <td class=ul1>{$TglSelesai}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Mulai USM:</td>\r\n <td class=ul1>{$UjianMulai}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Selesai USM:</td>\r\n <td class=ul1>{$UjianSelesai}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Mulai Wawancara:</td>\r\n\t <td class=ul1>{$WawancaraMulai}</td>\r\n\t </tr>\r\n <tr><td class=inp nowrap>Selesai Wawancara:</td>\r\n\t <td class=ul1>{$WawancaraSelesai}</td>\r\n\t </tr>\r\n <tr><td class=inp nowrap>Mulai Registrasi Ulang:</td>\r\n <td class=ul1>{$BayarMulai}</td>\r\n </tr>\r\n <tr><td class=inp nowrap>Selesai Registrasi Ulang:</td>\r\n <td class=ul1>{$BayarSelesai}</td>\r\n </tr>\r\n <tr><td class=inp>Tidak Aktif?</td>\r\n <td class=ul1>\r\n <input type=checkbox name='NA' value='Y' {$NA} /> *) Beri centang jika tidak aktif\r\n </td></tr>\r\n <tr><td class=ul1 colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan' />\r\n <input type=button name='Batal' value='Batal' onClick='window.close()' />\r\n </td></tr>\r\n </form>\r\n </table></p>";
}
function Edit($md, $prd, $id)
{
if ($md == 0) {
$jdl = "Edit Komponen";
$w = GetFields('komprematauji', "KodeID='" . KodeID . "' and KompreMataUjiID", $id, "*");
} elseif ($md == 1) {
$jdl = "Tambah Komponen";
$w = array();
$w['NA'] = 'N';
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$na = $w['NA'] == 'Y' ? 'checked' : '';
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\r\n <form action='../{$_SESSION['mnux']}.setup.edit.php' method=POST>\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='id' value='{$w['KompreMataUjiID']}' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='prd' value='{$prd}' />\r\n <input type=hidden name='bck' value='{$bck}' />\r\n \r\n <tr><td class=inp>Kode KOMPRE:</td>\r\n <td class=ul1><input type=text name='KodeKompre' value='{$w['KodeKompre']}'></td>\r\n </tr>\r\n <tr><td class=inp>Nama Komponen:</td>\r\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}'\r\n size=30 maxlength=50 /></td>\r\n </tr>\r\n <tr><td class=inp>Keterangan:</td>\r\n <td class=ul1>\r\n <textarea name='Keterangan' cols=30 rows=4>{$w['Keterangan']}</textarea>\r\n </td></tr>\r\n <tr><td class=inp>NA (tidak aktif)?</td>\r\n <td class=ul1>\r\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\r\n </td>\r\n </tr>\r\n \r\n <tr><td class=ul1 colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan' />\r\n <input type=button name='Batal' value='Batal'\r\n onClick=\"window.close()\" />\r\n </td>\r\n </tr>\r\n </form>\r\n </table></p>";
}
function Proses()
{
$Jumlah = $_SESSION['_bipotJumlah'];
$Progress = $_SESSION['_bipotProgress'];
$BIPOTID = $_SESSION['_bipotBIPOTID'];
if ($Jumlah >= $Progress) {
$MhswID = $_SESSION['_bipotMhswID_' . $Progress];
$TahunID = $_SESSION['_bipotTahunID_' . $Progress];
$ProdiID = $_SESSION['_bipotProdiID_' . $Progress];
$ProgramID = $_SESSION['_bipotProgramID_' . $Progress];
$s = "update mhsw\r\n set BIPOTID = '{$BIPOTID}'\r\n where KodeID = '" . KodeID . "'\r\n and MhswID = '{$MhswID}'\r\n limit 1";
$r = _query($s);
$_SESSION['_bipotProgress']++;
$_p = $Jumlah > 0 ? $Progress / $Jumlah * 100 : 0;
$_s = $Jumlah > 0 ? 100 - $Progress / $Jumlah * 100 : 0;
// Tampilkan
TampilkanJudul("Proses Set BIPOT Mhsw");
echo <<<ESD
<p align=center>
<font size=+1>{$Progress}</font> <sup>→ {$Jumlah}</sup><br />
<sup>{$MhswID}</sup><br />
<img src='../img/B1.jpg' height=20 width=1 /><img src='../img/B2.jpg' height=20 width={$_p} /><img src='../img/B3.jpg' height=20 width={$_s}/><img src='../img/B1.jpg' height=20 width=1 />
</p>
ESD;
// Next Process
$tmr = 1;
echo <<<SCR
<script>
window.onload=setTimeout("window.location='../{$_SESSION['mnux']}.proses.php'", {$tmr});
</script>
SCR;
} else {
TampilkanJudul("Proses Selesai");
echo <<<SCR
<p align=center>
Proses set BIPOT Mahasiswa telah selesai.<br />
Jumlah data mahasiswa yang telah diset: <font size=+1>{$Jumlah}</font>.
</p>
<hr size=1 color=silver />
<p align=center>
<input type=button name='Tutup' value='Tutup'
onClick="window.close()" />
</p>
SCR;
}
}
function DISKSAV()
{
TampilkanJudul("Upload File Nilai");
$FileNilai = $_FILES['FileNilai']['tmp_name'];
$NamaFileNilai = $_FILES['FileNilai']['name'];
$nmf = HOME_FOLDER . DS . "tmp/{$NamaFileNilai}";
if (move_uploaded_file($FileNilai, $nmf)) {
if (file_exists($nmf)) {
$isi = array();
$isi = parse_ini_file($nmf, true);
CekFileNilai($nmf, $isi);
} else {
echo ErrorMsg("Proses Upload File Nilai Gagal", "File Nilai gagal diupload. Coba ulangi sekali lagi.\r\n <hr size=1>\r\n Opsi: <a href='?mnux={$_SESSION['mnux']}'>Kembali</a>");
}
} else {
echo ErrorMsg("Proses Upload File Nilai Gagal", "Tidak dapat memproses file Nilai. Periksa file nilai yang diupload.\r\n <hr size=1>\r\n Opsi: <a href='?mnux={$_SESSION['mnux']}'>Kembali</a>");
}
}
function Edit()
{
$md = $_REQUEST['md'] + 0;
$id = sqling($_REQUEST['id']);
if ($md == 0) {
$jdl = "Edit Prasyarat Wisuda";
$w = GetFields('wisudaprasyarat', "KodeID='" . KodeID . "' and PrasyaratID", $id, '*');
$PrasyaratID = "<input type=hidden name='id' \r\n value='{$w['PrasyaratID']}' /><b>{$w['PrasyaratID']}</b>";
} elseif ($md == 1) {
$jdl = "Tambah Prasyarat Wisuda";
$w = array();
$PrasyaratID = "<input type=text name='id' size=20 maxlength=50 />";
} else {
die(ErrorMsg('Error', "Mode edit <b>{$md}</b> tidak dikenali.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='Tutup' value='Tutup' onClick='window.close()' />"));
}
// tampilkan
$na = $w['NA'] == 'Y' ? 'checked' : '';
TampilkanJudul($jdl);
echo <<<ESD
<table class=bsc width=100%>
<form action='../{$_SESSION['mnux']}.prasyarat.php' method=POST>
<input type=hidden name='gos' value='Simpan' />
<input type=hidden name='md' value='{$md}' />
<tr><td class=inp>Kode Prasyarat:</td>
<td class=ul>{$PrasyaratID}</td>
</tr>
<tr><td class=inp>Keterangan:</td>
<td class=ul><input type=text name='Nama' value='{$w['Nama']}' size=40 maxlength=50 /></td>
</tr>
<tr><td class=inp>Tidak Aktif? (NA)</td>
<td class=ul><input type=checkbox name='NA' value='Y' {$na} /></td>
</tr>
<tr><td class=ul colspan=2 align=center>
<input type=submit name='btnSimpan' value='Simpan' />
<input type=button name='Batal' value='Batal' onClick='window.close()' />
</td></tr>
</form>
</table>
ESD;
}
function Edit($md, $id, $bck)
{
if ($md == 0) {
$jdl = "Edit Komponen";
$w = GetFields('pmbsyarat', "KodeID='" . KodeID . "' and PMBSyaratID", $id, "*");
$_sya = "<input type=hidden name='id' value='{$w['PMBSyaratID']}' /><b>{$w['PMBSyaratID']}</b>";
} elseif ($md == 1) {
$jdl = "Tambah Komponen";
$w = array();
$w['NA'] = 'N';
$_sya = "<input type=text name='id' size=10 maxlength=10 />";
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$na = $w['NA'] == 'Y' ? 'checked' : '';
$prodi = AmbilProdi($w['ProdiID']);
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\n <form action='../{$_SESSION['mnux']}.pras.edit.php' method=POST>\n <input type=hidden name='gos' value='Simpan' />\n <input type=hidden name='md' value='{$md}' />\n <input type=hidden name='bck' value='{$bck}' />\n \n <tr><td class=inp>Kode:</td>\n <td class=ul1>{$_sya}</td>\n </tr>\n <tr><td class=inp>Prasyarat:</td>\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}'\n size=30 maxlength=50 /></td>\n </tr>\n <tr><td class=inp>Prodi:</td>\n <td class=ul1>\n {$prodi}\n </td></tr>\n <tr><td class=inp>Keterangan:</td>\n <td class=ul1>\n <textarea name='Keterangan' cols=50 rows=4>{$w['Keterangan']}</textarea>\n </td></tr>\n <tr><td class=inp>NA (tidak aktif)?</td>\n <td class=ul1>\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\n </td>\n </tr>\n \n <tr><td class=ul1 colspan=2 align=center>\n <input type=submit name='Simpan' value='Simpan' />\n <input type=button name='Batal' value='Batal'\n onClick=\"window.close()\" />\n </td>\n </tr>\n </form>\n </table></p>";
}
function Edit($md, $id, $bck)
{
if ($md == 0) {
$jdl = "Edit Presenter";
$w = GetFields('presenter', "KodeID='" . KodeID . "' and PresenterID", $id, "*");
$ro = "readonly=true";
} elseif ($md == 1) {
$jdl = "Tambah Presenter";
$w = array();
$w['NA'] = 'N';
$ro = '';
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$na = $w['NA'] == 'Y' ? 'checked' : '';
CheckFormScript("id,Nama");
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\r\n <form action='../{$_SESSION['mnux']}.presenter.edit.php' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='idlama' value='{$w['PresenterID']}' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='bck' value='{$bck}' />\r\n \r\n <tr><td class=inp>Kode:</td>\r\n <td class=ul1><input type=text name='id' value='{$w['PresenterID']}' size=5></td>\r\n </tr>\r\n <tr><td class=inp>Nama:</td>\r\n <td class=ul1><input type=text name='Nama' value='{$w['Nama']}' size=40>\r\n </td></tr>\r\n <tr><td class=inp>NA (tidak aktif)?</td>\r\n <td class=ul1>\r\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\r\n </td>\r\n </tr>\r\n <tr><td class=ul1 colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan' />\r\n <input type=button name='Batal' value='Batal'\r\n onClick=\"window.close()\" />\r\n </td>\r\n </tr>\r\n </form>\r\n </table></p>";
}
function Edit($md, $id, $max)
{
if ($md == 0) {
$jdl = "Edit Quota Beasiswa";
$w = GetFields('quotabeasiswa', "KodeID='" . KodeID . "' and MaxQuotaID", $id, "*");
} elseif ($md == 1) {
$jdl = "Tambah Quota Beasiswa";
$w = array();
$w['NA'] = 'N';
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali."));
}
TampilkanJudul($jdl);
// Parameters
$gel = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', 'PMBPeriodID');
$na = $w['NA'] == 'Y' ? 'checked' : '';
$usmchecked = $w['USM'] == 'USM' ? 'checked' : '';
//$TestMasuk = GetTestMasuk($w['USM']);
echo "<p><table class=bsc cellspacing=1 align=center width=100%>\n <form action='../{$_SESSION['mnux']}.edt.php' method=POST>\n <input type=hidden name='gos' value='Simpan' />\n <input type=hidden name='md' value='{$md}' />\n <input type=hidden name='id' value='{$id}' />\n <input type=hidden name='max' value='{$max}' />\n \n <tr><td class=inp>Gelombang:</td>\n <td class=ul1><input type=hidden name='gel' value='{$gel}'><b>{$gel}</b></td></tr>\n <tr><td class=inp>Prodi:</td>\n <td class=ul1><input type=hidden name='prodi' value='{$_SESSION['ProdiID']}'><b>{$_SESSION['ProdiID']}</b></td></tr>\n <tr><td class=inp>Nilai:</td>\n <td class=ul1><input type=text name='DariNilai' value='{$w['DariNilai']}' size=3 maxlength=6 /> s/d <b>{$max}</b></td>\n </tr>\r\n <tr><td class=inp>Diskon:</td>\n <td class=ul1><input type=text name='Diskon' value='{$w['Diskon']}' size=3 maxlength=6 /> %</td>\n </tr>\n <tr><td class=inp>Keterangan:</td>\n <td class=ul1>\n <textarea name='Keterangan' cols=30 rows=3>{$w['Keterangan']}</textarea>\n </td></tr>\n <tr><td class=inp>NA (tidak aktif)?</td>\n <td class=ul1>\n <input type=checkbox name='NA' value='Y' {$na} /> *) Beri centang jika tidak aktif\n </td>\n </tr>\n \n <tr><td class=ul1 colspan=2 align=center>\n <input type=submit name='Simpan' value='Simpan' />\n <input type=button name='Batal' value='Batal'\n onClick=\"window.close()\" />\n </td>\n </tr>\n </form>\n </table></p>";
}
function Edit($md, $id)
{
if ($md == 0) {
$jdl = "Edit Pejabat";
$w = GetFields('pejabat', 'PejabatID', $id, '*');
$ro = "readonly=true";
} elseif ($md == 1) {
$jdl = "Tambah Pejabat";
$w = array();
$w['NA'] = 'N';
$w['Urutan'] = GetaField('pejabat', "KodeID", KodeID, "max(Urutan)") + 1;
$ro = "";
} else {
die(ErrorMsg('Error', "Terjadi kesalahan mode edit.<br />\r\n Mode edit {$md} tidak dikenali.<br />\r\n Hubungi Sysadmin untuk informasi lebih lanjut.\r\n <hr size=1 color=silver />\r\n <input type=button name='Tutup' value='Tutup'\r\n onClick=\"window.close()\" />"));
}
$NA = $w['NA'] == 'Y' ? 'checked' : '';
// tampilkan form
CheckFormScript("KodeJabatan,Urutan,Jabatan");
TampilkanJudul($jdl);
echo "<table class=bsc cellspacing=1 width=100%>\r\n <form action='?mnux={$_SESSION['mnux']}' method=POST onSubmit=\"return CheckForm(this)\">\r\n <input type=hidden name='gos' value='Simpan' />\r\n <input type=hidden name='md' value='{$md}' />\r\n <input type=hidden name='id' value='{$id}' />\r\n \r\n <tr><td class=inp>Urutan:</td>\r\n <td class=ul><input type=text name='Urutan' value='{$w['Urutan']}' size=3 maxlength=4 {$ro}/></td>\r\n </tr>\r\n <tr><td class=inp>Kode Jabatan:</td>\r\n <td class=ul><input type=text name='KodeJabatan' value='{$w['KodeJabatan']}'\r\n size=20 maxlength=50 {$ro}/><br />\r\n (*) Digunakan oleh sistem utk laporan<sup>2</sup>\r\n </td></tr>\r\n <tr><td class=inp>Nama Pejabat:</td>\r\n <td class=ul><input type=text name='Nama' value='{$w['Nama']}'\r\n size=30 maxlength=50 />\r\n </td>\r\n </tr>\r\n <tr><td class=inp>NIP:</td>\r\n <td class=ul><input type=text name='NIP' value='{$w['NIP']}'\r\n size=30 maxlength=50 />\r\n </td></tr>\r\n <tr><td class=inp>Jabatan:</td>\r\n <td class=ul><input type=text name='Jabatan' value='{$w['Jabatan']}'\r\n size=30 maxlength=75 />\r\n </td>\r\n </tr>\r\n <tr><td class=inp>NA (tidak aktif)?</td>\r\n <td class=ul><input type=checkbox name='NA' value='Y' {$NA} />\r\n </td></tr>\r\n <tr><td class=ul1 colspan=2 align=center>\r\n <input type=submit name='Simpan' value='Simpan' />\r\n <input type=button name='Batal' value='Batal'\r\n onClick=\"window.close()\" />\r\n </td></tr>\r\n \r\n </form>\r\n </table>";
}
function EditKelompok()
{
$md = $_REQUEST['md'] + 0;
$kid = $_REQUEST['kid'];
if ($md == 0) {
$jdl = 'Edit Kelompok';
$w = GetFields('matrikulasi', 'MatriID', $kid, '*');
$strkid = "\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Kelompok ID: </td>\r\n\t\t\t\t<td class=ul1><input type=text name='dkid' value='{$kid}' size=2 disabled>\r\n\t\t\t\t\t\t\t<input type=hidden name='kid' value='{$kid}'></td>\t\t\t\t\r\n\t\t\t</tr>";
} else {
if ($md == 1) {
$jdl = 'Tambah Kelompok';
$w = array();
$strkid = "";
} else {
die(ErrorMsg('Error', "Mode edit tidak dikenali. Hubungi Sysadmin untuk informasi lebih lanjut."));
}
}
TampilkanJudul($jdl);
echo "<br>";
CheckFormScript("InputNama,InputTahun,InputKapMax");
echo "<table class=box cellspacing=1 align=center>\r\n\t\t\t\t<form action='?' method=POST onSubmit=\"return CheckForm(this)\">\r\n\t\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}' />\r\n\t\t\t\t\t<input type=hidden name='gos' value='SavKelompok' />\r\n\t\t\t\t\t<input type=hidden name='md' value='{$md}'/>\r\n\t\t\t\t\t<input type=hidden name='kid' value='{$kid}' />\r\n\t\t\t\t\t\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td class=inp>Nama Kelompok:</td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputNama' value='{$w['Nama']}'></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 class=inp>Tahun Akademik:</td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputTahun' value='{$_SESSION['matri_tahun']}' size=3 maxlength=10></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 class=inp>Kapasitas Maksimum Kelompok: </td>\r\n\t\t\t\t\t\t<td class=ul1><input type=text name='InputKapMax' value='{$w['KapasitasMaksimum']}' size=2 maxlength=4></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 class=ul1 colspan=2 align=center>\r\n\t\t\t\t\t\t\t<input type=submit name='SimpanKelompok' value='Simpan Kelompok' />\r\n\t\t\t\t\t\t\t<input type=reset name='Reset' value='Reset' />\r\n\t\t\t\t\t\t\t<input type=button name='Batal' value='Batal'\r\n\t\t\t\t\t\t\t\tonClick=\"self.close();\" /></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t</form>";
}
function CariNama()
{
$gelombang = GetaField('pmbperiod', "KodeID='" . KodeID . "' and NA", 'N', "PMBPeriodID");
TampilkanJudul("List Nama yang Cocok");
if (empty($_REQUEST['PFJ_TGL_y']) and empty($_REQUEST['PFJ_TGL_m']) and empty($_REQUEST['PFJ_TGL_d'])) {
$checktanggal = '';
} else {
$temptanggal = "{$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}";
$checktanggal = "and TanggalLahir='{$temptanggal}'";
}
$s = "select * from `aplikan` where Nama LIKE '%{$_REQUEST['n']}%' {$checktanggal}";
//echo "Select: $s";
$r = _query($s);
$n = _num_rows($r);
if (empty($_REQUEST['PFJ_TGL_y'])) {
$temptahun = date('Y') - 19;
$opttanggal = GetDateOption("{$temptahun}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}", 'PFJ_TGL');
} else {
$opttanggal = GetDateOption("{$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}", 'PFJ_TGL');
}
echo "<p><table class=box cellspacing=1 align=center>\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='CariNama' />\r\n\t\t\t\t<input type=hidden name='id' value='{$_REQUEST['id']}' />\r\n\t\t\t\t<input type=hidden name='gel' value='{$_REQUEST['gel']}' />\r\n\t\t\t\t<input type=hidden name='n' value='{$_REQUEST['n']}' />\r\n\t\t\t\t\r\n\t\t\t\t<tr>\r\n\t\t\t\t<td class=inp>Filter Tanggal Lahir: </td>\r\n\t\t\t\t<td class=ul1>{$opttanggal}</td>\r\n\t\t\t\t<td class=ul1><input type=submit name='CariTanggal' value='Filter Tanggal'></td>\r\n\t\t\t\t</tr>\r\n\t\t\t</form>\r\n\t\t</table></p>\r\n\t\t";
echo "<p><table class=box cellspacing=1 align=center width=100%>\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='SelesaiCari' />\r\n\t\t\t\t<input type=hidden name='id' value='{$_REQUEST['id']}' />\r\n\t\t\t\t<input type=hidden name='gel' value='{$_REQUEST['gel']}' />\r\n\t\t\t\t";
echo "<tr>\r\n\t\t\t<td class=ul1 colspan=8><sub>Nama Filter Aktif: {$_REQUEST['n']}</sub></td>\r\n\t\t </tr>\r\n\t\t <tr>\r\n\t\t\t<td class=ul1 colspan=8><sub>Tanggal Filter Aktif: {$_REQUEST['PFJ_TGL_y']}-{$_REQUEST['PFJ_TGL_m']}-{$_REQUEST['PFJ_TGL_d']}<sub></td>\r\n\t\t </tr>";
echo "<tr>\r\n\t\t\t<th class=ttl width=15>Pilih</th>\r\n\t\t\t<th class=ttl width=30>No. Aplikan</th>\r\n\t\t\t<th class=ttl>Nama</th>\r\n\t\t\t<th class=ttl width=15>Kelamin</th>\r\n\t\t\t<th class=ttl width=30>Tempat<br> Lahir</th>\r\n\t\t\t<th class=ttl width=30>Tgl. Lahir</th>\r\n\t\t\t<th class=ttl width=50>Alamat</th>\r\n\t\t\t<th class=ttl width=20>Kota</th>\r\n\t\t\t<th class=ttl width=10>Kode<br>Pos</th>\r\n\t\t\t<th class=ttl width=20>Status</th>\r\n\t\t</tr>";
while ($w = _fetch_array($r)) {
$FormulirID = GetAField('pmbformjual', "PMBPeriodID='{$gelombang}' and AplikanID", $w[AplikanID], 'PMBFormJualID');
//if($w['PMBID']=='' or !isset($w['PMBID']) )
if (empty($FormulirID) or $FormulirID == '') {
echo "<tr>\r\n\t\t\t\t<td class=ul1><input type=checkbox name='pilihan[]' value='{$w['AplikanID']}' \r\n\t\t\t\t\tonChange='this.form.submit()' /></td>\r\n\t\t\t\t";
$Status = "";
} else {
echo "<tr bgcolor='#D3D3D3'>\r\n\t\t\t\t<td class=ul1 align=center>×</td>\r\n\t\t\t\t";
$Status = "SUDAH MEMBELI";
}
echo "\t<td class=ul1 align=center>{$w['AplikanID']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Nama']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['Kelamin']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['TempatLahir']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['TanggalLahir']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Alamat']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['Kota']}</td>\r\n\t\t\t\t<td class=ul1 align=center>{$w['KodePos']}</td>\r\n\t\t\t\t<td class=ul1 align=center><b>{$Status}</b></td>\r\n\t\t\t</tr>";
}
echo "<tr>\r\n\t\t\t<td class=ul1 colspan=8 align=center><input type=button name='Batal' value='Batal'\r\n\t\t\t\tonClick=\"window.close()\" /> \r\n\t\t\t</td>\r\n\t\t\t</tr>";
echo "</form>\r\n\t\t</table></p>";
}
function CariNama()
{
TampilkanJudul("List Nama yang Cocok");
$s = "select * from `aplikan` where AplikanID LIKE '%{$_REQUEST['n']}%' or Nama LIKE '%{$_REQUEST['n']}%' ";
//echo "Select: $s";
$r = _query($s);
$n = _num_rows($r);
echo "<SCRIPT>\r\n\t\t\tfunction kembalikan(aplikanid, formulirid, programid, namalengkap, kelamin, tempatlahir, tanggallahir, alamat, kota, \r\n\t\t\t\t\t\t\t\tpropinsi, kodepos, rt, rw, telepon, handphone, email, asalsekolah, namasekolah,\r\n\t\t\t\t\t\t\t\ttahunlulus, jurusansekolah, nilaisekolah, pilihan1, pilihan2, pilihan3, jumlahpilihan){\r\n\t\t\tcreator.frmisi.AplikanID.value = aplikanid;\r\n\t\t\tcreator.frmisi.PMBFormulirID.value = formulirid;\r\n\t\t\tcreator.frmisi.ProgramID.value = programid;\r\n\t\t\tcreator.frmisi.Nama.value = namalengkap;\r\n\t\t\tcreator.frmisi.Kelamin.value = kelamin; \r\n\t\t\tcreator.frmisi.TempatLahir.value = tempatlahir;\r\n\t\t\tcreator.frmisi.TanggalLahir_y.value = tanggallahir.substring(0, 4);\r\n\t\t\tcreator.frmisi.TanggalLahir_m.value = tanggallahir.substring(5, 7);\r\n\t\t\tcreator.frmisi.TanggalLahir_d.value = tanggallahir.substring(8, 10);\r\n\t\t\tcreator.frmisi.Alamat.value = alamat;\r\n\t\t\tcreator.frmisi.Propinsi.value = propinsi;\r\n\t\t\tcreator.frmisi.Kota.value = kota;\r\n\t\t\tcreator.frmisi.KodePos.value = kodepos;\r\n\t\t\tcreator.frmisi.RT.value = rt;\r\n\t\t\tcreator.frmisi.RW.value = rw;\r\n\t\t\tcreator.frmisi.Telepon.value = telepon;\r\n\t\t\tcreator.frmisi.Handphone.value = handphone;\r\n\t\t\tcreator.frmisi.Email.value = email;\r\n\t\t\tcreator.frmisi.AsalSekolah.value = asalsekolah;\r\n\t\t\tcreator.frmisi.SavAsalSekolah.value = asalsekolah;\r\n\t\t\tcreator.frmisi.NamaSekolah.value = namasekolah;\r\n\t\t\tcreator.frmisi.TahunLulus.value = tahunlulus;\r\n\t\t\tcreator.frmisi.JurusanSekolah.value = jurusansekolah;\r\n\t\t\tcreator.frmisi.NilaiSekolah.value = nilaisekolah;\r\n\t\t\t\r\n\t\t\tjmlpil = parseInt(jumlahpilihan);\r\n\t\t\tif(jmlpil <= 1)\r\n\t\t\t{\tcreator.frmisi.Pilihan1.value = pilihan1;\r\n\t\t\t\tcreator.frmisi.Pilihan2.value = '';\r\n\t\t\t\tcreator.frmisi.Pilihan2.disabled = true;\r\n\t\t\t\tcreator.frmisi.Pilihan3.value = '';\r\n\t\t\t\tcreator.frmisi.Pilihan3.disabled = true;\r\n\t\t\t}\r\n\t\t\telse if(jmlpil <=2)\r\n\t\t\t{\tcreator.frmisi.Pilihan1.value = pilihan1;\r\n\t\t\t\tcreator.frmisi.Pilihan2.disabled = false;\r\n\t\t\t\tcreator.frmisi.Pilihan2.value = pilihan2;\r\n\t\t\t\tcreator.frmisi.Pilihan3.value = '';\r\n\t\t\t\tcreator.frmisi.Pilihan3.disabled = true;\r\n\t\t\t}\r\n\t\t\telse\r\n\t\t\t{\tcreator.frmisi.Pilihan1.value = pilihan1;\r\n\t\t\t\tcreator.frmisi.Pilihan2.value = pilihan2;\r\n\t\t\t\tcreator.frmisi.Pilihan3.value = pilihan3;\r\n\t\t\t\tcreator.frmisi.Pilihan2.disabled = false;\r\n\t\t\t\tcreator.frmisi.Pilihan3.disabled = false;\r\n\t\t\t}\r\n\t\t\t\r\n\t\t\twindow.close();\r\n\t\t\t}\r\n\t\t</SCRIPT>";
echo "<p><table class=box cellspacing=1 align=center>\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='SelesaiCari' />\r\n\t\t\t\t<input type=hidden name='id' value='{$_REQUEST['id']}' />\r\n\t\t\t\t<input type=hidden name='gel' value='{$_REQUEST['gel']}' />\r\n\t\t\t\t";
echo "<tr>\r\n\t\t\t<td class=ul1 colspan=8><sub>Nomor/Nama yang dicari: {$_REQUEST['n']}</sub></td>\r\n\t\t </tr>";
echo "<tr>\r\n\t\t\t<th class=ttl>Pilih</th>\r\n\t\t\t<th class=ttl>No. Aplikan</th>\r\n\t\t\t<th class=ttl>Nama</th>\r\n\t\t\t<th class=ttl>Kelamin</th>\r\n\t\t\t<th class=ttl>Tempat Lahir</th>\r\n\t\t\t<th class=ttl>Tgl. Lahir</th>\r\n\t\t\t<th class=ttl>Alamat</th>\r\n\t\t\t<th class=ttl>Kota</th>\r\n\t\t\t<th class=ttl>Kode Pos</th>\r\n\t\t</tr>";
while ($w = _fetch_array($r)) {
if ($w['PMBFormulirID'] == '' or !isset($w['PMBFormulirID']) or $w['PMBFormulirID'] == NULL) {
echo "<tr bgcolor='#00FFFF'>\r\n\t\t\t\t<td class=ul1 align=center>^</td>\r\n\t\t\t\t";
} else {
if ($w['PMBID'] == '' or !isset($w['PMBID'])) {
$arrayPilihan = explode(',', $w['ProdiID']);
$arrayGabung = array();
foreach ($arrayPilihan as $pilih) {
if (!empty($pilih)) {
$arrayGabung[] = $pilih;
}
}
$NamaSekolah = GetaField('asalsekolah', 'SekolahID', $w['AsalSekolah'], 'Nama');
if (empty($NamaSekolah) or $NamaSekolah == '') {
$NamaSekolah = GetaField('perguruantinggi', 'PerguruanTinggiID', $w['AsalSekolah'], 'Nama');
}
$JumlahPilihan = empty($w['PMBFormulirID']) ? 3 : GetaField('pmbformulir', "PMBFormulirID='{$w['PMBFormulirID']}' and KodeID", KodeID, 'JumlahPilihan');
echo "<tr>\r\n\t\t\t\t<td class=ul1><input type=checkbox name='pilihan[]' value='{$w['AplikanID']}' \r\n\t\t\t\t\tonChange='javascript:kembalikan(\"{$w['AplikanID']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['PMBFormulirID']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['ProgramID']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Nama']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Kelamin']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['TempatLahir']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['TanggalLahir']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Alamat']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Kota']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Propinsi']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['KodePos']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['RT']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['RW']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Telepon']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Handphone']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['Email']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['AsalSekolah']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$NamaSekolah}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['TahunLulus']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['JurusanSekolah']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$w['NilaiSekolah']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$arrayGabung['0']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$arrayGabung['1']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$arrayGabung['2']}\",\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"{$JumlahPilihan}\")' /></td>\r\n\t\t\t\t";
} else {
echo "<tr bgcolor='#D3D3D3'>\r\n\t\t\t\t<td class=ul1 align=center>×</td>\r\n\t\t\t\t";
}
}
echo "\t<td class=ul1>{$w['AplikanID']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Nama']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Kelamin']}</td>\r\n\t\t\t\t<td class=ul1>{$w['TempatLahir']}</td>\r\n\t\t\t\t<td class=ul1>{$w['TanggalLahir']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Alamat']}</td>\r\n\t\t\t\t<td class=ul1>{$w['Kota']}</td>\r\n\t\t\t\t<td class=ul1>{$w['KodePos']}</td>\r\n\t\t\t</tr>";
}
echo "<tr>\r\n\t\t\t\t<td colspan=8 align=left><sub> × menandakan bahwa aplikan ini sudah mendaftar</sub></td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan=8 align=left><sub> ^ menandakan bahwa aplikan ini belum membeli formulir</sub></td>\r\n\t\t </tr>\r\n\t\t <tr>\r\n\t\t\t<td class=ul1 colspan=8 align=center><input type=button name='Batal' value='Batal'\r\n\t\t\t\tonClick=\"window.close()\" /> \r\n\t\t\t</td>\r\n\t\t\t</tr>";
echo "</form>\r\n\t\t</table></p>";
}
