Ejemplo n.º 1
2
<?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%>
Ejemplo n.º 2
1
<?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 {
Ejemplo n.º 3
1
<?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']} &#8594; {$w['Nama']}";
    }
Ejemplo n.º 4
0
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>";
}
Ejemplo n.º 5
0
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>";
}
Ejemplo n.º 7
0
<?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');
Ejemplo n.º 8
0
<?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)) {
Ejemplo n.º 9
0
<?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
Ejemplo n.º 10
0
<?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) {
Ejemplo n.º 11
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;
Ejemplo n.º 12
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'];
    }
Ejemplo n.º 14
0
        } 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();
Ejemplo n.º 15
0
<?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') {
Ejemplo n.º 16
0
<?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}";
Ejemplo n.º 17
0
<?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>
Ejemplo n.º 18
0
<?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, "*");
Ejemplo n.º 19
0
<?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';
Ejemplo n.º 20
0
<?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;
Ejemplo n.º 21
0
<?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']} &raquo; {$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>";
    }
Ejemplo n.º 24
0
<?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>
Ejemplo n.º 25
0
<?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'];
Ejemplo n.º 29
0
<?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>
Ejemplo n.º 30
-1
<?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']}&nbsp;</td>\r\n    <td class=ul>{$w['BuktiSetoran']}&nbsp;</td>\r\n    <td class=ul>{$Tanggal}&nbsp;</td>\r\n    <td class=ul>{$TanggalEntry}&nbsp;</td>\r\n    <td class=ul align=right>{$JML}&nbsp;</td>\r\n    <td class=ul>{$w['Keterangan']}&nbsp;</th>\r\n  </tr>";
}
echo "</table></p>";
echo "<p>Opsi: <input type=button name='Tutup' value='Tutup' onClick='window.close()'></p>";