<?php // Author : SIAKAD TEAM // Email : setio.dewo@gmail.com // Start : 26/11/2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Jadwal Ruang", 1); // *** Parameters *** $_jdwlRuang = GetSetVar('_jdwlRuang'); $_jdwlTgl_d = GetSetVar('_jdwlTgl_d', date('d')); $_jdwlTgl_m = GetSetVar('_jdwlTgl_m', date('m')); $_jdwlTgl_y = GetSetVar('_jdwlTgl_y', date('Y')); $_SESSION['_jdwlTgl'] = "{$_jdwlTgl_y}-{$_jdwlTgl_m}-{$_jdwlTgl_d}"; $_jdwlProdi = GetSetVar('_jdwlProdi'); $_jdwlProg = GetSetVar('_jdwlProg'); $_jdwlTahun = GetSetVar('_jdwlTahun'); $_jdwlHari = GetSetVar('_jdwlHari'); $_jdwlUjian = GetSetVar('_jdwlUjian', 2); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'DftrRuang' : $_REQUEST['gos']; $gos(); // *** Functions **** function DftrRuang() { TampilkanHeaderRuang(); $s = "select j.*,\r\n left(j.Nama, 50) as _Nama,\r\n left(j.{$_SESSION['_jdwlU']}JamMulai, 5) as _JM,\r\n left(j.{$_SESSION['_jdwlU']}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.TahunID = '{$_SESSION['_jdwlTahun']}'\r\n and j.{$_SESSION['_jdwlU']}RuangID = '{$_SESSION['_jdwlRuang']}'\r\n and j.{$_SESSION['_jdwlU']}Tanggal = '{$_SESSION['_jdwlTgl']}'\r\n order by j.{$_SESSION['_jdwlU']}JamMulai"; $r = _query($s); $n = 0; echo <<<ESD <table class=box cellspacing=1 width=100%>
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 22 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Gagal Penilaian"); // *** Parameters *** $id = $_REQUEST['id']; $jdwl = GetFields('jadwalremedial', 'JadwalRemedialID', $id, '*'); if ($jdwl['Final'] == 'Y') { die(ErrorMsg('Error', "Matakuliah sudah difinalisasi.")); } // *** Main *** TampilkanJudul("Gagal Penilaian"); $gos = empty($_REQUEST['gos']) ? "KonfirmasiGagal" : $_REQUEST['gos']; $gos($jdwl); // *** Functions *** function KonfirmasiGagal($jdwl) { $optnilai = GetOption2('nilai', "concat(Nama, ' (', Bobot, ')')", 'Bobot desc', '', "ProdiID='{$jdwl['ProdiID']}' ", "NilaiID"); echo Konfirmasi("Konfirmasi Gagal Penilaian", "<form action='../{$_SESSION['mnux']}.gagal.php' method=POST>\r\n <input type=hidden name='id' value='{$jdwl['JadwalRemedialID']}' />\r\n <input type=hidden name='gos' value='Gagalkan' />\r\n \r\n <p>Benar Anda akan menset gagal penilaian pada mata kuliah ini?\r\n Setelah digagalkan, mata kuliah akan difinalisasi dan sudah tidak dapat diubah nilainya.</p>\r\n \r\n <p>Nilai untuk semua mahasiswa:<br />\r\n <select name='NilaiGagal'>{$optnilai}</select></p>\r\n \r\n <p>Alasan penggagalan:<br />\r\n <textarea name='CatatanGagal' cols=40 rows=4></textarea></p>\r\n\r\n <hr size=1 color=silver />\r\n Opsi: <input type=submit name='GagalNilai' value='Gagalkan Penilaian' />\r\n <input type=button name='Batal' value='Batal' onClick=\"window.close()\" />\r\n </form>"); } function Gagalkan($jdwl) { $id = $_REQUEST['id']; $NilaiGagal = $_REQUEST['NilaiGagal']; if (empty($NilaiGagal)) { echo ErrorMsg("Nilai Belum Diset", "Anda harus mengeset nilai gagal penilaian dosen untuk matakuliah ini.<br>\r\n Proses Gagal Nilai Dosen tidak dilakukan."); } else {
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 23 September 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Daftarkan Wisudawan"); echo <<<SCR <script src="../{$_SESSION['mnux']}.wan.script.js"></script> SCR; // *** Parameters *** $TahunID = GetSetVar('TahunID'); $ProdiID = GetSetVar('ProdiID'); $md = $_REQUEST['md'] + 0; $id = $_REQUEST['id'] + 0; // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Edit' : $_REQUEST['gos']; $gos($md, $id); // *** Functions *** function arrayPrasyaratWisuda($w) { $def = explode(',', $w['Prasyarat']); $hsl = array(); $s = "select PrasyaratID, Nama\r\n from wisudaprasyarat\r\n where KodeID = '" . KodeID . "' and NA='N'\r\n order by PrasyaratID"; $r = _query($s); while ($w = _fetch_array($r)) { $ada = array_search($w['PrasyaratID'], $def); $ck = $ada === false ? '' : 'checked'; $hsl[] = "<input type=checkbox name='{$w['PrasyaratID']}' value='Y' {$ck} /> {$w['PrasyaratID']} → {$w['Nama']}"; }
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 SimpanPenilaian() { // Includes include "sisfokampus.php"; echo "<script language='JavaScript1.1'>\r\n window.resizeTo(400, 400);\r\n </script>"; HeaderSisfoKampus("Metode Penilaian Dosen"); // Parameter $JadwalID = $_REQUEST['JadwalID']; $Penilaian = $_REQUEST['Penilaian']; // Simpan $s = "update jadwal set Penilaian='{$Penilaian}' where JadwalID='{$JadwalID}' "; $r = _query($s); echo "<center><font size=+4>Berhasil</font></center>\r\n <hr size=1 color=silver>\r\n <p>Metode penilaian sudah disimpan, yaitu: <font size=+2>{$Penilaian}</font></p>\r\n <hr size=1 color=silver>\r\n <input type=button name='Tutup' value='Tutup' onClick=\"javascript:window.close()\">\r\n "; }
function CetakNilaiKlinik() { include "sisfokampus.php"; HeaderSisfoKampus(); $JadwalID = $_REQUEST['JadwalID']; $jdwl = GetFields("jadwal j\r\n left outer join rumahsakit rs on j.RuangID=rs.RSID", "JadwalID", $JadwalID, "j.*, rs.Nama as NamaRS"); // tampilkan header echo "<p><center><font size=+1>Daftar Nilai Matakuliah Klinik</font><br />\r\n <font size=+2>{$jdwl['Nama']} ({$jdwl['MKKode']})</font></center></p>"; $TM = FormatTanggal($jdwl['TglMulai']); $TS = FormatTanggal($jdwl['TglSelesai']); echo "<p><center>Rumah Sakit: <font size=+1>{$jdwl['NamaRS']}</font><br />\r\n Periode: <font size=+1>{$TM} ~ {$TS}</font></center></p>"; $s = "select k.KRSID, k.MhswID, m.Nama, k.GradeNilai, k.BobotNilai\r\n from krs k\r\n left outer join mhsw m on k.MhswID=m.MhswID\r\n where k.JadwalID='{$JadwalID}'\r\n order by k.MhswID"; $r = _query($s); $n = 0; echo "<p align=center><table class=box cellspacing=1>\r\n <tr><th class=ttl>No</th>\r\n <th class=ttl>N P M</th>\r\n <th class=ttl>Nama Mahasiswa</th>\r\n <th class=ttl>Grade<br />Nilai</th>\r\n <th class=ttl>Bobot<br />Nilai</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $n++; echo "<tr><td class=inp>{$n}</td>\r\n <td class=ul>{$w['MhswID']}</td>\r\n <td class=ul>{$w['Nama']}</td>\r\n <td class=ul align=center>{$w['GradeNilai']}</td>\r\n <td class=ul align=right>{$w['BobotNilai']}</td>\r\n </tr>"; } echo "</table></p>"; echo "<p align=center>Total Mahasiswa: <font size=+1>{$n}</font></p>"; echo "<script>window.print()</script>"; }
<?php //Author: Irvandy Goutama // Email: irvandygoutama@gmail.com session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("OPK Siswa"); TampilkanJudul("Pembagian Kelas Mahasiswa"); $gos = empty($_REQUEST['gos']) ? "EditKelas" : $_REQUEST['gos']; $gos(); 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');
<?php // Author: Emanuel Setio Dewo // 26 Sept 2006 // www.sisfokampus.net // Digunakan untuk menyalin semua KRS dari sebuah jadwal (Kuliah) ke jadwal lain (Responsi) include_once "sisfokampus.php"; HeaderSisfoKampus("Import Data KRS dari Jadwal ke Jadwal Lain"); // *** Functions *** function TampilkanHeaderJadwal() { echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <form action='?' method=POST>\r\n <input type=hidden name='gos' value='ProsesCopyKRS'>\r\n <tr><td class=inp>ID Jadwal 1</td><td class=ul><input type=text name='_JadwalID1' value='{$_SESSION['_JadwalID1']}' size=5 maxlength=10></td></tr>\r\n <tr><td class=inp>ID Jadwal 2</td><td class=ul><input type=text name='_JadwalID2' value='{$_SESSION['_JadwalID2']}' size=5 maxlength=10></td></tr>\r\n <tr><td class=ul colspan=2><input type=submit name='Simpan' value='Simpan'></td></tr>\r\n </form></table></p>"; } function ProsesCopyKRS() { $_JadwalID1 = $_REQUEST['_JadwalID1']; $_JadwalID2 = $_REQUEST['_JadwalID2']; $jdwl1 = GetFields('jadwal', 'JadwalID', $_JadwalID1, '*'); $jdwl2 = GetFields('jadwal', 'JadwalID', $_JadwalID2, '*'); echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <form action='?' method=POST>\r\n <input type=hidden name='gos' value='ProsesCopyKRS1'>\r\n <input type=hidden name='_JadwalID1' value='{$_JadwalID1}'>\r\n <input type=hidden name='_JadwalID2' value='{$_JadwalID2}'>\r\n <tr><td class=ttl colspan=2>KRS dari Jadwal yg Akan Disalin</td></tr>\r\n <tr><td class=inp>ID</td><td class=ul>{$_JadwalID1}</td></tr>\r\n <tr><td class=inp>Matakuliah</td><td class=ul>{$jdwl1['MKKode']} - {$jdwl1['Nama']} ({$jdwl1['SKS']})</td></tr>\r\n <tr><td class=inp>Kelas</td><td class=ul>{$jdwl1['NamaKelas']} ({$jdwl1['JenisJadwalID']})</td></tr>\r\n <tr><td class=inp>Jadwal</td><td class=ul>{$jdwl1['HariID']}, {$jdwl1['JamMulai']}-{$jdwl1['JamSelesai']}</td></tr>\r\n <tr><td class=inp>Jumlah KRS</td><td class=ul>{$jdwl1['JumlahMhsw']}</td></tr>\r\n \r\n <tr><td class=ttl colspan=2>Disalin ke Jadwal</td></tr>\r\n <tr><td class=inp>ID</td><td class=ul>{$_JadwalID2}</td></tr>\r\n <tr><td class=inp>Matakuliah</td><td class=ul>{$jdwl2['MKKode']} - {$jdwl2['Nama']} ({$jdwl2['SKS']})</td></tr>\r\n <tr><td class=inp>Kelas</td><td class=ul>{$jdwl2['NamaKelas']} ({$jdwl2['JenisJadwalID']})</td></tr>\r\n <tr><td class=inp>Jadwal</td><td class=ul>{$jdwl2['HariID']}, {$jdwl2['JamMulai']}-{$jdwl2['JamSelesai']}</td></tr>\r\n <tr><td class=inp>Jumlah KRS</td><td class=ul>{$jdwl2['JumlahMhsw']}</td></tr>\r\n <tr><td class=ul colspan=2><input type=submit name='Proses' value='Proses Copy'></td></tr>\r\n </form>\r\n </table></p>"; } function ProsesCopyKRS1() { $_JadwalID1 = $_REQUEST['_JadwalID1']; $_JadwalID2 = $_REQUEST['_JadwalID2']; $jdwl2 = GetFields('jadwal', 'JadwalID', $_JadwalID2, '*'); $s = "select *\r\n from krs\r\n where JadwalID='{$_JadwalID1}'\r\n order by MhswID"; $r = _query($s); $n = 0; echo "<ol>"; while ($w = _fetch_array($r)) {
<?php // Author : SIAKAD TEAM // Email : setio.dewo@gmail.com // Start : 04 Sept 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Setup Ujian Skripsi/TA", 1); echo <<<SCR <script src="../{$_SESSION['mnux']}.ujian.script.js"></script> SCR; // *** Parameters *** $TAID = GetSetVar('TAID'); // *** Main *** TampilkanJudul("Setup Ujian Skripsi/TA"); $gos = empty($_REQUEST['gos']) ? 'TampilkanSetupUjianTA' : $_REQUEST['gos']; $gos(); // *** Functions *** function TampilkanSetupUjianTA() { $ta = GetFields("ta t\n left outer join mhsw m on t.MhswID = m.MhswID and m.KodeID='" . KodeID . "'\n left outer join dosen d on d.Login = m.PenasehatAkademik and d.KodeID='" . KodeID . "'\n left outer join dosen d1 on d1.Login = t.Pembimbing and d1.KodeID='" . KodeID . "'\n ", "t.TAID", $_SESSION['TAID'], "t.*, m.Nama as NamaMhsw,\n date_format(t.TglMulai, '%d-%m-%Y') as _TglMulai,\n date_format(t.TglSelesai, '%d-%m-%Y') as _TglSelesai,\n d.Nama as NamaPA, d.Gelar as GelarPA,\n d1.Nama as NamaPembimbing, d1.Gelar as GelarPembimbing"); TampilkanHeaderTA($ta); TampilkanDosenPenguji($ta); } function TampilkanHeaderTA($ta) { $PA = empty($ta['NamaPA']) ? 'Belum diset' : "{$ta['NamaPA']} <sup>{$ta['GelarPA']}</sup>"; $_TglUjian = $ta['TglUjian'] == '0000-00-00' ? date('Y-m-d') : $ta['TglUjian']; $TglUjian = GetDateOption($_TglUjian, 'TglUjian'); $NamaPenguji = GetaField('dosen', "KodeID='" . KodeID . "' and Login", $ta['Penguji'], 'Nama'); echo <<<SCR
<?php // Author : SIAKAD TEAM // Email : setio.dewo@gmail.com // Start : 14 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; include_once "../{$_SESSION['mnux']}.lib.php"; HeaderSisfoKampus("Edit Jadwal Tambahan", 1); // *** infrastruktur ** echo <<<SCR <script src="../{$_SESSION['mnux']}.edit.script.js"></script> SCR; // *** Parameters *** // *** Special Parameters *** $md = $_REQUEST['md'] + 0; $jid = $_REQUEST['jid'] + 0; // JadwalID yang merupakan jadwal utama dari seluruh jadwal tambahan $krsid = $_REQUEST['krsid'] + 0; // KRSID dari krs yang menjadi krs pokok $krsresid = $_REQUEST['krsresid'] + 0; // KRSID dari krs tambahan yang telah diambil $jenis = $_REQUEST['jenis']; echo "MD: {$md}, JID: {$jid}, KRS: {$krsid}, KRSRES: {$krsresid}, JENIS: {$jenis}"; // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Edit' : $_REQUEST['gos']; $gos($md, $jid, $krsid, $krsresid, $jenis); // *** Functions *** function Edit($md, $jid, $krsid, $krsresid, $jenis) { if ($md == 0) {
<?php session_start(); include_once "sisfokampus.php"; HeaderSisfoKampus("Proses Hitung BIPOT Mahasiswa KBK"); // *** Functions *** function TampilkanHeaderProses() { $optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['prodi'], '', 'ProdiID'); echo "<p><table cellspacing=1 cellpadding=4>\r\n <form action='_proses_bipot_mhsw_kbk.php' method=POST>\r\n <input type=hidden name='gos' value='ProsesHitung'>\r\n <tr><td>Periode Akademik</td>\r\n <td><input type=text name='tahunak' value='{$_SESSION['tahunak']}' size=6 maxlength=5></td></tr>\r\n <tr><td>Angkatan</td>\r\n <td><input type=text name='tahun1' value='{$_SESSION['tahun1']}' size=6 maxlength=4></td></tr>\r\n <tr><td>Program Studi</td>\r\n <td><select name='prodi'>{$optprodi}</select></td></tr>\r\n <tr><td colspan=2><input type=submit name='Proses' value='Proses'></td></tr>\r\n </form></table></p>"; echo "<p><table cellpadding=4 cellspacing=1>\r\n <tr><td class=inp>Keterangan</td><td class=wrn>Pastikan Mahasiswa yang akan diproses BIPOT-nya telah memiliki Master BIPOT</td></tr></table></p>"; } function ProsesHitung() { $whr = ''; if (!empty($_SESSION['prodi'])) { $whr = "and k.ProdiID='{$_SESSION['prodi']}' "; } $s = "SELECT k.KHSID, m.MhswID, m.ProdiID, count( k.TahunID ) as JUM\r\n FROM khs k\r\n LEFT OUTER JOIN mhsw m ON k.MhswID = m.MhswID\r\n WHERE left( m.TahunID, 4 ) = '{$_SESSION['tahun1']}'\r\n AND k.TahunID = '{$_SESSION['tahunak']}'\r\n {$whr}\r\n GROUP BY k.MhswID"; $r = _query($s); $jml = _num_rows($r); $n = 0; echo "<hr><p>Jumlah data: <font size=+1>{$jml}</font></p>"; while ($w = _fetch_array($r)) { $n++; $_SESSION['KBK-MhswID-' . $_SESSION['prodi'] . $n] = $w['MhswID']; $_SESSION['KBK-KHSID-' . $_SESSION['prodi'] . $n] = $w['KHSID']; $_SESSION['KBK-JUM-' . $_SESSION['prodi'] . $n] = $w['JUM']; } $_SESSION['KBK-Max-' . $_SESSION['prodi']] = $jml; $_SESSION['KBK-Pos-' . $_SESSION['prodi']] = 0;
<?php // Copy MKSetara di suatu prodi include_once "sisfokampus.php"; HeaderSisfoKampus("Cek Denda & Pembayaran"); $s = "select mp.*\r\n from mkpra mp\r\n left outer join mk mk on mp.MKID=mk.MKID\r\n group by mp.MKID"; $r = _query($s); echo "<ol>"; while ($w = _fetch_array($r)) { echo "<li>{$w['MKKode']}\r\n </li>"; } echo "</ol>";
<?php // Author: SIAKAD TEAM // 20 Nov 2006 // Author: SIAKAD TEAM // www.sisfokampus.net session_start(); include_once "sisfokampus.php"; HeaderSisfoKampus("Proses Hitung SKS Mahasiswa"); // *** Functions *** function TampilkanHeaderProses() { $optprodi = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", 'ProdiID', $_SESSION['prodi'], '', 'ProdiID'); echo "<p><table cellspacing=1 cellpadding=4>\r\n <form action='_proses_hitung_sks_mhsw.php' method=POST>\r\n <input type=hidden name='gos' value='ProsesHitung'>\r\n <tr><td>Tahun Akademik</td>\r\n <td><input type=text name='tahun' value='{$_SESSION['tahun']}' size=6 maxlength=5></td></tr>\r\n <tr><td>Program Studi</td>\r\n <td><select name='prodi'>{$optprodi}</select></td></tr>\r\n <tr><td colspan=2><input type=submit name='Proses' value='Proses'></td></tr>\r\n </form></table></p>"; } function ProsesHitung() { $whr = ''; if (!empty($_SESSION['prodi'])) { $whr = "and ProdiID='{$_SESSION['prodi']}' "; } $s = "select KHSID, MhswID\r\n from khs\r\n where TahunID='{$_SESSION['tahun']}'\r\n {$whr}\r\n order by KHSID"; $r = _query($s); $jml = _num_rows($r); $n = 0; echo "<hr><p>Jumlah data: <font size=+1>{$jml}</font></p>"; while ($w = _fetch_array($r)) { $n++; $_SESSION['HTG-MhswID-' . $_SESSION['prodi'] . $n] = $w['MhswID']; $_SESSION['HTG-KHSID-' . $_SESSION['prodi'] . $n] = $w['KHSID']; }
} else { $s = "insert into asalsekolah (SekolahID, Nama, JenisSekolahID, Alamat1, Alamat2, Kota, KodePos, NA,\r\n Telephone, Fax, Website, Email, \r\n Kontak, JabatanKontak, HandphoneKontak, EmailKontak)\r\n values('{$SekolahID}', '{$Nama}', '{$JenisSekolahID}', '{$Alamat1}', '{$Alamat2}', '{$Kota}', '{$KodePos}', '{$NA}',\r\n '{$Telephone}', '{$Fax}', '{$Website}', '{$Email}',\r\n '{$Kontak}', '{$JabatanKontak}', '{$HandphoneKontak}', '{$EmailKontak}')"; $r = _query($s); } } TutupScript(); } function TutupScript() { echo <<<SCR <SCRIPT> function ttutup() { opener.location='../index.php?mnux={$_SESSION['mnux']}'; self.close(); return false; } ttutup(); </SCRIPT> SCR; } // *** Parameters *** session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Daftar Asal Sekolah", 1); $_asalsekPage = GetSetVar('_asalsekPage'); $asalsekolah = GetSetVar("NamaSekolah"); $kotasekolah = GetSetVar("KotaSekolah"); $gos = empty($_REQUEST['gos']) ? "SekEdt" : $_REQUEST['gos']; // *** Main *** TampilkanJudul("Daftar Asal Sekolah"); $gos();
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 21 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Skripsi/Tugas Akhir"); echo <<<SCR <script src="../{$_SESSION['mnux']}.edit.script.js"></script> SCR; // *** Parameters *** $TahunID = GetSetVar('TahunID'); $TAID = GetSetVar('TAID'); $md = GetSetVar('md'); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Edit' : $_REQUEST['gos']; $gos($md, $TAID); // *** Functions *** function Edit($md, $TAID) { if ($md == 0) { $jdl = "Edit: Skripsi/Tugas Akhir"; $w = GetFields('ta', 'TAID', $TAID, '*'); $w['NamaMhsw'] = GetaField('mhsw', "KodeID='" . KodeID . "' and MhswID", $w['MhswID'], 'Nama'); $w['DosenID'] = $w['Pembimbing']; $w['Dosen'] = GetaField('dosen', "KodeID='" . KodeID . "' and Login", $w['Pembimbing'], 'Nama'); $ro = "readonly=TRUE disabled=TRUE"; $edtMhsw = ""; // Apakah sudah lulus? if ($w['Lulus'] == 'Y') {
<?php // Author : SIAKAD TEAM // Email : setio.dewo@gmail.com // Start : 22 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Finalisasi Mata Kuliah", 1); // *** Parameters *** $id = $_REQUEST['id']; $jdwl = GetFields('jadwal', 'JadwalID', $id, '*'); if ($jdwl['Final'] == 'Y') { die(ErrorMsg('Error', "Matakuliah sudah difinalisasi.")); } // *** Main *** TampilkanJudul("Finalisasi Mata Kuliah"); $gos = empty($_REQUEST['gos']) ? "KonfirmasiFinalisasi" : $_REQUEST['gos']; $gos($jdwl); // *** Functions *** function KonfirmasiFinalisasi($jdwl) { echo Konfirmasi("Konfirmasi Finalisasi", "<p>Benar Anda akan memfinalisasi mata kuliah ini?<br />\n Setelah difinalisasi, mata kuliah sudah tidak dapat diubah nilainya.</p>\n \n <p>Cek sekali lagi. Lakukan <b>[Hitung Nilai]</b> untuk menghitung semua nilai mahasiswa.\n Baru setelah itu mata kuliah dapat difinalisasi.</p>\n\n <hr size=1 color=silver />\n Opsi: <input type=button name='Finalisasi' value='Finalisasi'\n onClick=\"location='../{$_SESSION['mnux']}.final.php?id={$jdwl['JadwalID']}&gos=Finalisasi'\" />\n <input type=button name='Batal' value='Batalkan' onClick=\"window.close()\" />"); } function Finalisasi($jdwl) { $id = $_REQUEST['id']; // finalisasi jadwal $s = "update jadwal \n set Final = 'Y', Gagal = 'N',\n TglEdit = now(), LoginEdit = '{$_SESSION['_Login']}'\n where JadwalID = {$id}"; $r = _query($s); // finalisasi krs $s = "update krs\n set Final = 'Y',\n TanggalEdit = now(), LoginEdit = '{$_SESSION['_Login']}'\n where JadwalID = {$id}";
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 08/10/2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Master Dosen"); // *** Parameters *** $TahunID = GetSetVar('TahunID'); $ProdiID = GetSetVar('ProdiID'); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Satu' : $_REQUEST['gos']; $gos(); // *** Functions *** function Satu() { echo <<<ESD <font size=+1>Master Dosen</font> <sup>MSDOS</sup><br /> <table class=box cellspacing=1 width=100%> <tr> <td>Anda akan mendownload data master dosen. Sistem hanya akan memproses data dosen yang aktif saja.<br /> Tekan tombol proses untuk memulai mengekspor data master dosen. </td> <td width=100 valign=top align=right> <input type=button name='Proses' value='Proses' onClick="location='../{$_SESSION['mnux']}.masterdosen.php?gos=Proses'" /> </td> </tr> </table>
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 14 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Jadwal Kuliah", 1); // *** infrastruktur ** echo <<<SCR <script src="../{$_SESSION['mnux']}.edit.script.js"></script> SCR; // *** Parameters *** $_utsTahun = GetSetVar('_utsTahun'); $_utsProdi = GetSetVar('_utsProdi'); $_utsProg = GetSetVar('_utsProg'); // *** Special Parameters *** $md = $_REQUEST['md'] + 0; $id = $_REQUEST['id'] + 0; $jutsid = $_REQUEST['jutsid'] + 0; // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Edit' : $_REQUEST['gos']; $gos($md, $id, $jutsid); // *** Functions *** function Edit($md, $id, $jutsid) { $w = GetFields('jadwal', 'JadwalID', $id, '*'); $w['Dosen'] = GetaField('dosen', "KodeID='" . KodeID . "' and Login", $w['DosenID'], 'Nama'); $w['_JM'] = substr($w['JamMulai'], 0, 5); $w['_JS'] = substr($w['JamSelesai'], 0, 5); $prodi = GetFields('prodi', "ProdiID='{$_SESSION['_utsProdi']}' and KodeID", KodeID, "*");
<?php // Author : Wisnu // Email : - // Start : 24 Maret 2009 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Daftar Bimbingan Skripsi/TA", 1); // *** Parameters *** // *** Main *** TampilkanJudul("Daftar Bimbingan Skripsi/TA"); $sub = empty($_REQUEST['sub']) ? 'TampilkanDaftarBimbinganTA' : $_REQUEST['sub']; $sub(); // *** Functions *** function TampilkanDaftarBimbinganTA() { $ta = GetFields("ta t\r\n left outer join mhsw m on t.MhswID = m.MhswID and m.KodeID='" . KodeID . "'\r\n left outer join dosen d on d.Login = m.PenasehatAkademik and d.KodeID='" . KodeID . "'\r\n left outer join dosen d1 on d1.Login = t.Pembimbing and d1.KodeID='" . KodeID . "'\r\n ", "t.TAID", $_REQUEST['TAID'], "t.*, m.Nama as NamaMhsw,\r\n date_format(t.TglMulai, '%d-%m-%Y') as _TglMulai,\r\n date_format(t.TglSelesai, '%d-%m-%Y') as _TglSelesai,\r\n d.Nama as NamaPA, d.Gelar as GelarPA,\r\n d1.Nama as NamaPembimbing, d1.Gelar as GelarPembimbing"); TampilkanHeaderBimbingan($ta); } function TampilkanHeaderBimbingan($ta) { $PA = empty($ta['NamaPA']) ? 'Belum diset' : "{$ta['NamaPA']} <sup>{$ta['GelarPA']}</sup>"; $ss = "select td.* from tadosen td\r\n\t\t\tleft outer join ta t on td.TAID = t.TAID\r\n\t\t\twhere t.TAID = '" . $td[TAID] . "'\r\n\t\t\tand t.NA = 'N'"; $qss = _query($ss); $rd = 'readonly=TRUE'; if (_num_rows($qss) != 0) { $s = "select td.Nilai from tadosen td\r\n\t\t\t\tleft outer join ta t on td.TAID = t.TAID\r\n\t\t\t\twhere t.TAID = '" . $ta[TAID] . "'\r\n\t\t\t\tand td.Nilai != '0.00'\r\n\t\t\t\tand t.NA = 'N'"; $qs = _query($s); $TglUjian = _num_rows($qs) == 0 ? $TglUjian : substr($ta[_TglUjian], 0, 10); $JamUjian = _num_rows($qs) == 0 ? $JamUjian : substr($ta[_JamUjian], 0, 5); $rd = _num_rows($qs) == 0 ? '' : 'readonly=true';
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 14 Agustus 2008 session_start(); include_once "../sisfokampus1.php"; include_once "../{$_SESSION['mnux']}.lib.php"; HeaderSisfoKampus("Tarik Pembayaran"); // *** Parameters *** //function ByrEdit(mhswid, khsid, md, bayarid) $MhswID = sqling($_REQUEST['MhswID']); $KHSID = $_REQUEST['KHSID'] + 0; $md = $_REQUEST['md'] + 0; $BayarID = sqling($_REQUEST['BayarID']); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Edit' : $_REQUEST['gos']; $gos($MhswID, $KHSID, $md, $BayarID); // *** Functions *** 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;
<?php // Author: Emanuel Setio Dewo // 2006-09-16 include_once "sisfokampus.php"; HeaderSisfoKampus("Set KHSID di KRS"); // *** Functions *** function TampilkanPesan() { echo "<p>Script ini akan mengeset field KHSID di tabel _krs.\r\n Setelah di set tabel _krs siap untuk diexport ke tabel krs.</p>\r\n \r\n <p><form action='?'>\r\n <input type=hidden name='gos' value='ProsesKHSID'>\r\n Tahun: <input type=text name='tahun' value='{$_SESSION['tahun']}' size=10 maxlength=10>\r\n <input type=submit name='Proses' value='Proses'>\r\n </form>"; } function ProsesKHSID() { // // Hilangkan filter ProdiID='' jika ingin semua data!!! // $s = "select KHSID, MhswID\r\n from khs\r\n where TahunID='{$_SESSION['tahun']}'\r\n and ProdiID in ('10', '11')\r\n order by MhswID"; $r = _query($s); echo "<p>Berikut adalah daftar mhsw yg diset.</p>"; echo "<ol>"; while ($w = _fetch_array($r)) { $s1 = "update _krs \r\n set KHSID='{$w['KHSID']}' \r\n where TahunID='{$_SESSION['tahun']}' \r\n and KHSID=0\r\n and MhswID='{$w['MhswID']}' "; $r1 = _query($s1); $kena = _affected_rows($r1); echo "<li>{$w['MhswID']} » {$kena}</li>"; } echo "</ol>"; } // *** Parameters *** $tahun = GetSetVar('tahun', '20061'); $gos = empty($_REQUEST['gos']) ? "TampilkanPesan" : $_REQUEST['gos'];
<?php // Author: Emanuel Setio Dewo // 25 Sept 2006 // www.sisfokampus.net session_start(); include_once "sisfokampus.php"; HeaderSisfoKampus("Import Pembayaran dari Tabel _pembayaran"); // *** Functions *** function TampilkanTahun() { TampilkanJudul("Proses Hitung Jumlah MK & SKS Mahasiswa"); echo "<p><form action='?' method=POST>\r\n <input type=hidden name='gos' value='Hitung'>\r\n Tahun: <input type=text name='tahun' value='{$_SESSION['tahun']}'>\r\n <input type=submit name='Proses' value='Proses Hitung'>\r\n </form></p>"; } function Hitung() { $s = "select TahunID, KHSID, MhswID, StatusMhswID\r\n from khs\r\n where TahunID='{$_SESSION['tahun']}'\r\n and ProdiID = '10'\r\n order by MhswID"; $r = _query($s); $jml = _num_rows($r); $n = 0; while ($w = _fetch_array($r)) { $n++; $_SESSION['HTG-KHSID-' . $n] = $w['KHSID']; $_SESSION['HTG-MhswID-' . $n] = $w['MhswID']; $_SESSION['HTG-Status-' . $n] = $w['StatusMhswID']; } $_SESSION['HTG-TOTAL'] = $jml; $_SESSION['HTG-POS'] = 0; $_jml = number_format($jml); echo "<p>Ada <font size=+1>{$_jml}</font> data.</p>"; echo "<p><IFRAME SRC='_proses_hitung_jumlah_mk_sks_mhsw.php?gos=Hitung1' frameborder=0 height=400 width=100%>\r\n </IFRAME></p>";
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 26/12/2008 session_start(); include_once "sisfokampus.php"; HeaderSisfoKampus("Perbaiki Data Pembayaran Mhsw"); // *** Main *** TampilkanJudul("Perbaiki Status Data Pembayaran Mahasiswa"); $gos = empty($_REQUEST['gos']) ? "fnKonfirmasi" : $_REQUEST['gos']; $gos(); /// *** Functions *** function fnKonfirmasi() { echo Konfirmasi("Konfirmasi", "Anda akan memperbaiki status detail pembayaran Mhsw.<br />\r\n Klik tombol di bawah ini untuk memulainya.\r\n <hr size=1 color=silver />\r\n <input type=button name='btnProses' value='Proses'\r\n onClick=\"location='?gos=fnProses'\" />"); } function fnProses() { $s = "select *\r\n from bayarmhsw\r\n order by BayarMhswID"; $r = _query($s); while ($w = _fetch_array($r)) { echo "Check <b>{$w['BayarMhswID']}</b>. Status: <b>{$w['NA']}.<br />"; echo "<blockquote>"; if ($w['NA'] == 'N') { CheckApakahDetailnyaDouble($w); } else { BunuhDetailnya($w); } echo "</blockquote>"; }
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 08/10/2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Data Mahasiswa Yang Lulus"); // *** Parameters *** $TahunID = GetSetVar('TahunID'); $ProdiID = GetSetVar('ProdiID'); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Satu' : $_REQUEST['gos']; $gos(); // *** Functions *** function Satu() { echo <<<ESD <font size=+1>Data Mahasiswa Yang Lulus</font> <sup>TRLSM</sup><br /> <table class=box cellspacing=1 width=100%> <tr><td> Anda akan mengexport data kelulusan mahasiswa.<br /> Sistem akan memproses data kelulusan dari tahun akademik yang telah ditentukan di atas.<br /> Status Mhsw yang akan diproses: <b>L</b>ulus, <b>C</b>uti, <b>N</b>on-aktif.<br /> Tekan tombol Proses untuk memulai proses export. </td> <td width=80 align=right valign=top> <input type=button name='Proses' value='Proses' onClick="location='../{$_SESSION['mnux']}.lulusmhsw.php?gos=Proses'" /> </td> </tr>
<?php // Author: Irvandy Goutama // Email: irvandygoutama@gmail.com // Start: 29/12/2009 session_start(); include_once "../sisfokampus1.php"; include_once "../util.lib.php"; include_once "krs.lib.php"; HeaderSisfoKampus("Upload Data MhswID (dari format excel)"); //$TahunIDup = GetSetVar('TahunIDup'); //$ProdiIDup = GetSetVar('ProdiIDup'); //$JenisTAIDup = GetSetVar('JenisTAIDup'); // Parameter (that can be changed to fulfill the system's requirements $BatasWaktuLebihAwal = "00:15:00"; // Code starts here: $gos = empty($_REQUEST['gos']) ? "Migration" : $_REQUEST['gos']; $gel = $_REQUEST['gel']; $Sync = $_REQUEST['Sync']; // *** Main *** if ($Sync == 1) { TampilkanJudul("Sinkronisasi Migrasi Data - MhswID 20121"); } else { TampilkanJudul("Migrasi Data - Master Ruang"); } $gos($gel, $Sync); // *** Functions *** function Migration($gel, $Sync) { //$opttahunup = GetOptionTahun($_SESSION['TahunIDup']); //$optprodiup = GetProdiUser($_SESSION['_Login'], $_SESSION['ProdiIDup']);
<?php // Author : SIAKAD TEAM // Email : setio.dewo@gmail.com // Start : 12/12/2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Konversi Matakuliah"); // *** Parameters *** $KRSID = $_REQUEST['KRSID']; $MhswID = $_REQUEST['MhswID']; // *** Main *** $gos = empty($_REQUEST['gos']) ? "fnKonversikan" : $_REQUEST['gos']; $gos($KRSID, $MhswID); // *** Functions *** function fnKonversikan($KRSID, $MhswID) { $krs = GetFields('krs', 'KRSID', $KRSID, '*'); $mhsw = GetFields('mhsw', "MhswID='{$MhswID}' and KodeID", KodeID, '*'); $optnilai = GetOption2('nilai', "concat(Nama, ' … ', Bobot)", 'Bobot desc', '', "ProdiID='{$mhsw['ProdiID']}'", 'NilaiID'); TampilkanJudul("Konversi Matakuliah"); CheckFormScript("TahunID,MKID,NilaiID"); echo <<<ESD <table class=box cellspacing=1 width=100%> <tr><td class=inp>Tahun Akd:</td> <td class=ul>{$krs['TahunID']}</td> <td class=inp>Mhsw:</td> <td class=ul>{$mhsw['Nama']} <sup>{$MhswID}</sup></td> </tr> <tr><td class=inp>Kode:</td> <td class=ul>{$krs['MKKode']}</td>
<?php // Author : Irvandy Goutama // Email : irvandygoutama@gmail.com // Start : 12 Juli 2009 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Tempat dan Waktu Wawancara", 1); // *** Parameters *** $pmbid = $_REQUEST['pmbid']; $urutan = $_REQUEST['urutan'] + 0; $wawancarausmid = $_REQUEST['wawancarausmid'] + 0; $gel = $_REQUEST['gel']; $ruangid = $_REQUEST['ruangid']; $jam = $_REQUEST['jam']; $arrJam = explode('/', $jam); //Cek apakah sudah ada $ada = GetaField('wawancara', "PMBID='{$pmbid}' and PMBPeriodID='{$gel}' and KodeID", KodeID, 'WawancaraID'); if (empty($ada)) { $s = "insert into wawancara set PMBID='{$pmbid}', \r\n\t\t\t\t\t\t\t\t\tWawancaraUSMID='{$wawancarausmid}',\r\n\t\t\t\t\t\t\t\t\tJamMulaiWawancara = '{$arrJam['0']}',\r\n\t\t\t\t\t\t\t\t\tJamSelesaiWawancara = '{$arrJam['1']}',\r\n\t\t\t\t\t\t\t\t\tPMBPeriodID='{$gel}',\r\n\t\t\t\t\t\t\t\t\tRuangID='{$ruangid}',\r\n\t\t\t\t\t\t\t\t\tUrutanDiRuang='{$urutan}',\r\n\t\t\t\t\t\t\t\t\tKodeID='" . KodeID . "',\r\n\t\t\t\t\t\t\t\t\tTanggalBuat=now(),\r\n\t\t\t\t\t\t\t\t\tLoginBuat='{$_SESSION['_Login']}'"; $r = _query($s); } else { $wawancara = GetFields('wawancara', "WawancaraID='{$ada}' and KodeID", KodeID, '*'); if ($wawancara['RuangID'] != $ruangid or $wawancara['UrutanDiRuang'] != $urutan) { //$s = "delete from ruangusm where RuangUSMID='$ada'"; //$r = _query($s); $s = "update wawancara set RuangID='{$ruangid}',\r\n\t\t\t\t\t\t\t\t\tUrutanDiRuang='{$urutan}',\r\n\t\t\t\t\t\t\t\t\tJamMulaiWawancara = '{$arrJam['0']}',\r\n\t\t\t\t\t\t\t\t\tJamSelesaiWawancara = '{$arrJam['1']}',\r\n\t\t\t\t\t\t\t\t\tKodeID='" . KodeID . "',\r\n\t\t\t\t\t\t\t\t\tTanggalEdit=now(),\r\n\t\t\t\t\t\t\t\t\tLoginEdit='{$_SESSION['_Login']}' where WawancaraID='{$ada}'"; $r = _query($s); } else { $s = "update wawancara set UrutanDiRuang='{$urutan}',\r\n\t\t\t\t\t\t\t\t\tJamMulaiWawancara = '{$arrJam['0']}',\r\n\t\t\t\t\t\t\t\t\tJamSelesaiWawancara = '{$arrJam['1']}',\r\n\t\t\t\t\t\t\t\t\tKodeID='" . KodeID . "',\r\n\t\t\t\t\t\t\t\t\tTanggalEdit=now(),\r\n\t\t\t\t\t\t\t\t\tLoginEdit='{$_SESSION['_Login']}' where WawancaraID='{$ada}'"; $r = _query($s);
<?php // Author: Emanuel Setio Dewo // 22 Sept 2006 // Description: Untuk menambahkan KRS secara masal. // Masukkan JadwalID dan karakter pertama MhswID include "sisfokampus.php"; HeaderSisfoKampus("Input KRS Masal Berdasarkan Jadwal & Angkatan"); // *** Functions *** function TampilkanInputJadwal() { echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <form action='?' method=POST>\r\n <input type=hidden name='gos' value='TampilkanDaftarMhsw'>\r\n <tr><td class=inp>ID Jadwal</td>\r\n <td class=ul><input type=text name='JadwalID' value='{$_SESSION['JadwalID']}' size=10 maxlength=10></td></tr>\r\n \r\n <tr><td class=inp>N.P.M (6 digit)</td>\r\n <td class=ul><input type=text name='MhswIDPart' value='{$_SESSION['MhswIDPart']}' size=20 maxlength=20></td></tr>\r\n <tr><td class=ul colspan=2><input type=submit name='Tampilkan' value='Tampilkan Daftar Mhsw'></td></tr>\r\n </form>\r\n </table></p>"; } function TampilkanDaftarMhsw() { $s = "select MhswID, KHSID\r\n from khs\r\n where MhswID like '{$_SESSION['MhswIDPart']}%'\r\n order by MhswID"; $r = _query($s); echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <form action='?' method=POST>\r\n <input type=hidden name='gos' value='ProsesSekarang'>\r\n <input type=hidden name='MhswIDPart' value='{$_SESSION['MhswIDPart']}'>\r\n <input type=hidden name='JadwalID' value='{$_SESSION['JadwalID']}'>\r\n <tr><td class=ul colspan=4><input type=submit name='Proses' value='Proses Sekarang'></td></tr>\r\n <tr><th class=ttl>#</th>\r\n <th class=ttl>Cek</th>\r\n <th class=ttl>N.P.M</th>\r\n <th class=ttl>KHSID</th>\r\n </tr>"; $n = 0; while ($w = _fetch_array($r)) { $n++; echo "<tr><td class=inp>{$n}</td>\r\n <td class=ul><input type=checkbox name='KHSID[]' value={$w['KHSID']} checked></td>\r\n <td class=ul>{$w['MhswID']}</td>\r\n <td class=ul>{$w['KHSID']}</td>\r\n </tr>"; } echo "<tr><td class=ul colspan=4><input type=submit name='Proses' value='Proses Sekarang'></td></tr>"; echo "</form></table>"; } function ProsesSekarang() { $JadwalID = $_REQUEST['JadwalID']; $jdwl = GetFields('jadwal', 'JadwalID', $JadwalID, '*'); $MhswIDPart = $_REQUEST['MhswIDPart'];
<?php // Author : Emanuel Setio Dewo // Email : setio.dewo@gmail.com // Start : 08/10/2008 session_start(); include_once "../sisfokampus1.php"; HeaderSisfoKampus("Aktivitas Mahasiswa"); // *** Parameters *** $TahunID = GetSetVar('TahunID'); $ProdiID = GetSetVar('ProdiID'); $DariMhsw = GetSetVar('DariMhsw'); $SampaiMhsw = GetSetVar('SampaiMhsw'); // *** Main *** $gos = empty($_REQUEST['gos']) ? 'Satu' : $_REQUEST['gos']; $gos(); // *** Functions *** function Satu() { echo <<<ESD <font size=+1>Aktivitas Mahasiswa</font> <sup>TRAKM</sup><br /> <table class=box cellspacing=1 width=99%> <form action='../{$_SESSION['mnux']}.mhsw.php' method=POST> <tr> <td width=200 valign=top> Dari NIM:<br /> <input type=text name='DariMhsw' value='{$_SESSION['DariMhsw']}' size=20 maxlength=50 /> <font color=red>*)</font> </td> <td width=200 valign=top>
<?php // Author: SIAKAD TEAM // 23 Nov 2006 // www.sisfokampus.net include "sisfokampus.php"; include "klinik.lib.php"; HeaderSisfoKampus("Detail Pembayaran Matakuliah Klinis"); echo "<SCRIPT>window.resizeTo(500, 500)</SCRIPT>"; $MhswID = $_REQUEST['MhswID']; $mhsw = GetFields('mhsw', 'MhswID', $MhswID, '*'); TampilkanJudul("Detail Pembayaran Mahasiswa"); TampilkanHeaderMhswKlinik($mhsw); $s = "select bm.*\r\n from bayarmhsw bm\r\n where MhswID='{$MhswID}'\r\n order by bm.Tanggal"; $r = _query($s); $n = 0; echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr><th class=ttl>No</th>\r\n <th class=ttl>B.P.M</th>\r\n <th class=ttl>Ke<br />Rekening</th>\r\n <th class=ttl>Bukti<br />Setoran</th>\r\n <th class=ttl>Tanggal<br />Setor</th>\r\n <th class=ttl>Tanggal<br />Entry</th>\r\n <th class=ttl>Jumlah</th>\r\n <th class=ttl>Keterangan</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $n++; $Tanggal = FormatTanggal($w['Tanggal']); $TanggalEntry = FormatTanggal($w['TanggalBuat']); $JML = number_format($w['Jumlah']); echo "<tr>\r\n <td class=inp>{$n}</td>\r\n <td class=ul>{$w['BayarMhswID']}</td>\r\n <td class=ul>{$w['RekeningID']} </td>\r\n <td class=ul>{$w['BuktiSetoran']} </td>\r\n <td class=ul>{$Tanggal} </td>\r\n <td class=ul>{$TanggalEntry} </td>\r\n <td class=ul align=right>{$JML} </td>\r\n <td class=ul>{$w['Keterangan']} </th>\r\n </tr>"; } echo "</table></p>"; echo "<p>Opsi: <input type=button name='Tutup' value='Tutup' onClick='window.close()'></p>";