function DftrLapAkd() { $arrLap = array('Rekapitulasi Jumlah Mahasiswa per Angkatan~statusmhsw0', '» Laporan Mahasiswa Aktif~statusmhsw~&sta=A', '» Laporan Mahasiswa Cuti~statusmhsw~&sta=C', '» Laporan Mahasiswa Drop Out~statusmhsw~&sta=D', '» Laporan Mahasiswa Keluar~statusmhsw~&sta=K', '» Laporan Mahasiswa Pasif~statusmhsw~&sta=P', 'Daftar Mahasiswa Yang Sudah KRS~krsmhsw', 'Daftar Mahasiswa Yang Belum KRS~krsmhsw0', '» Daftar Mahasiswa Berdasarkan Agama~agamamhsw', '» Daftar Mahasiswa Berdasarkan Asal Sekolah~asalsekmhsw', '» Daftar Mahasiswa Berdasarkan Dosen PA~dosenpamhsw', '» Daftar Mahasiswa Berdasarkan Prodi~prodimhsw', '» Daftar Mahasiswa Berdasarkan Angkatan~angkmhsw', '» Laporan Statistik Kelas~statistikkelas', '» Laporan Nilai Semester dan Distribusi Matakuliah~statistikkelas2'); $i = 0; echo "<p><table class=box cellspacing=1 align=center width=600>"; foreach ($arrLap as $arr) { $i++; $a = explode('~', $arr); $_a = "<a href='#{$i}' onClick=\"Prints('" . $a[1] . "', '" . $a[2] . "')\">"; echo "<tr>\r\n <td class=inp width=10><a name='{$i}'></a>{$i}</td>\r\n <td class=ul1>{$_a} {$a['0']}</a></td>\r\n <td class=ul1 align=center width=10>{$_a}<img src='img/printer2.gif' /></a></td>\r\n </tr>"; } echo "</table></p>"; RandomStringScript(); echo <<<SCR <script> function Prints(mdl, param) { var rnd = randomString(); lnk = "{$_SESSION['mnux']}."+mdl+".php?TahunID={$_SESSION['TahunID']}&ProdiID={$_SESSION['ProdiID']}"+param+"&_rnd="+rnd; //window.location = lnk; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> SCR; }
function TampilkanMenuMK() { global $mnux, $pref; RandomStringScript(); $kurid = $_SESSION['kurid_' . $_SESSION['prodi']]; echo <<<ESD <p><a href='?mnux={$mnux}&{$pref}={$_SESSION[$pref]}&sub=MKEdt&md=1'>Tambah Matakuliah</a> | <a href='#' onClick="CetakMatakuliah()">Cetak</a> | <a href='#' onClick="CetakStruktur()">Cetak Struktur Kurikulum</a> <script> <!-- function CetakMatakuliah() { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetak.php?k={$kurid}&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function CetakStruktur() { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetakstrukturkur.php?KurikulumID={$kurid}&ProdiID={$_SESSION['prodi']}&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } //--> </script> ESD; }
function TampilkanFilter() { $optprodi = GetProdiUser($_SESSION['_Login'], $_SESSION['FilterProdiID']); echo "<table class=box cellspacing=1 align=center width=940>\r\n <form name='frmFilterKomprehensif' action='?' method=POST>\r\n <input type=hidden name='gos' value='' />\r\n <input type=hidden name='komprepage' value='1' />\r\n <tr>\r\n <td class=inp>Tahun Akd:</td>\r\n <td class=ul><input type=text name='TahunID' value='{$_SESSION['TahunID']}' size=5 maxlength=5 /></td>\r\n <td class=inp>Filter Prodi:</td>\r\n <td class=ul><select name='FilterProdiID' onChange='this.form.submit()'>{$optprodi}</select></td>\r\n </tr>\r\n <tr><td class=inp>Cari NIM:</td>\r\n <td class=ul><input type=text name='FilterMhswID' value='{$_SESSION['FilterMhswID']}' size=20 maxlength=20 /></td>\r\n <td class=inp>Cari Nama:</td>\r\n <td class=ul><input type=text name='FilterNamaMhsw' value='{$_SESSION['FilterNamaMhsw']}' size=20 maxlength=20 /></td>\r\n </tr>\r\n <tr>\r\n <td class=ul colspan=4 align=center>\r\n <input type=submit name='Cari' value='Cari Data' />\r\n <input type=button name='ResetFilter' value='Reset Filter'\r\n onClick=\"location='?mnux={$_SESSION['mnux']}&gos=&TahunID=&FilterProdiID=&FilterMhswID=&FilterNamaMhsw='\" />\r\n ▷▶\r\n <input type=button name='DaftarkanMhswKomprehensif' value='Daftarkan Komprehensif Mhsw'\r\n onClick=\"javascript:KomprehensifEdit(1,0)\" />\r\n\t\t<input type=button name='SetupKompre' value='Setup Komprehensif'\r\n onClick=\"javascript:SetupKomprehensif()\" />\r\n\t <br>\r\n\t\t<input type=button name='CetakFormKompre' value='Cetak Formulir'\r\n onClick=\"javascript:CetakForm()\" />\r\n\t\t<input type=button name='CetakJadwalKompre' value='Cetak Jadwal'\r\n onClick=\"javascript:CetakJadwal()\" />\r\n\t\t<input type=button name='CetakJadwalKomprePerHari' value='Cetak Jadwal Per Hari'\r\n\t\t onClick=\"javascript:CetakJadwalPerHari()\" />\r\n </td>\r\n </tr>\r\n </form>\r\n </table>"; RandomStringScript(); echo <<<SCR <script> \t function KomprehensifEdit(md,id) { \t\t _rnd = randomString(); \t\t lnk = "{$_SESSION['mnux']}.edit.php?md="+md+"&_rnd="+_rnd+"&KompreID="+id; \t\t win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); \t\t if (win2.opener == null) childWindow.opener = self; \t } \t function EditJadwal(md,id,prodi) { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.jadwal.php?md="+md+"&_rnd="+_rnd+"&KompreID="+id+"&ProdiID="+prodi; \t\twin2 = window.open(lnk, "", "width=1000, height=500, scrollbars, status"); \t\twin2.moveTo(100,100); \t\tif (win2.opener == null) childWindow.opener = self; \t } \t function DetailKompre(md,id,prodi) { \t\t\t_rnd = randomString(); \t\t\tlnk = "{$_SESSION['mnux']}.nilai.php?md="+md+"&_rnd="+_rnd+"&KompreID="+id+"&ProdiID="+prodi; \t\t\twin2 = window.open(lnk, "detail", "width=500, height=500, scrollbars, status"); \t\t\twin2.moveTo(100,100); \t\t\tif (win2.opener == null) childWindow.opener = self; \t } \t function CetakKomprehensif() { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.cetak.php?TahunID={$_SESSION['TahunID']}&_rnd="+_rnd; \t\twin2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); \t\tif (win2.opener == null) childWindow.opener = self; \t } \t function CetakForm() { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.cetakformulir.php?ProdiID={$_SESSION['FilterProdiID']}&_rnd="+_rnd; \t\twin2 = window.open(lnk, "", "width=800, height=600, scrollbars, status, resizable"); \t\tif (win2.opener == null) childWindow.opener = self; \t } \t function CetakJadwal() { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.cetakJadwal.php?_rnd="+_rnd+"TahunID={$_SESSION['TahunID']}&ProdiID={$_SESSION['FilterProdiID']}"; \t\twin2 = window.open(lnk, "cetakJ", "width=700, height=600, scrollbars, status, resizable"); \t\tif (win2.opener == null) childWindow.opener = self; \t } \t function CetakJadwalPerHari() { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.cetakjadwalperhari.php?_rnd="+_rnd+"TahunID={$_SESSION['TahunID']}&ProdiID={$_SESSION['FilterProdiID']}"; \t\twin2 = window.open(lnk, "", "width=700, height=600, scrollbars, status, resizable"); \t\tif (win2.opener == null) childWindow.opener = self; \t } \t function SetupKomprehensif() { \t\t_rnd = randomString(); \t\tlnk = "{$_SESSION['mnux']}.setup.php?TahunID={$_SESSION['TahunID']}&_rnd="+_rnd; \t\twin2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); \t\tif (win2.opener == null) childWindow.opener = self; \t } </script> SCR; }
function TampilkanFilter() { $optprodi = GetProdiUser($_SESSION['_Login'], $_SESSION['FilterProdiID']); echo "<table class=box cellspacing=1 align=center width=940>\n <form name='frmFilterPraktek' action='?' method=POST>\n <input type=hidden name='gos' value='' />\n <input type=hidden name='praktekpage' value='1' />\n <tr>\n <td class=inp>Tahun Akd:</td>\n <td class=ul><input type=text name='TahunID' value='{$_SESSION['TahunID']}' size=5 maxlength=5 /></td>\n <td class=inp>Filter Prodi:</td>\n <td class=ul><select name='FilterProdiID' onChange='this.form.submit()'>{$optprodi}</select></td>\n </tr>\n <tr><td class=inp>Cari NIM:</td>\n <td class=ul><input type=text name='FilterMhswID' value='{$_SESSION['FilterMhswID']}' size=20 maxlength=20 /></td>\n <td class=inp>Cari Nama:</td>\n <td class=ul><input type=text name='FilterNamaMhsw' value='{$_SESSION['FilterNamaMhsw']}' size=20 maxlength=20 /></td>\n </tr>\n <tr>\n <td class=ul colspan=4 align=center>\n <input type=submit name='Cari' value='Cari Data' />\n <input type=button name='ResetFilter' value='Reset Filter'\n onClick=\"location='?mnux={$_SESSION['mnux']}&gos=&TahunID=&FilterProdiID=&FilterMhswID=&FilterNamaMhsw='\" />\n ▷▶\n <input type=button name='DaftarkanPraktekMhsw' value='Daftarkan Praktek Kerja Mhsw'\n onClick=\"javascript:PraktekEdit(1,0)\" />\n <input type=button name='CetakDaftarPraktek' value='Cetak Daftar Praktek Kerja'\n onClick=\"javascript:CetakPraktek()\" />\n </td>\n </tr>\n </form>\n </table>"; RandomStringScript(); echo <<<SCR <script> <!-- function PraktekEdit(md,id) { if (frmFilterPraktek.FilterProdiID.value == '') alert("Pilihan Program Studi terlebih dahulu"); else { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.edit.php?md="+md+"&PraktekKerjaID="+id+"&ProdiID="+frmFilterPraktek.FilterProdiID.value+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } } function CetakPraktek() { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetak.php?TahunID={$_SESSION['TahunID']}&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnKelulusan(id) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.lulus.php?_rnd="+_rnd+"&PraktekKerjaID="+id; win2 = window.open(lnk, "", "width=700, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } //--> </script> SCR; }
function DftrLapKeu() { $arrLap = array('Rekapitulasi Biaya Mahasiswa~rekapbiaya', 'Laporan Pembayaran Mahasiswa~mhswbayar', 'Laporan Pembayaran Registrasi Mahasiswa~rekapbiayareg', 'Laporan Pembayaran Uang Kuliah~mhswbayar2', 'Rekap Pembayaran Bulanan~bayarbulan', 'Daftar Pembayaran Per Akun~bayarakun', 'Daftar Mahasiswa Yang Memiliki Angsuran~angsurmhsw', 'Daftar Mahasiswa Yang Mendapatkan Beasiswa~beasiswa'); $i = 0; echo "<p><table class=box cellspacing=1 align=center width=600>"; foreach ($arrLap as $arr) { $i++; $a = explode('~', $arr); $_a = "<a href='#{$i}' onClick=\"Prints('" . $a[1] . "', '" . $a[2] . "')\">"; echo "<tr>\r\n <td class=inp width=10><a name='{$i}'></a>{$i}</td>\r\n <td class=ul1>{$_a} {$a['0']}</a></td>\r\n <td class=ul1 align=center width=10>{$_a}<img src='img/printer2.gif' /></a></td>\r\n </tr>"; } echo "</table></p>"; RandomStringScript(); echo <<<SCR <script> function Prints(mdl, param) { var rnd = randomString(); lnk = "{$_SESSION['mnux']}."+mdl+".php?TahunID={$_SESSION['TahunID']}&ProdiID={$_SESSION['ProdiID']}"+param+"&_rnd="+rnd; //window.location = lnk; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> SCR; }
function fnDftrJdwl() { TampilkanHeaderJadwal(); $whr_prog = $_SESSION['_jdwlProg'] == '' ? '' : "and j.ProgramID='{$_SESSION['_jdwlProg']}' "; $whr_hari = $_SESSION['_jdwlHari'] == '' ? '' : "and j.HariID = '{$_SESSION['_jdwlHari']}' "; $s = "select j.*,\r\n left(j.Nama, 50) as _Nama,\r\n left(j.JamMulai, 5) as _JM,\r\n left(j.JamSelesai, 5) as _JS,\r\n d.Nama as NamaDosen, d.Gelar\r\n from jadwal j\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n where j.KodeID = '" . KodeID . "'\r\n and j.ProdiID = '{$_SESSION['_jdwlProdi']}'\r\n and j.TahunID = '{$_SESSION['_jdwlTahun']}'\r\n and j.{$_SESSION['_jdwlU']}RuangID = ''\r\n {$whr_prog}\r\n {$whr_hari}\r\n order by j.HariID, j.JamMulai, j.JamSelesai"; $r = _query($s); $n = 0; $hdr = "<tr><th class=ttl width=10>#</th>\r\n <th class=ttl width=70>Jam Kuliah</th>\r\n <th class=ttl>Matakuliah blm dijadwalkan ujian</th>\r\n <th class=ttl>Kelas</th>\r\n <th class=ttl>Prodi</th>\r\n <th class=ttl width=10>{$_SESSION['_jdwlU']}</th>\r\n </tr>"; RandomStringScript(); echo <<<ESD <table class=box cellspacing=1 width=100%> <script> function RefreshAll() { parent.RefreshAll(); } function JadwalkanUjian(jid) { var _rnd = randomString(); lnk = "../{$_SESSION['mnux']}.edit.php?jid="+jid; win2 = window.open(lnk, "", "width=500, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; $hr = '-1'; while ($w = _fetch_array($r)) { $n++; if ($hr != $w['HariID']) { $hr = $w['HariID']; $_hr = GetaField('hari', 'HariID', $hr, 'Nama'); echo "<tr><td class=ul1 colspan=6><font size=+1>{$_hr}</font></td></tr>"; echo $hdr; } echo <<<ESD <tr><td class=inp width=10>{$n}</td> <td class=ul width=70><sup>{$w['_JM']}</sup>~<sub>{$w['_JS']}</sub></td> <td class=ul> <sup>{$w['MKKode']} − {$w['SKS']} sks</sup><br /> {$w['_Nama']} <div align=right> <sub>{$w['NamaDosen']}, {$w['Gelar']}</sub> </div> </td> <td class=ul align=center> {$w['NamaKelas']}<br /> {$w['JumlahMhsw']} <sub>mhs</sub> </td> <td class=ul align=center> <sup>{$w['ProgramID']}</sup><br /> {$w['ProdiID']} </td> <td class=ul width=10 align=center> <a href='#' onClick="javascript:JadwalkanUjian({$w['JadwalID']})"><img src='../img/check.gif' /></a> </td> </tr> ESD; } echo "</table>"; }
function JadwalDosen($TahunID, $dsn) { TampilkanPilihanTahun($TahunID, $dsn['Login']); $s = "select j.*,\r\n left(j.JamMulai, 5) as _JM, left(j.JamSelesai, 5) as _JS,\r\n p.Nama as NamaProdi, if(jd.DosenID = '08.0211.037','Team Teaching','Dosen Pengampu') as Status\r\n from jadwal j\r\n left outer join prodi p on p.ProdiID = j.ProdiID and p.KodeID = '" . KodeID . "'\r\n left outer join jadwaldosen jd on jd.JadwalID = j.JadwalID\r\n where j.TahunID = '{$TahunID}'\r\n and j.KodeID = '" . KodeID . "'\r\n and j.DosenID = '{$dsn['Login']}' or (jd.DosenID = '{$_SESSION['dsnid']}')\r\n order by j.HariID, j.JamMulai, j.JamSelesai"; $r = _query($s); $n = 0; $ttl = 0; $hr = -25; echo "<table class=box cellspacing=1 align=center width=810>"; while ($w = _fetch_array($r)) { if ($hr != $w['HariID']) { $hr = $w['HariID']; $Hari = GetaField('hari', 'HariID', $hr, 'Nama'); TampilkanHeaderTabel($Hari); } $n++; $ttl += $w['SKS']; echo <<<ESD <tr> <td class=inp>{$n}</td> <td class=ul><sup>{$w['_JM']}</sup>→<sub>{$w['_JS']}</td> <td class=ul>{$w['MKKode']}</td> <td class=ul>{$w['Nama']}</td> <td class=ul align=right>{$w['SKS']}</td> <!--<td class=ul>{$w['NamaKelas']}</td>--> <td class=ul>{$w['RuangID']}</td> <td class=ul> <sup>{$w['ProgramID']}</sup> <div align=right> <sub><abbr title='{$w['NamaProdi']}'>→{$w['ProdiID']}</abbr></sub> </div> </td> <td class=ul>{$w['Status']}</td> ESD; } RandomStringScript(); echo <<<ESD <tr><td class=ul1 colspan=4 align=right>Total SKS:</td> <td class=ul1 align=right><font size=+1>{$ttl}</font></td> <td class=ul1 colspan=4></td> </tr> </table> <script> <!-- function CetakJadwal(thn, dsn) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetak.php?TahunID="+thn+"&DosenID="+dsn+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } //--> </script> ESD; }
function TampilkanHeaderHonorer() { $optbulan = GetMonthOption($_SESSION['_honBulan']); $optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['_honProdi'], "KodeID='" . KodeID . "'", 'ProdiID'); RandomStringScript(); echo <<<ESD <table class=box cellspacing=1 width=880> <form name='frmHeaderHondok' action='?' method=POST> <input type=hidden name='mnux' value='{$_SESSION['mnux']}' /> <input type=hidden name='gos' value='' /> <input type=hidden name='_honPage' value='1' /> <tr> <td class=ul1> Bulan:<br /> <select name='_honBulan' onChange='this.form.submit()'>{$optbulan}</select></td> <td class=ul1 nowrap> Tahun:<br /> <input type=text name='_honTahun' value='{$_SESSION['_honTahun']}' size=4 maxlength=4 /></td> <td class=ul1> Homebase Dosen:<br /> <select name='_honProdi' onChange='this.form.submit()'>{$optprodi}</select> </td> <td class=ul1> Filter Nama Dosen:<br /> <input type=text name='_honDosen' value='{$_SESSION['_honDosen']}' size=20 maxlength=50 /> </td> <td class=ul1 valign=bottom align=right> <input type=submit name='btnSubmit' value='Kirim' /> <input type=button name='btnReset' value='Reset Filter' onClick="location='?mnux={$_SESSION['mnux']}&gos=&_honPage=1&_honDosen=&_honProdi='" /> » <input type=button name='btnTambah' value='+Dosen' onClick="javascript:TambahHondok()" /> </td> </tr> </form> </table> <script> function TambahHondok() { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.dosen.php?_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function EditHondok(_honDosenID, _honID, _honTahunID) { var _rnd = randomString(); lnk = "../{$_SESSION['mnux']}.dosen.php?gos=fnEditHondok&_honDosenID="+_honDosenID+"&_md=0&_honID="+_honID+"&_honTahunID="+_honTahunID+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; }
function TampilkanAmbilMhswID($MhswID, $mhsw) { $stawal = GetaField('statusawal', 'StatusAwalID', $mhsw['StatusAwalID'], 'Nama'); $status = GetaField('statusmhsw', 'StatusMhswID', $mhsw['StatusMhswID'], 'Nama'); if (empty($mhsw['PenasehatAkademik'])) { $pa = '<sup>Belum diset</sup>'; } else { $dosenpa = GetFields('dosen', "Login='******'PenasehatAkademik']}' and KodeID", KodeID, "Nama, Gelar"); $pa = "{$dosenpa['Nama']} <sup>{$dosenpa['Gelar']}</sup>"; } echo <<<ESD <table class=box cellspacing=1 align=center width=600> <form name='frmMhsw' action='?' method=POST> <input type=hidden name='mnux' value='{$_SESSION['mnux']}' /> <input type=hidden name='gos' value='' /> <tr><td class=wrn width=2 rowspan=4></td> <td class=inp width=80>NIM/NPM:</td> <td class=ul width=200> <input type=text name='MhswID' value='{$MhswID}' size=20 maxlength=50 /> <input type=submit name='btnCari' value='Cari' /> </td> <td class=inp width=80>Mahasiswa:</td> <td class=ul>{$mhsw['Nama']} </td> </tr> <tr><td class=inp>Status Mhsw:</td> <td class=ul>{$status} <sup>{$stawal}</sup></td> <td class=inp>Dosen PA:</td> <td class=ul>{$pa}</td> \t </tr> <tr><td class=ul colspan=4 align=center> \t <input type=button name='btnSKSLulus' value='Cetak SKS Lulus' onClick="fnCetakSKSLulus('{$MhswID}')" /> \t <input type=button name='btnSKSTidakLulus' value='Cetak SKS Tidak Lulus' onClick="fnCetakSKSTidakLulus('{$MhswID}')" /> \t </td></tr> </form> </table> <script> \t function fnCetakSKSLulus(MhswID) \t {\tvar _rnd = randomString(); lnk = "{$_SESSION['mnux']}.skslulus.php?MhswID="+MhswID+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=500, scrollbars"); if (win2.opener == null) childWindow.opener = self; \t } \t function fnCetakSKSTidakLulus(MhswID) {\tvar _rnd = randomString(); lnk = "{$_SESSION['mnux']}.skstidaklulus.php?MhswID="+MhswID+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=500, scrollbars"); if (win2.opener == null) childWindow.opener = self; \t } </script> ESD; RandomStringScript(); }
function TampilkanKurikulum() { global $mnux, $pref, $token, $arrID; $s = "select * from kurikulum where ProdiID='{$_SESSION['prodi']}'\r\n order by KurikulumKode desc"; $r = _query($s); echo "<p><table class=box cellspacing=1 cellpadding=4 width=700>"; echo "<tr>\r\n <td class=ul1 colspan=5>\r\n <a href='?mnux={$mnux}&{$pref}={$_SESSION[$pref]}&sub=KurEdt&md=1'>Tambah Kurikulum</a> |\r\n <a href='?mnux={$mnux}&{$pref}={$token}'>Refresh Tampilan</a> |\r\n\t<a href='#' onClick=\"CetakKurikulum()\">Cetak</a>\r\n </td>\r\n </tr>\r\n\t<script>\r\n\t function CetakKurikulum() {\r\n\t\tvar _rnd = randomString();\r\n\t\tlnk = '{$_SESSION['mnux']}.cetakkur.php?p={$_SESSION['prodi']}&_rnd='+_rnd;\r\n\t\twin2 = window.open(lnk, '', 'width=800, height=600, scrollbars, status');\r\n\t\tif (win2.opener == null) childWindow.opener = self;\r\n\t }\r\n </script>"; RandomStringScript(); echo "<tr><th class=ttl>Kode</th>\r\n <th class=ttl>Kurikulum</th>\r\n <th class=ttl>Sesi</th>\r\n <th class=ttl>Jml/tahun</th>\r\n <th class=ttl>NA</th></tr>"; while ($w = _fetch_array($r)) { $c = $w['NA'] == 'Y' ? 'class=nac' : 'class=ul'; echo "<tr>\r\n <td {$c} width=100>\r\n <a href='?mnux={$mnux}&{$pref}={$_SESSION[$pref]}&sub=KurEdt&md=0&kurid={$w['KurikulumID']}'><img src='img/edit.png' border=0>\r\n {$w['KurikulumKode']}</a></td>\r\n <td {$c} width=180>{$w['Nama']}</td>\r\n <td {$c}>{$w['Sesi']}</td>\r\n <td {$c} align=right>{$w['JmlSesi']}</td>\r\n <td {$c} align=center width=10><img src='img/book{$w['NA']}.gif'></td>\r\n </tr>"; } echo "</table></p>"; }
function DftrKRSLama($MhswID, $mhsw) { $s = "select k.*\r\n from krs k\r\n where k.MhswID = '{$mhsw['PMBID']}'\r\n order by k.TahunID"; $r = _query($s); RandomStringScript(); echo "<table class=bsc cellspacing=1 width=100%>\r\n <tr>\r\n <th class=ttl width=20><abbr title='Konversikan'>Konv.</abbr></th>\r\n <th class=ttl width=20>#</th>\r\n <th class=ttl width=80>Kode › SKS</th>\r\n <th class=ttl>Matakuliah</th>\r\n </tr>"; $thn = 'alksdjflasdjfhasd'; while ($w = _fetch_array($r)) { if ($thn != $w['TahunID']) { $thn = $w['TahunID']; echo "<tr>\r\n <td class=ul1 colspan=5><font size=+1>{$thn}</td>\r\n </tr>"; } $n++; if ($w['StatusKRSID'] == 'K') { $c = "class=nac"; $konv = "<abbr title='Sudah dikonversikan'>×</a>"; } else { $c = "class=ul1"; $konv = "<input type=button name='btnKonversi' value='<' onClick=\"javascript:Konversikan({$w['KRSID']}, '{$MhswID}')\" />"; } echo "<tr>\r\n <td class=ul align=center>{$konv}</td>\r\n <td class=inp>{$n}</td>\r\n <td {$c}>{$w['MKKode']}<sup>{$w['SKS']}</sup></td>\r\n <td {$c}>{$w['Nama']}</td>\r\n </tr>"; } echo <<<ESD </table> <script> function Konversikan(krsid, mhswid) { _rnd = randomString(); lnk = "../{$_SESSION['mnux']}.konversikan.php?KRSID="+krsid+"&MhswID="+mhswid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function RefreshParent() { parent.location="../index.php?mnux={$_SESSION['mnux']}&gos=fnKonversi&MhswID={$MhswID}"; } </script> ESD; }
function DftrMhsw($dsn) { $s = "select m.MhswID, m.Nama as NamaMhsw, m.TahunID,\r\n m.ProdiID\r\n from mhsw m\r\n where m.KodeID = '" . KodeID . "'\r\n and m.PenasehatAkademik = '{$dsn['Login']}'\r\n order by m.TahunID, m.MhswID"; $r = _query($s); $n = 0; echo <<<ESD <p> <table class=box cellspacing=1 align=center width=600> <tr><td class=ul colspan=5> <input type=button name='btnCetakDaftar' value='Cetak Daftar Mahasiswa' onClick="javascript:fnCetakDaftar('{$dsn['Login']}')" /> </td></tr> <tr><th class=ttl>Nmr</th> <th class=ttl>NIM/NPM</th> <th class=ttl>Nama Mahasiswa</th> <th class=ttl>Prodi</th> </tr> ESD; while ($w = _fetch_array($r)) { $n++; echo "<tr>\r\n <td class=inp width=30>{$n}</td>\r\n <td class=ul1 width=100>{$w['MhswID']}</td>\r\n <td class=ul1>{$w['NamaMhsw']}</td>\r\n <td calss=ul1 width=100>{$w['ProdiID']}</td>\r\n </tr>"; } echo "</table></p>"; RandomStringScript(); echo <<<ESD <script> <!-- function fnCetakDaftar(dsn) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.daftar.php?DosenID="+dsn+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } //--> </script> ESD; }
function HalamanUtama() { include_once "../dwo.lib.php"; include_once "../db.mysql.php"; include_once "../connectdb.php"; include_once "../parameter.php"; include_once "../cekparam.php"; echo "<HTML xmlns=\"http://www.w3.org/1999/xhtml\">\r\n <HEAD><TITLE>{$title}</TITLE>\r\n <META content=\"Emanuel Setio Dewo\" name=\"author\">\r\n <META content=\"Sisfo Sekolah\" name=\"description\">\r\n <link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/{$_Themes}/index.css\" />\r\n "; $KelasID = GetSetVar('KelasID'); $kelas_tahun = GetSetVar('kelas_tahun'); $kelas_jmlsesi = GetSetVar('kelas_jmlsesi', 6); $kelas_sesi = GetSetVar('kelas_sesi', 1); TampilkanJudul("Laporan Statistik Kelas"); $tombols = ' '; $wheretahun = "TahunID='{$_SESSION['kelas_tahun']}'"; if (empty($_SESSION['kelas_tahun']) or $_SESSION['kelas_tahun'] == '') { $optkelas = "<option value=''>--Isi Tahun Dulu--</option>"; $optjmlsesi = "<option value=''>--Isi Tahun Dulu--<option>"; $optsesi = "<option value=''>--Isi Tahun Dulu--<option>"; } else { $optkelas = GetOption2('kelas', "Nama", 'Nama', $_SESSION['KelasID'], $wheretahun, 'KelasID'); if ($optkelas == '' or empty($optkelas)) { $optkelas = "<option value=''>--Tidak ada kelas--</option>"; } $arrNomer = array('7', '6', '5', '4', '3', '2', '1'); $optjmlsesi = GetOptionsFromArray($arrNomer, $_SESSION['kelas_jmlsesi'], 1); $optsesi = GetOptionsFromArray($arrNomer, $_SESSION['kelas_sesi'], 1); } if (empty($_SESSION['kelas_tahun'])) { $kelas = array(); } else { $kelas = GetFields("kelas", "KelasID='{$_SESSION['KelasID']}' and TahunID='{$_SESSION['kelas_tahun']}' and KodeID", KodeID, "Nama, KapasitasMaksimum, KapasitasSekarang"); if (empty($kelas)) { $kelas = array(); } else { RandomStringScript(); $scripts = <<<ESD <script> function fnCetakPerbandinganIPS(KelasID, jmlsesi) { var _rnd = randomString(); lnk = "lapakd.statistikkelas.php?gos=_CetakLaporanPerbandinganIPS&KelasID="+KelasID+"&jmlsesi="+jmlsesi+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=1000, height=800"); if (win2.opener == null) childWindow.opener = self; } \t function fnCetakPengambilanKHS(KelasID, sesi) { var _rnd = randomString(); lnk = "lapakd.statistikkelas.php?gos=_CetakDaftarPengambilanKHS&KelasID="+KelasID+"&sesi="+sesi+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=1000, height=800, scrollbars"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; } } CheckFormScript('kelas_tahun,KelasID'); echo <<<ESD <table class=box cellspacing=1 align=center width=600> <form name='frmHeader' action='?' method=POST onSubmit=\\"return CheckForm(this)"> <input type=hidden name='gos' value='' /> <tr><td width=12></td> \t <td class=inp width=120>Tahun Akademik:</td> <td class=ul width=220> <input type=text name='kelas_tahun' value='{$_SESSION['kelas_tahun']}' size=4 maxlength=6 /> <input type=submit name='btnCari' value='Cari' /> </td> <td class=inp width=120>Kapasitas Sekarang:</td> <td class=ul> <b>{$kelas['KapasitasSekarang']}</b> </td> </tr> <tr><td></td> \t <td class=inp>Kelas:</td> <td class=ul><select name='KelasID' onChange="this.form.submit()">{$optkelas}</select></td> <td class=inp>Kapasitas Maksimum:</td> <td class=ul><b>{$kelas['KapasitasMaksimum']}</b> </td> </tr> </tr>\t <tr><td> </td></tr> <tr><td class=ul colspan=5 align=center><font color=green><i><b>DAFTAR DAN LAPORAN YANG DAPAT DICETAK:</b></i></font> \t </td></tr> <tr><td bgcolor=silver height=1 colspan=5></td></tr> <tr> \t<td class=inp>1</td> \t<td class=ul1 colspan=2> \t<a href='#{$i}' onClick="javascript:fnCetakPerbandinganIPS('{$_SESSION['KelasID']}', '{$_SESSION['kelas_jmlsesi']}')" />Laporan Perbandingan IPS</a></td> \t<td class=inp>Jumlah Semester:</td> <td class=ul><select name='kelas_jmlsesi' onChange="this.form.submit()">{$optjmlsesi}</select></td> </tr> <tr><td bgcolor=silver height=1 colspan=5></td></tr> <tr> \t<td class=inp>2</td> \t<td class=ul1 colspan=2> \t<a href='#' onClick="javascript:fnCetakPengambilanKHS('{$_SESSION['KelasID']}', '{$_SESSION['kelas_sesi']}')" />Daftar Pengambilan KHS</a></td> \t<td class=inp>Semester Ke:</td> <td class=ul><select name='kelas_sesi' onChange="this.form.submit()">{$optsesi}</select></td> </tr> <tr><td bgcolor=silver height=1 colspan=5></td></tr> </form> </table> </p> ESD; echo "{$scripts}"; }
function HeaderTranskrip() { $MhswID = GetSetVar('MhswID'); $TahunAkademik = GetSetVar('TahunAkademik'); TampilkanJudul("Cetak Transkrip Nilai"); $tombols = ' '; if (empty($_SESSION['MhswID'])) { $mhsw = array(); } else { $mhsw = GetFields("mhsw m \r\n left outer join prodi prd on m.ProdiID=prd.ProdiID and prd.KodeID='" . KodeID . "'\r\n\t left outer join jenjang j on prd.JenjangID=j.JenjangID\r\n left outer join program prg on m.ProgramID=prg.ProgramID and prg.KodeID='" . KodeID . "'\r\n left outer join dosen d on m.PenasehatAkademik=d.Login and d.KodeID='" . KodeID . "'", "m.MhswID='{$_SESSION['MhswID']}' and m.KodeID", KodeID, "m.MhswID, m.Nama, m.ProgramID, m.ProdiID, m.PenasehatAkademik,\r\n d.Nama as NamaDosen, d.Gelar, j.Nama as _Jenjang,\r\n prd.Nama as _PRD, prg.Nama as _PRG"); if (empty($mhsw)) { $mhsw = array(); } else { if (empty($mhsw['NamaDosen'])) { $mhsw['NamaDosen'] = "<font color=red>×</font> Belum diset"; } RandomStringScript(); $tombols = <<<ESD <input type=button name='btnTranskrip' value='Transkrip Nilai' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}','{$_SESSION['TahunAkademik']}', 0)" /> <input type=button name='btnTranskripPerJenis' value='Transkrip Per Jenis MK' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 1)" /> <input type=button name='btnTranskrip' value='Transkrip Nilai Sementara' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 2)" /> \t <script> function fnCetakTranskrip(MhswID,TahunAkademik, jen) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.php?gos=_CetakTranskrip&MhswID="+MhswID+"&TahunAkademik="+TahunAkademik+"&_rnd="+_rnd+"&jen="+jen; win2 = window.open(lnk, "", "width=700, height=500, scrollbars"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; } } echo <<<ESD <table class=box cellspacing=1 align=center width=600> <form name='frmHeader' action='?' method=POST> <input type=hidden name='gos' value='' /> <tr><td class=inp>Thn.Akademik</td> <td class=ul colspan='3'> <input type=text name='TahunAkademik' value='{$_SESSION['TahunAkademik']}' size=8 maxlength=5 /> </td> </tr> <tr><td class=inp width=80>NIM/NPM:</td> <td class=ul width=220> <input type=text name='MhswID' value='{$_SESSION['MhswID']}' size=15 maxlength=50 /> <input type=submit name='btnCari' value='Cari' /> </td> <td class=inp width=90>Nama Mhsw:</td> <td class=ul> <b>{$mhsw['Nama']}</b> </td> </tr> <tr><td class=inp>Prodi:</td> <td class=ul>{$mhsw['_PRD']} <sup>{$mhsw['_PRG']}</sup> </td> <td class=inp>Penasehat Akd:</td> <td class=ul>{$mhsw['NamaDosen']} <sup>{$mhsw['Gelar']}</sup> </td> </tr> <tr><td class=ul colspan=4 align=center> {$tombols} </td></tr> </form> </table> </p> ESD; }
function BIPOTScript() { RandomStringScript(); echo <<<SCR <script> function BIPOTDELCONF(id, mhswid, tahunid) { if (confirm("Benar Anda akan menghapus BIPOT ini?")) { window.location="?mnux={$_SESSION['mnux']}&gos=HapusBIPOT&BypassMenu=1&_BIPOTMhswID="+id+"&MhswID="+mhswid+"&TahunID="+tahunid; } } function BIPOTDELALLCONF(mhswid, tahunid) { if (confirm("Benar Anda akan menghapus semua biaya di bawah ini? Biaya yang sudah terbayar tidak akan dihapus.")) { window.location="?mnux={$_SESSION['mnux']}&gos=HapusSemuaBIPOT&BypassMenu=1&MhswID="+mhswid+"&TahunID="+tahunid; } } function BIPOTEdit(mhswid, tahunid, md, id) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bipotedit.php?MhswID="+mhswid+"&TahunID="+tahunid+"&md="+md+"&id="+id+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=500, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function BIPOTEdit2(mhswid, tahunid, md, id, tagihanid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bipotedit2.php?MhswID="+mhswid+"&TahunID="+tahunid+"&md="+md+"&id="+id+"&_rnd="+_rnd+"&tagihanid="+tagihanid; win2 = window.open(lnk, "", "width=500, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function ByrEdit(mhswid, khsid, md, bayarid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bayar.php?MhswID="+mhswid+"&KHSID="+khsid+"&md="+md+"&BayarID="+bayarid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=750, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function ByrEdit2(bayarid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bayaredit.php?BayarID="+bayarid+"&md=0&_rnd="+_rnd; win2 = window.open(lnk, "", "width=750, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnTarikan(mhswid, khsid, md, bayarid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.tarik.php?MhswID="+mhswid+"&KHSID="+khsid+"&md="+md+"&BayarID="+bayarid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnPengembalian(mhswid, khsid, md, bayarid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.pengembalian.php?MhswID="+mhswid+"&KHSID="+khsid+"&md="+md+"&BayarID="+bayarid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnHistoryBeasiswa(mhswid, khsid, md) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.historybeasiswa.php?MhswID="+mhswid+"&KHSID="+khsid+"&md="+md+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function CetakBPM(id, trx) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bpm.php?id="+id+"&_rnd="+_rnd+"&trx="+trx; win2 = window.open(lnk, "", "width=600, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function ByrDel(BayarMhswID, MhswID, TahunID) { if (confirm("Benar Anda akan menghapus pembayaran ini? Mungkin daftar BIPOT di atas menjadi tidak balance lagi.")) { window.location="?mnux={$_SESSION['mnux']}&gos=HapusBayar&BayarMhswID="+BayarMhswID+"&MhswID="+MhswID+"&TahunID="+TahunID; } } </script> SCR; }
function DftrMK($MhswID, $mhsw) { $s = "select k.* from krs k left outer join khs h on h.KHSID = k.KHSID and h.KodeID = '" . KodeID . "' where k.MhswID = '{$MhswID}' order by k.TahunID, k.MKKode"; $r = _query($s); $_tahun = 'alksdjfasdf-asdf'; $n = _num_rows($r); echo <<<ESD <table class=box cellspacing=1 width=600 align=center> \t\t<form action='?' method=POST> \t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}'> \t\t<input type=hidden name='gos' value='SaveAll'> ESD; //$arrSemuaTahun = array('2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009'); $arrSemuaTahun = array('2008', '2009', '2010', '2011', '2012'); $optSemuaTahun = GetOptionsFromData($arrSemuaTahun, ''); echo "<tr><td class=ul1 colspan=2><input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$mhsw['MhswID']}', '', 0)\" /></td></tr>"; /*echo "<tr> <td class=ul1 colspan=2> <input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '$mhsw[MhswID]', '', 0)\" /> </td> <td class=inp>Masukkan Tahun Bila Kode -1- adalah Tahun: <td class=ul1><select name='InputTahun1'/>$optSemuaTahun</select><td> <td class=ul1><input type=button name='InputSemuaTahun' value='Input Semua Tahun' onClick ='this.form.submit()' /></td> </tr>";*/ $hdr = "<tr><th class=ttl width=20>Nmr</th>\r\n <th class=ttl width=90>Kode</th>\r\n <th class=ttl>Matakuliah</th>\r\n <th class=ttl width=30>SKS</th>\r\n <th class=ttl width=30>Nilai</th>\r\n <th class=ttl width=30>Tahun</th>\r\n <th class=ttl width=30>Edit</th>\r\n </tr>"; $m = 0; while ($w = _fetch_array($r)) { if ($_tahun != $w['TahunID']) { $_tahun = $w['TahunID']; echo "<tr><td class=ul1 colspan=10>\r\n <font size=+1>{$_tahun}</font>\r\n <!--<input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$w['MhswID']}', '{$_tahun}', 0)\" />-->\r\n </td></tr>"; echo $hdr; $n = 0; } $n++; $m++; if ($w['Setara'] == 'Y') { $btnEdit = "<input type=button name='btnEdit' value='�' onClick=\"fnEditKonversi(0, '{$w['MhswID']}', '{$w['TahunID']}', {$w['KRSID']})\" />"; } else { $btnEdit = "<abbr title='Bukan Konversi'><img src='img/flag2.gif' /></abbr>"; } //$arrTahun = array('20031','20032','20041','20042','20051','20052','20061','20062', '20071', '20072', '20081', '20082', '20091', '20092', '20101', '20102'); $arrTahun = array('20081', '20082', '20091', '20092', '20101', '20102', '20111', '20112', '20121', '20122'); $optTahun = GetOptionsFromData($arrTahun, $w['TahunID']); //echo "Select: Select$m<br>"; echo <<<ESD <tr> <td class=inp>{$n}</td> <td class=ul>{$w['MKKode']}</td> <td class=ul>{$w['Nama']}</td> <td class=ul align=right>{$w['SKS']}</td> <td class=ul align=center>{$w['GradeNilai']} <td class=ul align=center><select name='Select{$m}'>{$optTahun}</select><input type=hidden name='Hidden{$m}' value='{$w['KRSID']}'/></td> <td class=ul align=center>{$btnEdit}</td> </tr> ESD; } RandomStringScript(); echo "<tr>\r\n\t\t<td class=ul1 colspan=6>\r\n\t\t\t<input type=button name='SaveData' value='Save Data' onClick='this.form.submit()' /></td>\r\n\t</tr>"; echo <<<ESD \t </form> </table> <script> function fnEditKonversi(md, mhsw, thn, id) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.edit.php?mhsw="+mhsw+"&md="+md+"&id="+id+"&thn="+thn+"&_rnd="+_rnd+"&ProdiID={$mhsw['ProdiID']}"; win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; }
function BIPOTScript() { RandomStringScript(); echo <<<SCR <script> function CetakBPM(id, trx) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.bpm.php?id="+id+"&_rnd="+_rnd+"&trx="+trx; win2 = window.open(lnk, "", "width=600, height=400, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function ByrDel(BayarMhswID, MhswID, TahunID) { if (confirm("Benar Anda akan menghapus pembayaran ini? Mungkin daftar BIPOT di atas menjadi tidak balance lagi.")) { window.location="?mnux={$_SESSION['mnux']}&gos=HapusBayar&BayarMhswID="+BayarMhswID+"&MhswID="+MhswID+"&TahunID="+TahunID; } } </script> SCR; }
function KRSScript() { RandomStringScript(); echo <<<SCR <script> <!-- function AmbilKRS(mhswid, khsid) { lnk = "{$_SESSION['mnux']}.ambil.php?mhswid="+mhswid+"&khsid="+khsid; win2 = window.open(lnk, "", "width=1000, height=600, scrollbars, status, resizable"); if (win2.opener == null) childWindow.opener = self; } function AmbilPaket(mhswid, khsid) { lnk = "{$_SESSION['mnux']}.ambilpaket.php?mhswid="+mhswid+"&khsid="+khsid; win2 = window.open(lnk, "", "width=700, height=600, scrollbars, status, resizable"); if (win2.opener == null) childWindow.opener = self; } function HapusKRS(khsid,krsid) { if (confirm("Anda yakin akan menghapus matakuliah ini dari KRS Anda?")) { window.location = "?mnux={$_SESSION['mnux']}&gos=HapusKRS&khsid="+khsid+"&krsid="+krsid; } } function HapusSemua(khsid) { if (confirm("Anda yakin akan menghapus semua matakuliah di KRS? Matakuliah yang sudah dihapus tidak dapat dikembalikan lagi.")) { window.location = "?mnux={$_SESSION['mnux']}&gos=HapusSemua&khsid="+khsid; } } function CetakKRS(khsid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetak.php?khsid="+khsid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status, resizable"); if (win2.opener == null) childWindow.opener = self; window.location = "?mnux={$_SESSION['mnux']}&gos=CetakKRS&BypassMenu=1&khsid="+khsid; } function CetakLRS(khsid) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.lrs.php?khsid="+khsid+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status, resizable"); if (win2.opener == null) childWindow.opener = self; } function KRSLabEdt(md, jid, krsid, krsresid, jenis) { lnk = "{$_SESSION['mnux']}.resedit.php?md="+md+"&jid="+jid+"&krsid="+krsid+"&krsresid="+krsresid+"&jenis="+jenis; \twin2 = window.open(lnk, "", "width=600, height=300, scrollbars, status, resizable"); if (win2.opener == null) childWindow.opener = self; } --> </script> SCR; }
function TampilkanHeaderAplikan($gelombang) { $ck = isset($_SESSION['_apliPre']) && $_SESSION['_apliPre'] == 'Y' ? 'checked' : ''; $ckgel = isset($_SESSION['_apliGel']) && $_SESSION['_apliGel'] == 'Y' ? 'checked' : ''; $optpresenter = GetOption2('presenter', "concat(PresenterID, ' - ', Nama)", 'PresenterID', $_SESSION['_curPres'], "KodeID='" . KodeID . "'", 'PresenterID'); RandomStringScript(); echo <<<ESD <table class=bsc cellspacing=1 align=center width=800> <form name='frmAplikan' action='?' method=POST> <input type=hidden name='_apliPage' value=1 /> <input type=hidden name='gos' value='' /> <input type=hidden name='sbmt' value=1 /> <tr> <td class=inp width=80>Cari Nama:</td> <td class=ul1> <input type=text name='_apliNama' value='{$_SESSION['_apliNama']}' size=20 maxlength=50 /> <input type=submit name='btnCari' value='Cari' /> <input type=button name='btnReset' value='Reset Pencarian' onClick="window.location='?mnux={$_SESSION['mnux']}&gos=&_apliNama='" /> </td> \t\t<td class=ul1 align=right colspan=2>Pilih Menurut Presenter: <select name='_curPres' \t\t\tonChange='this.form.submit()' />{$optpresenter}</select></td> </tr> <tr><td class=ul1> </td> <td class=ul1> <input type=button name='btnTambahAplikan' value='Tambah Aplikan' onClick="javascript:fnEditAplikan('{$gelombang}', 1, 0 )" /> </td> <td class=ul1 align=center nowrap> Aplikan gelombang ini saja: <input type=checkbox name='_apliGel' value='Y' {$ckgel} onClick='this.form.submit()' /> </td> \t <td align=right><input type=button name='btnDaftarAplikan' value='Cetak Aplikan Hari Ini' onClick="javascript:fnCetakAplikan('{$gelombang}')" /> </td> </tr> </form> </table> <script> function fnEditAplikan(gel, md, id) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.edt.php?gel="+gel+"&md="+md+"&id="+id+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=620, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnCetakAplikan(gel) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetakaplikan.php?gel="+gel+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function fnPMB(id) { if (confirm("Anda akan mendaftarkan aplikan ke PMB?")) { window.location = "?mnux={$_SESSION['mnux']}&gel={$gelombang}&gos=fnDaftarkanPMB&BypassMenu=1&id="+id; } } function fnEditHistory(gel, md, id) { \t_rnd = randomString(); \tlnk = "{$_SESSION['mnux']}.hst.php?gel="+gel+"&md="+md+"&id="+id+"&_rnd="+_rnd; \twin2 = window.open(lnk, "", "width=620, height=700, scrollbars, status"); \tif(win2.opener == null) childWindow.opener = self; } </script> ESD; }
function HalamanUtama() { include_once "../dwo.lib.php"; include_once "../db.mysql.php"; include_once "../connectdb.php"; include_once "../parameter.php"; include_once "../cekparam.php"; echo "<HTML xmlns=\"http://www.w3.org/1999/xhtml\">\r\n <HEAD><TITLE>{$title}</TITLE>\r\n <META content=\"SIAKAD TEAM\" name=\"author\">\r\n <META content=\"Sisfo Sekolah\" name=\"description\">\r\n <link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/{$_Themes}/index.css\" />\r\n "; $KelasID = GetSetVar('KelasID'); $kelas_tahun = GetSetVar('kelas_tahun'); $kelas_sesi = GetSetVar('kelas_sesi', 1); $kelas_tahunajaran = GetSetVar('kelas_tahunajaran', date('Y')); $kelas_prodimk = GetSetVar('kelas_prodimk'); TampilkanJudul("Daftar dan Laporan Jurusan"); $tombols = ' '; $wheretahun = "TahunID='{$_SESSION['kelas_tahun']}'"; if (empty($_SESSION['kelas_tahun']) or $_SESSION['kelas_tahun'] == '') { $optkelas = "<option value=''>--Isi Tahun Dulu--</option>"; $optsesi = "<option value=''>--Isi Tahun Dulu--<option>"; $opttahunajaran = "<option value=''>--Isi Tahun Dulu--<option>"; $optprodimk = "<option value=''>--Isi Tahun Dulu--<option>"; } else { $optkelas = GetOption2('kelas', "Nama", 'Nama', $_SESSION['KelasID'], $wheretahun, 'KelasID'); if ($optkelas == '' or empty($optkelas)) { $optkelas = "<option value=''>--Tidak ada kelas--</option>"; } $arrTahun = array(); for ($i = date('Y') + 2; $i >= 2000; $i--) { $arrTahun[] = $i; } $opttahunajaran = GetOptionsFromArray($arrTahun, $_SESSION['kelas_tahunajaran'], 1); $arrNomer = array('7', '6', '5', '4', '3', '2', '1'); $optsesi = GetOptionsFromArray($arrNomer, $_SESSION['kelas_sesi'], 1); $tahunajarannext = '/ ' . ($_SESSION['kelas_tahunajaran'] + 1); $optprodimk = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['kelas_prodimk'], "KodeID='" . KodeID . "'", 'ProdiID'); } RandomStringScript(); if (empty($_SESSION['kelas_tahun'])) { $kelas = array(); } else { $kelas = GetFields("kelas", "KelasID='{$_SESSION['KelasID']}' and TahunID='{$_SESSION['kelas_tahun']}' and KodeID", KodeID, "Nama, KapasitasMaksimum, KapasitasSekarang"); if (empty($kelas)) { $kelas = array(); } else { $scripts = <<<ESD <script> \t function fnCetakNilaiTengahSemester(KelasID, sesi, thnajaran) { var _rnd = randomString(); lnk = "lapakd.statistikkelas2.php?gos=_CetakNilaiTengahSemester&KelasID="+KelasID+"&sesi="+sesi+"&thnajaran="+thnajaran+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=1000, height=800, scrollbars"); if (win2.opener == null) childWindow.opener = self; } \t function fnCetakNilaiAkhirSemester(KelasID, sesi, thnajaran) { var _rnd = randomString(); lnk = "lapakd.statistikkelas2.php?gos=_CetakNilaiAkhirSemester&KelasID="+KelasID+"&sesi="+sesi+"&thnajaran="+thnajaran+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=1000, height=800, scrollbars"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; } } $scripts2 = <<<ESD <script> \t function fnCetakDistribusiMK(KelasID, prodimk) { var _rnd = randomString(); lnk = "lapakd.statistikkelas2.php?gos=_CetakDistribusiMK&KelasID="+KelasID+"&prodimk="+prodimk+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=1000, height=800, scrollbars"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; CheckFormScript('kelas_tahun,KelasID'); echo <<<ESD <table class=box cellspacing=1 align=center width=600> <form name='frmHeader' action='?' method=POST onSubmit=\\"return CheckForm(this)"> <input type=hidden name='gos' value='' /> <tr><td width=12></td> \t <td class=inp width=120>Tahun Akademik:</td> <td class=ul width=190> <input type=text name='kelas_tahun' value='{$_SESSION['kelas_tahun']}' size=4 maxlength=6 /> <input type=submit name='btnCari' value='Cari' /> </td> <td class=inp width=130>Kapasitas Sekarang:</td> <td class=ul> <b>{$kelas['KapasitasSekarang']}</b> </td> </tr> <tr><td></td> \t <td class=inp>Kelas:</td> <td class=ul><select name='KelasID' onChange="this.form.submit()">{$optkelas}</select></td> <td class=inp>Kapasitas Maksimum:</td> <td class=ul><b>{$kelas['KapasitasMaksimum']}</b> </td> </tr> </tr>\t <tr><td> </td></tr> <tr><td class=ul colspan=5 align=center><font color=green><i><b>DAFTAR DAN LAPORAN YANG DAPAT DICETAK</b></i></font> \t </td></tr> <tr><td bgcolor=silver height=1 colspan=11></td></tr> <tr> <td class=inp>1</td> \t<td class=ul1 colspan=2> \t<a href='#' onClick="javascript:fnCetakNilaiTengahSemester('{$_SESSION['KelasID']}', '{$_SESSION['kelas_sesi']}', '{$_SESSION['kelas_tahunajaran']}')" /> \t\tDaftar Nilai Tengah Semester</a></td> \t<td class=inp>Semester:</td> <td class=ul><select name='kelas_sesi' onChange="this.form.submit()">{$optsesi}</select></td> </tr> <tr> \t<td class=inp>2</td> \t<td class=ul1 colspan=2> \t<a href='#' onClick="javascript:fnCetakNilaiAkhirSemester('{$_SESSION['KelasID']}', '{$_SESSION['kelas_sesi']}', '{$_SESSION['kelas_tahunajaran']}')" /> \t\tDaftar Nilai Akhir Semester</a></td> \t<td class=inp>Tahun Ajaran:</td> <td class=ul><select name='kelas_tahunajaran' onChange="this.form.submit()">{$opttahunajaran}</select> {$tahunajarannext}</td> </tr> <tr><td bgcolor=silver height=1 colspan=11></td></tr> <tr> \t<td class=inp>3</td> \t<td class=ul1 colspan=2> \t<a href='#' onClick="javascript:fnCetakDistribusiMK('{$_SESSION['KelasID']}', '{$_SESSION['kelas_prodimk']}')" /> \t\tDistribusi Mata Kuliah</a></td> \t<td class=inp>Prodi:</td> <td class=ul><select name='kelas_prodimk' onChange="this.form.submit()">{$optprodimk}</select></td> </tr> <tr><td bgcolor=silver height=1 colspan=11></td></tr> </form> </table> </p> ESD; echo "{$scripts}"; echo "{$scripts2}"; }
function fn_1($mhsw, $alumni, $tab) { // *** Data pekerjaan *** include_once "class/dwolister.class.php"; $lst = new dwolister(); $lst->maxrow = 10; $lst->page = $_SESSION['alumnikerjapage'] + 0; $lst->pageactive = "=PAGE="; $lst->pages = "<a href='?mnux={$_SESSION['mnux']}&alumnikerjapage==PAGE='>=PAGE=</a>"; $lst->tables = "alumnikerja\r\n where KodeID = '" . KodeID . "'\r\n order by MulaiKerja Desc"; $lst->fields = "*,\r\n date_format(MulaiKerja, '%d-%m-%Y') as _MulaiKerja"; $lst->headerfmt = "<table class=box cellspacing=1 cellpadding=4 width=600>\r\n <tr><td class=ul colspan=6>\r\n <input type=button name='btnTambah' value='+ Tambah'\r\n onClick=\"javascript:editPekerjaan('{$mhsw['MhswID']}', 1, 0)\" />\r\n </td></tr>\r\n <tr><th class=ttl width=20>No.</th>\r\n <th class=ttl width=90>Mulai Kerja</th>\r\n <th class=ttl>Perusahaan</th>\r\n <th class=ttl width=100>Jabatan</th>\r\n <th class=ttl width=100>Kota</th>\r\n </tr>"; $lst->footerfmt = "</table></p>"; $lst->detailfmt = "<tr>\r\n <td class=inp width=20>=NOMER=</td>\r\n <td class=ul align=center>\r\n <a href='#' onClick=\"javascript:editPekerjaan('{$mhsw['MhswID']}', 0, =AlumniKerjaID=)\"><img src='img/edit.png' /></a>\r\n =_MulaiKerja=\r\n </td>\r\n <td class=ul>=Nama=</td>\r\n <td class=ul>=Jabatan=</td>\r\n <td class=ul>=Kota=</td>\r\n </tr>\r\n <tr>"; echo $lst->TampilkanData(); echo $ttl; echo "<p>Hal.: " . $lst->TampilkanHalaman() . "<br />" . "Total: " . number_format($lst->MaxRowCount) . "</p>"; RandomStringScript(); echo <<<ESD <div class='box0' id='divPekerjaan' align=center> <!--<a href="#" onClick="javascript:toggleBox('divPekerjaan', 0)"><img src='img/kali.png' align=right /></a>--> <iframe name='framePekerjaan' id="framePekerjaan" src="" width=100% height=90% frameborder=0> </iframe> </div> <script> function editPekerjaan(MhswID, md, akid) { toggleBox('divPekerjaan', 1); _rnd = randomString(); lnk = "{$_SESSION['mnux']}.pekerjaan.php?mhswid="+MhswID+"&md="+md+"&akid="+akid+"&_rnd="+_rnd; document.getElementById('framePekerjaan').src = lnk; //alert(lnk); } </script> ESD; }
function DftrMK($MhswID, $mhsw) { $s = "select k.*\r\n from krs k\r\n left outer join khs h on h.KHSID = k.KHSID and h.KodeID = '" . KodeID . "'\r\n where k.MhswID = '{$MhswID}'\r\n order by k.TahunID, k.MKKode"; $r = _query($s); $_tahun = 'alksdjfasdf-asdf'; echo <<<ESD <table class=box cellspacing=1 width=600 align=center> ESD; echo "<tr>\r\n <td class=ul1 colspan=10>\r\n <input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$mhsw['MhswID']}', '', 0)\" />\r\n </td></tr>"; $hdr = "<tr><th class=ttl width=20>Nmr</th>\r\n <th class=ttl width=90>Kode</th>\r\n <th class=ttl>Matakuliah</th>\r\n <th class=ttl width=30>SKS</th>\r\n <th class=ttl width=30>Nilai</th>\r\n <th class=ttl width=30>Edit</th>\r\n </tr>"; while ($w = _fetch_array($r)) { if ($_tahun != $w['TahunID']) { $_tahun = $w['TahunID']; echo "<tr>\r\n <td class=ul1 colspan=10>\r\n <font size=+1>{$_tahun}</font>\r\n <!--<input type=button name='btnTambah' value='+ Tambah MK' onClick=\"javascript:fnEditKonversi(1, '{$w['MhswID']}', '{$_tahun}', 0)\" />-->\r\n </td></tr>"; echo $hdr; $n = 0; } $n++; if ($w['Setara'] == 'Y') { $btnEdit = "<input type=button name='btnEdit' value='»'\r\n onClick=\"fnEditKonversi(0, '{$w['MhswID']}', '{$w['TahunID']}', {$w['KRSID']})\" />"; } else { $btnEdit = "<abbr title='Bukan Konversi'><img src='img/flag2.gif' /></abbr>"; } echo <<<ESD <tr> <td class=inp>{$n}</td> <td class=ul>{$w['MKKode']}</td> <td class=ul>{$w['Nama']}</td> <td class=ul align=right>{$w['SKS']}</td> <td class=ul align=center>{$w['GradeNilai']}</td> <td class=ul align=center> {$btnEdit} </td> </tr> ESD; } RandomStringScript(); echo <<<ESD </form> </table> <script> function fnEditKonversi(md, mhsw, thn, id) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.edit.php?mhsw="+mhsw+"&md="+md+"&id="+id+"&thn="+thn+"&_rnd="+_rnd+"&ProdiID={$mhsw['ProdiID']}"; win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; }
function TampilkanDaftarMhsw() { $kls = $_SESSION['kelas'] == 'All' ? '' : "and m.KelasID = '{$_SESSION['kelas']}'"; $s = "select m.MhswID, m.Nama, m.PenasehatAkademik,k.Nama as Kls,\r\n d.Nama as NamaDosen, d.Gelar as GelarDosen\r\n from mhsw m\r\n left outer join dosen d on m.PenasehatAkademik = d.Login and d.KodeID = '" . KodeID . "'\r\n\t left outer join kelas k on m.KelasID = k.KelasID\r\n where m.KodeID = '" . KodeID . "'\r\n and m.ProdiID = '{$_SESSION['prodi']}'\r\n and m.TahunID = '{$_SESSION['angk']}'\r\n\t {$kls}\r\n order by m.MhswID"; $r = _query($s); $n = 0; echo <<<ESD <table class=box cellspacing=1 align=center width=800> <form name='frmPA' action='?' method=POST> <input type=hidden name='mnux' value='{$_SESSION['mnux']}' /> <input type=hidden name='gos' value='SimpanPA' /> <input type=hidden name='angk' value='{$_SESSION['angk']}' /> <input type=hidden name='prodi' value='{$_SESSION['prodi']}' /> <input type=hidden name='kelas' value='{$_SESSION['kelas']}' /> <tr> <td class=ul colspan=10> <input type=button name='btnRekapPA' value='Rekap PA' onClick="javascript:CetakRekapPA('{$_SESSION['prodi']}')" /> <input type=button name='btnDaftarPA' value='Daftar PA-Mhsw' onClick="javascript:CetakDaftarPA('{$_SESSION['prodi']}')" /> <!-- </td> <td class=ul colspan=5 align=right> --> <div align=right> <input type=text name='DosenID' value='{$w['DosenID']}' size=10 maxlength=50 /> <input type=text name='Dosen' value='{$w['Dosen']}' size=30 maxlength=50 onKeyUp="javascript:CariDosen('{$_SESSION['prodi']}', 'frmPA')" /> » <a href='#' onClick="javascript:CariDosen('{$_SESSION['prodi']}', 'frmPA')" />Cari...</a> | <a href='#' onClick="javascript:frmPA.DosenID.value='';frmPA.Dosen.value=''">Reset</a> <input type=submit name='btnSimpan' value='Set PA' /> </div> </td> </tr> <tr><th class=ttl width=30>Nmr</th> <th class=ttl width=100>NPM/NIM</th> <th class=ttl>Mahasiswa</th> <th class=ttl>Kelas</th> <th class=ttl>PA</th> <th class=ttl>Cek</th> </tr> ESD; while ($w = _fetch_array($r)) { $n++; $dsn = empty($w['PenasehatAkademik']) ? "<abbr title='Belum diset'>−</abbr>" : "{$w['NamaDosen']} <sup>{$w['GelarDosen']}</sup>"; echo <<<ESD <tr> <td class=inp>{$n}</td> <td class=ul>{$w['MhswID']}</td> <td class=ul>{$w['Nama']}</td> <td class=ul>{$w['Kls']} </td> <td class=ul width=200>{$dsn}</td> <td class=ul width=5> <input type=checkbox name='MhswID_{$n}' value='{$w['MhswID']}' /> </td> </tr> ESD; } RandomStringScript(); echo <<<ESD <input type=hidden name='JML' value='{$n}' /> </form> <tr><td class=ul colspan=5 align=right> <input type=button name='btnCheckAll' value='Centang Semua' onClick="javascript:CentangSemua({$n})" /> </td></tr> </table> <p> <div class='box0' id='caridosen'></div> <script> function toggleBox(szDivID, iState) // 1 visible, 0 hidden { if(document.layers)\t //NN4+ { document.layers[szDivID].visibility = iState ? "show" : "hide"; } else if(document.getElementById)\t //gecko(NN6) + IE 5+ { var obj = document.getElementById(szDivID); obj.style.visibility = iState ? "visible" : "hidden"; } else if(document.all)\t// IE 4 { document.all[szDivID].style.visibility = iState ? "visible" : "hidden"; } } function CariDosen(ProdiID, frm) { if (eval(frm + ".Dosen.value != ''")) { eval(frm + ".Dosen.focus()"); showDosen(ProdiID, frm, eval(frm +".Dosen.value"), 'caridosen'); toggleBox('caridosen', 1); } } function CentangSemua(n) { for (i = 1; i <= n; i++) { eval("frmPA.MhswID_" + i + ".checked = true"); } } function CetakRekapPA(prd) { _rnd = randomString(); lnk = "{$_SESSION['mnux']}.rekap.php?ProdiID="+prd+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } function CetakDaftarPA(prd) { lnk = "{$_SESSION['mnux']}.daftar.php?ProdiID="+prd+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=700, height=500, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } </script> ESD; }
<?php // Author : Irvandy Goutama // Start : 29 April 2008 // Email : irvandygoutama@gmail.com // *** Parameters *** $_statusmhswNama = GetSetVar('_statusmhswID'); $_statusmhswNama = GetSetVar('_statusmhswNama'); $_statusmhswProdi = GetSetVar('_statusmhswProdi'); $_statusmhswPrg = GetSetVar('_statusmhswPrg'); $_statusmhswNomer = GetSetVar('_statusmhswNomer'); $_statusmhswPage = GetSetVar('_statusmhswPage'); $_statusmhswUrut = GetSetVar('_statusmhswUrut', 1); $arrUrutMhsw = array('NIM~psm.MhswID asc, m.Nama', 'NIM (balik)~psm.MhswID desc, m.Nama', 'Nama~m.Nama'); RandomStringScript(); // *** Main *** TampilkanJudul("Pengurusan Status Mahasiswa"); $gos = empty($_REQUEST['gos']) ? 'StatusMhsw' : $_REQUEST['gos']; $gos(); // *** Functions *** function AmbilUrutanMhswID() { global $arrUrutMhsw; $a = ''; $i = 0; foreach ($arrUrutMhsw as $u) { $_u = explode('~', $u); $sel = $i == $_SESSION['_statusmhswUrut'] ? 'selected' : ''; $a .= "<option value='{$i}' {$sel}>" . $_u[0] . "</option>"; $i++; }
function HeaderTranskrip() { $MhswID = GetSetVar('MhswID'); TampilkanJudul("Cetak Transkrip Nilai"); $tombols = ' '; if (empty($_SESSION['MhswID'])) { $mhsw = array(); } else { $mhsw = GetFields("mhsw m \r\n left outer join prodi prd on m.ProdiID=prd.ProdiID and prd.KodeID='" . KodeID . "'\r\n\t\t\tleft outer join jenjang j on prd.JenjangID=j.JenjangID\r\n left outer join program prg on m.ProgramID=prg.ProgramID and prg.KodeID='" . KodeID . "'\r\n left outer join dosen d on m.PenasehatAkademik=d.Login and d.KodeID='" . KodeID . "'", "m.MhswID='{$_SESSION['MhswID']}' and m.KodeID", KodeID, "m.MhswID, m.Nama, m.ProgramID, m.ProdiID, m.PenasehatAkademik,\r\n d.Nama as NamaDosen, d.Gelar, j.Nama as _Jenjang,\r\n prd.Nama as _PRD, prg.Nama as _PRG"); $JmlData = GetaField('krs k left outer join jadwal j on k.JadwalID=j.JadwalID', "k.MhswID = '{$mhsw['MhswID']}' and k.Tinggi = '*' and k.SKS > 0 and k.NA = 'N' and k.KodeID", KodeID, "count(k.MKKode)") + 0; // jumlah data yang diload if (empty($mhsw)) { $mhsw = array(); } else { if (empty($mhsw['NamaDosen'])) { $mhsw['NamaDosen'] = "<font color=red>×</font> Belum diset"; } RandomStringScript(); $tombols = <<<ESD <input type=button name='btnTranskrip' value='Transkrip Nilai' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 0, '{$JmlData}')" /> \t\t\t<input type=button name='btnTranskrip' value='Transkrip Nilai Tanpa Kop' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 3, '{$JmlData}')" /> <input type=button name='btnTranskripPerJenis' value='Transkrip Per Jenis MK' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 1, '{$JmlData}')" /> <input type=button name='btnTranskrip' value='Transkrip Nilai Sementara' onClick="javascript:fnCetakTranskrip('{$mhsw['MhswID']}', 2, '{$JmlData}')" />\t <script> function fnCetakTranskrip(MhswID, jen, JmlData) {\t\t\t\t var _rnd = randomString();\t\t\t\t lnk = "{$_SESSION['mnux']}.php?gos=_CetakTranskrip&MhswID="+MhswID+"&_rnd="+_rnd+"&jen="+jen+"&JmlData="+JmlData; win2 = window.open(lnk, "", "width=700, height=500, scrollbars"); if (win2.opener == null) childWindow.opener = self; } \t\t\tfunction fnSubmit() { \t\t\t\tgosState = frmHeader.gosx.value; \t\t\t\tswitch (gosState) { \t\t\t\t\tcase '0': \t\t\t\t\t\t// cari \t\t\t\t\t\tfrmHeader.gos.value = '';\t\t\t\t\t\t \t\t\t\t\t\tbreak; \t\t\t\t\tcase '1': \t\t\t\t\t\t// simpan \t\t\t\t\t\tfrmHeader.gos.value = 'Simpan'; \t\t\t\t\t\tbreak; \t\t\t\t\tdefault: \t\t\t\t\t\t// cari \t\t\t\t\t\tfrmHeader.gos.value = ''; \t\t\t\t} \t\t\t\t//alert (frmHeader.gos.value); \t\t\t\tfrmHeader.submit(); \t\t\t} </script> ESD; } } echo "<form name='frmHeader' action='?' method=POST>\r\n\t<table class=box cellspacing=1 align=center width=600>\r\n <input type=hidden name='gos' value='' /> \r\n\t<input type=hidden name='gosx' value='0' /> \r\n\r\n <tr><td class=inp width=80>NIM/NPM:</td>\r\n <td class=ul width=220>\r\n <input type=text name='MhswID' value='{$_SESSION['MhswID']}' size=15 maxlength=50 />\r\n <input type=button name='btnCari' value='Cari' onClick=\"form.gosx.value='0'; fnSubmit();\" />\r\n </td>\r\n <td class=inp width=90>Nama Mhsw:</td>\r\n <td class=ul>\r\n <b>{$mhsw['Nama']}</b> \r\n </td>\r\n </tr>\r\n <tr><td class=inp>Prodi:</td>\r\n <td class=ul>{$mhsw['_PRD']} <sup>{$mhsw['_PRG']}</sup> </td>\r\n <td class=inp>Penasehat Akd:</td>\r\n <td class=ul>{$mhsw['NamaDosen']} <sup>{$mhsw['Gelar']}</sup> </td>\r\n </tr>\r\n <tr><td class=ul colspan=4 align=center>\r\n {$tombols}\r\n </td></tr>\r\n\t</table>"; /* Void Table */ // ------------- echo "<table class=box cellspacing=1 align=center width=800>"; $s = "select k.KRSID, k.MKKode, k.Nama, k.BobotNilai, k.GradeNilai, k.SKS, k.Tinggi, k.VoidOnTranskripBAA\r\n from krs k left outer join jadwal j on k.JadwalID=j.JadwalID\r\n where k.KodeID = '" . KodeID . "'\r\n and k.MhswID = '{$mhsw['MhswID']}'\r\n and k.Tinggi = '*'\r\n\t\t\tand k.SKS > 0\r\n\t\t\tand k.NA = 'N'\r\n order by k.MKKode"; echo "<tr>\r\n\t\t\t<th class=ttl width=5>No.</th>\t\t\t\t\t\r\n\t\t\t<th class=ttl width=10></th>\r\n\t\t\t<th class=ttl width=50>Kode MK</th>\r\n\t\t\t<th class=ttl width=200>Nama Mata Kuliah</th>\r\n\t\t\t<th class=ttl width=20>SKS</th>\r\n\t\t\t<th class=ttl width=20>Nilai</th>\r\n\t\t\t<!--<th class=ttl width=15>Bobot</th>\t\r\n\t\t\t<th class=ttl width=15>Mutu</th>-->\r\n\t\t\t<th class=ttl width=15>Keterangan</th>\r\n\t\t</tr>"; $r = _query($s); $n = 0; while ($w = _fetch_array($r)) { $n++; $mutu = $w['SKS'] * $w['BobotNilai']; $_nxk += $mutu; $_sks += $w['SKS']; $KRSID = $w['KRSID']; $MKKode = $w['MKKode']; $Nama = $w['Nama']; $SKS = $w['SKS']; $GradeNilai = $w['GradeNilai']; //$BobotNilai = $w['BobotNilai']; //$mutu = $mutu; //if ($w[''] != '') { // validasi empty /*if ($w[''] == '') { $TidakMemenuhiSyarat = true; $Keterangan = "x Kosong"; } else { $TidakMemenuhiSyarat = false; $w['Keterangan'] = ''; }*/ $VoidOnTranskripBAA = $w['VoidOnTranskripBAA']; if ($VoidOnTranskripBAA == 'Y') { // sudah divoid $TidakMemenuhiSyarat = true; $TampilkanBaris = true; $Keterangan = 'Sudah Di-Void'; } else { // belum divoid $TidakMemenuhiSyarat = false; $TampilkanBaris = true; $Keterangan = '-'; } if ($TidakMemenuhiSyarat) { $checkbox = "<input type=checkbox name='CheckBox{$n}' value='Y' title='Kosongkan untuk Mem-Void'>"; } else { $checkbox = "<input type=checkbox name='CheckBox{$n}' value='Y' checked=true title='Kosongkan untuk Mem-Void'>"; } $class = "cna" . ($TidakMemenuhiSyarat ? 'Y' : 'N'); if ($TampilkanBaris) { echo "<tr>\r\n\t\t\t\t\t\t<td class=inp>{$n}</td>\r\n\t\t\t\t\t\t<td class={$class} align=center>{$checkbox}<input type=hidden name='KRSID{$n}' value='{$KRSID}'></td>\r\n\t\t\t\t\t\t<td class={$class} align=center>{$MKKode}<input type=hidden name='MKKode{$n}' value='{$MKKode}'></td>\t\t\t\t\t\t\r\n\t\t\t\t\t\t<td class={$class} align=left>{$Nama}<input type=hidden name='Nama{$n}' value='{$Nama}'></td>\r\n\t\t\t\t\t\t<td class={$class} align=center>{$SKS}<input type=hidden name='SKS{$n}' value='{$SKS}'></td>\r\n\t\t\t\t\t\t<td class={$class} align=center>{$GradeNilai}<input type=hidden name='GradeNilai{$n}' value='{$GradeNilai}'></td>\r\n\t\t\t\t\t\t<td class={$class} align=center>{$Keterangan}</td>\r\n\t\t\t\t\t </tr>"; } else { echo ""; } //} // endif validasi empty } // endfor // Tampilkan summary-nya /*$p->SetFont('Helvetica', 'B', 6); $p->Cell(70, $t, 'JUMLAH:', 'LB', 0, 'R'); $p->Cell(24, $t, $_sks, 'BR', 0, 'C'); //$p->Cell(0, $t, '', 'BR', 0); //$p->Cell(1, $t, $_nxk, 'BR', 0, 'C');*/ echo "<input type=hidden name='JumlahData' value='{$n}'>"; echo "<tr><td class=ul1 align=center colspan=16><input type=button name='Simpan' value='Simpan' onClick=\"form.gosx.value='1'; fnSubmit();\"></td></tr>\t\r\n\t</table>"; /* End of Void Table */ echo "</form></p>"; }