function Proses()
{
// Buat DBF
include_once "../{$_SESSION['mnux']}.header.dbf.php";
include_once "../func/dbf.function.php";
$NamaFile = "../tmp/TRLSM_{$_SESSION['TahunID']}.DBF";
$_SESSION['lmhsw_dbf'] = $NamaFile;
$_SESSION['lmhsw_part'] = 0;
$_SESSION['lmhsw_counter'] = 0;
$_SESSION['lmhsw_total'] = HitungData();
if (file_exists($NamaFile)) {
unlink($NamaFile);
}
DBFCreate($NamaFile, $HeaderKelulusanMhsw);
// tampilkan
$ro = "readonly=true";
echo <<<ESD
<font size=+1>Proses Data Kelulusan Mahasiswa...</font> (<b>{$_SESSION['lmhsw_total']}</b> data)<br />
<table class=box cellspacing=1 width=100%>
<form name='frmMhsw'>
<tr>
<td valign=top width=10>
Counter:<br />
<input type=text name='Counter' size=4 {$ro} />
</td>
<td valign=top width=20>
NIP:<br />
<input type=text name='MhswID' size=10 {$ro} />
</td>
<td valign=top>
Nama Mhsw:<br />
<input type=text name='NamaMhsw' size=30 {$ro} />
</td>
<td valign=top align=right width=30>
<input type=button name='Batal' value='Batal'
onClick="location='../{$_SESSION['mnux']}.lulusmhsw.php?gos='" />
</td>
</tr>
</form>
</table>
<br />
<script>
function Kembali() {
window.onLoad=setTimeout("window.location='../{$_SESSION['mnux']}.lulusmhsw.php?gos=Selesai'", 0);
}
function Prosesnya(cnt, id, nama) {
frmMhsw.Counter.value = cnt;
frmMhsw.MhswID.value = id;
frmMhsw.NamaMhsw.value = nama;
}
</script>
<iframe src="../{$_SESSION['mnux']}.lulusmhsw.php?gos=ProsesDetails" width=90% height=50 frameborder=0 scrolling=no>
</iframe>
ESD;
}
function Proses()
{
// Buat DBF
include_once "../{$_SESSION['mnux']}.header.dbf.php";
include_once "../func/dbf.function.php";
$NamaFile = "../tmp/TBKMK_{$_SESSION['TahunID']}.DBF";
$_SESSION['kmk_dbf'] = $NamaFile;
$_SESSION['kmk_part'] = 0;
$_SESSION['kmk_counter'] = 0;
$_SESSION['kmk_total'] = HitungData();
if (file_exists($NamaFile)) {
unlink($NamaFile);
}
DBFCreate($NamaFile, $HeaderMatakuliah);
// tampilkan
$ro = "readonly=true";
echo <<<ESD
<font size=+1>Proses Master Kurikulum » Matakuliah...</font> (<b>{$_SESSION['kmk_total']}</b> data)<br />
<table class=box cellspacing=1 width=100%>
<form name='frmDsn'>
<tr>
<td valign=top width=10>
Counter:<br />
<input type=text name='Counter' size=4 {$ro} />
</td>
<td valign=top width=20>
Kode MK:<br />
<input type=text name='MKKode' size=10 {$ro} />
</td>
<td valign=top>
Matakuliah:<br />
<input type=text name='Matakuliah' size=30 {$ro} />
</td>
<td align=right valign=top>
<input type=button name='btnBatal' value='Batal'
onClick="location='../{$_SESSION['mnux']}.kmk.php?gos='" />
</td>
</tr>
</form>
</table>
<br />
<script>
function Kembali() {
window.onLoad=setTimeout("window.location='../{$_SESSION['mnux']}.kmk.php?gos=Selesai'", 0);
}
function Prosesnya(cnt, id, nama) {
frmDsn.Counter.value = cnt;
frmDsn.MKKode.value = id;
frmDsn.Matakuliah.value = nama;
}
</script>
<iframe src="../{$_SESSION['mnux']}.kmk.php?gos=ProsesDetails" width=90% height=50 frameborder=0 scrolling=no>
</iframe>
ESD;
}
function CreateDBFMHS()
{
global $HeaderMSHS;
if (!empty($_SESSION['DariNPM'])) {
$_SESSION['SampaiNPM'] = empty($_SESSION['SampaiNPM']) ? $_SESSION['DariNPM'] : $_SESSION['SampaiNPM'];
$_npm = "'{$_SESSION['DariNPM']}' <= MhswID and MhswID <= '{$_SESSION['SampaiNPM']}' ";
} else {
$drmhsw = GetaField('mhsw', "NA", "N", "min(MhswID)");
$smpmhsw = GetaField('mhsw', "NA", "N", "max(MhswID)");
$_npm = "'{$drmhsw}' <= MhswID and MhswID <= '{$smpmhsw}' ";
}
$s = "select MhswID\r\n from mhsw\r\n where {$_npm}\r\n\t\torder by MhswID";
$r = _query($s);
$n = 0;
$DBFName = "dikti/MHMHS-20062.DBF";
DBFCreate($DBFName, $HeaderMSHS);
while ($w = _fetch_array($r)) {
$n++;
$_SESSION["DBF-MHSWID-{$n}"] = $w['MhswID'];
}
$_SESSION["DBF-FILES"] = $DBFName;
$_SESSION["DBF-POS"] = 0;
$_SESSION["DBF-MAX"] = $n;
echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
echo "<p><IFRAME src='dikti.mastermhsw.go.php' frameborder=0 height=400 width=600>\r\n </IFRAME></p>";
}
function CreateDBFNilaiMhsw()
{
global $HeaderTRNLM;
if (!empty($_SESSION['DariNPM'])) {
$_SESSION['SampaiNPM'] = empty($_SESSION['SampaiNPM']) ? $_SESSION['DariNPM'] : $_SESSION['SampaiNPM'];
$_npm = "'{$_SESSION['DariNPM']}' <= MhswID and MhswID <= '{$_SESSION['SampaiNPM']}' ";
} else {
$_npm = '';
}
$_prd = empty($_SESSION['prodi']) ? "" : "and ProdiID = '{$_SESSION['prodi']}'";
$s = "select MhswID\r\n from khs\r\n where \r\n\t\t\t TahunID = '{$_SESSION['tahun']}' {$_prd} {$_npm}\r\n\t\t\t and StatusMhswID in ('A', 'C')\r\n\t\torder by MhswID";
$r = _query($s);
$n = 0;
$DBFName = "dikti/TRNLM-{$_SESSION['tahun']}.DBF";
DBFCreate($DBFName, $HeaderTRNLM);
while ($w = _fetch_array($r)) {
$n++;
$_SESSION["DBF-MHSWID-{$n}"] = $w['MhswID'];
}
$_SESSION["DBF-TAHUN"] = $_SESSION['tahun'];
$_SESSION["DBF-FILES"] = $DBFName;
$_SESSION["DBF-POS"] = 0;
$_SESSION["DBF-MAX"] = $n;
echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
echo "<p><IFRAME src='dikti.nilaimhsw.go.php' frameborder=0 height=400 width=600>\r\n </IFRAME></p>";
}
function CreateDBFDSN()
{
global $HeaderMSDOS;
if (!empty($_SESSION['DariDSN'])) {
$_SESSION['SampaiDSN'] = empty($_SESSION['SampaiDSN']) ? $_SESSION['DariDSN'] : $_SESSION['SampaiDSN'];
$_dsn = "'{$_SESSION['DariDSN']}' <= Login and Login <= '{$_SESSION['SampaiDSN']}' ";
} else {
$drdsn = GetaField('dosen', "NA", "N", "min(Login)");
$smpdsn = GetaField('dosen', "NA", "N", "max(Login)");
$_dsn = "'{$drdsn}' <= Login and Login <= '{$smpdsn}' ";
}
$s = "select Login\r\n from dosen\r\n where {$_dsn}\r\n\t\torder by Login";
$r = _query($s);
$n = 0;
$DBFName = "dikti/MSDOS-{$_SESSION['tahun']}.DBF";
DBFCreate($DBFName, $HeaderMSDOS);
while ($w = _fetch_array($r)) {
$n++;
$_SESSION["DBF-DOSENID-{$n}"] = $w['Login'];
}
$_SESSION["DBF-FILES"] = $DBFName;
$_SESSION["DBF-POS"] = 0;
$_SESSION["DBF-MAX"] = $n;
echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
echo "<p><IFRAME src='dikti.masterdsn.go.php' frameborder=0 height=400 width=600>\r\n </IFRAME></p>";
}
function CreateDBFAktifDSN()
{
global $HeaderAKTFDSN;
if (!empty($_SESSION['DariDSN'])) {
$_SESSION['SampaiDSN'] = empty($_SESSION['SampaiDSN']) ? $_SESSION['DariDSN'] : $_SESSION['SampaiDSN'];
$_dsn = " and '{$_SESSION['DariDSN']}' <= Login and Login <= '{$_SESSION['SampaiDSN']}' ";
} else {
$_dsn = '';
}
$_prd = empty($_SESSION['prodi']) ? "" : "and INSTR(j.ProdiID, '.{$_SESSION['prodi']}.')>0";
$s = "SELECT d.Login, j.JadwalID\r\n FROM dosen d\r\n LEFT OUTER JOIN jadwal j ON j.DosenID = d.Login\r\n WHERE j.TahunID ='{$_SESSION['tahun']}'\r\n AND j.JenisJadwalID = 'K'\r\n GROUP BY d.Login\r\n ORDER BY d.Login";
$r = _query($s);
$n = 0;
//echo "<pre>$s</pre>";
$DBFName = "dbf/TRAKD-{$_SESSION['tahun']}.DBF";
DBFCreate($DBFName, $HeaderAKTFDSN);
while ($w = _fetch_array($r)) {
$n++;
$_SESSION["DBF-DOSENID-{$n}"] = $w['Login'];
}
$_SESSION["DBF-PRODI"] = $_SESSION['prodi'];
$_SESSION["DBF-TAHUN"] = $_SESSION['tahun'];
$_SESSION["DBF-FILES"] = $DBFName;
$_SESSION["DBF-POS"] = 0;
$_SESSION["DBF-MAX"] = $n;
echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
echo "<p><IFRAME src='dikti.aktifitasdsn.go.php' frameborder=0 height=400 width=600>\r\n </IFRAME></p>";
}
function Proses()
{
// Buat DBF
include_once "../{$_SESSION['mnux']}.header.dbf.php";
include_once "../func/dbf.function.php";
$NamaFile = "../tmp/TRNLM_{$_SESSION['TahunID']}.DBF";
$_SESSION['nmhsw_dbf'] = $NamaFile;
$_SESSION['nmhsw_part'] = 0;
$_SESSION['nmhsw_counter'] = 0;
$_SESSION['nmhsw_total'] = HitungData();
if (file_exists($NamaFile)) {
unlink($NamaFile);
}
DBFCreate($NamaFile, $HeaderNilaiMhsw);
$ro = "readonly=true";
echo <<<ESD
<font size=+1>Proses Nilai Mahasiswa...</font> (<b>{$_SESSION['nmhsw_total']}</b> data)<br />
<table class=box cellspacing=1 width=100%>
<form name='frmNilai'>
<tr><td width=10>
Counter:<br />
<input type=text name='Counter' size=4 {$ro} />
</td>
<td width=20>
NIM:<br />
<input type=text name='MhswID' size=10 {$ro} />
</td>
<td width=20>
Mahasiswa:<br />
<input type=text name='NamaMhsw' size=30 {$ro} />
</td>
<td>
Matakuliah:<br />
<input type=text name='NamaMK' size=30 {$ro} />
</td>
</tr>
</form>
</table>
<br />
<script>
function Kembali() {
window.onLoad=setTimeout("window.location='../{$_SESSION['mnux']}.nilaimhsw.php?gos=Selesai'", 0);
}
function Prosesnya(cnt, nim, nama, mk) {
frmNilai.Counter.value = cnt;
frmNilai.MhswID.value = nim;
frmNilai.NamaMhsw.value = nama;
frmNilai.NamaMK.value = mk;
}
</script>
<iframe src="../{$_SESSION['mnux']}.nilaimhsw.php?gos=ProsesDetails" width=90% height=50 frameborder=0 scrolling=no>
</iframe>
ESD;
}
function Proses()
{
// Buat DBF
include_once "../{$_SESSION['mnux']}.header.dbf.php";
include_once "../func/dbf.function.php";
$NamaFile = "../tmp/MSDOS_{$_SESSION['TahunID']}.DBF";
$_SESSION['mdsn_dbf'] = $NamaFile;
$_SESSION['mdsn_part'] = 0;
$_SESSION['mdsn_counter'] = 0;
$_SESSION['mdsn_total'] = HitungData();
if (file_exists($NamaFile)) {
unlink($NamaFile);
}
DBFCreate($NamaFile, $HeaderMasterDosen);
// tampilkan
$ro = "readonly=true";
echo <<<ESD
<font size=+1>Proses Master Dosen...</font> (<b>{$_SESSION['mdsn_total']}</b> data)<br />
<table class=box cellspacing=1 width=100%>
<form name='frmDsn'>
<tr>
<td valign=top width=10>
Counter:<br />
<input type=text name='Counter' size=4 {$ro} />
</td>
<td valign=top width=20>
NIP:<br />
<input type=text name='DosenID' size=10 {$ro} />
</td>
<td valign=top>
Nama Dosen:<br />
<input type=text name='NamaDosen' size=30 {$ro} />
</td>
</tr>
</form>
</table>
<br />
<script>
function Kembali() {
window.onLoad=setTimeout("window.location='../{$_SESSION['mnux']}.masterdosen.php?gos=Selesai'", 0);
}
function Prosesnya(cnt, id, nama) {
frmDsn.Counter.value = cnt;
frmDsn.DosenID.value = id;
frmDsn.NamaDosen.value = nama;
}
</script>
<iframe src="../{$_SESSION['mnux']}.masterdosen.php?gos=ProsesDetails" width=90% height=50 frameborder=0 scrolling=no>
</iframe>
ESD;
}
function Proses()
{
$_prodi = empty($_SESSION['ProdiID']) ? '' : "and j.ProdiID = '{$_SESSION['ProdiID']}' ";
// Buat DBF
include_once "../{$_SESSION['mnux']}.header.dbf.php";
include_once "../func/dbf.function.php";
$NamaFile = "../tmp/TRAKM_{$_SESSION['TahunID']}.DBF";
$_SESSION['amhsw_dbf'] = $NamaFile;
$_SESSION['amhsw_part'] = 0;
$_SESSION['amhsw_counter'] = 0;
$_SESSION['amhsw_total'] = HitungData();
if (file_exists($NamaFile)) {
unlink($NamaFile);
}
DBFCreate($NamaFile, $HeaderAktivitasMhsw);
echo <<<ESD
<font size=+1>Proses Aktivitas Mahasiswa...</font> (<b>{$_SESSION['amhsw_total']}</b> data)<br />
<table class=box cellspacing=1 width=100%>
<form name='frmMhsw' >
<tr>
<td valign=top width=10>
Counter:<br />
<input type=text name='Counter' value='0' size=3 maxlength=3 readonlye=true />
<td valign=top width=50>
NIM:<br />
<input type=text name='MhswID' value='' size=10 maxlength=50 readonly=true />
</td>
<td valign=top>
Nama Mahasiswa:<br />
<input type=text name='NamaMhsw' value='' size=30 maxlength=100 readonly=true />
</td>
</tr>
</form>
</table>
<br />
<script>
function Kembali() {
window.onLoad=setTimeout("window.location='../{$_SESSION['mnux']}.mhsw.php?gos=Selesai'", 0);
}
function Prosesnya(cnt, nim, nama) {
frmMhsw.Counter.value = cnt;
frmMhsw.MhswID.value = nim;
frmMhsw.NamaMhsw.value = nama;
}
</script>
<iframe src="../{$_SESSION['mnux']}.mhsw.php?gos=ProsesDetails" width=90% height=50 frameborder=0 scrolling=no>
</iframe>
ESD;
}
function Daftar()
{
global $HeaderAlamat;
$s = "select m.* from mhsw m\r\n left outer join khs k on k.MhswID = m.MhswID\r\n where k.TahunID = '{$_SESSION['tahun']}'\r\n and k.StatusMhswID = 'A'";
$r = _query($s);
$DBFName = HOME_FOLDER . DS . "tmp/" . date('m') . "Alamat-{$_SESSION['tahun']}.DBF";
DBFCreate($DBFName, $HeaderAlamat);
while ($w = _fetch_array($r)) {
$n++;
$Alamat = empty($w['Alamat']) ? $w['AlamatAsal'] : $w['Alamat'];
$Kota = empty($w['Kota']) ? $w['KotaAsal'] : $w['Kota'];
$RT = empty($w['RT']) ? $w['RTAsal'] : $w['RT'];
$RW = empty($w['RW']) ? $w['RWAsal'] : $w['RW'];
$KODEPOS = empty($w['KodePos']) ? $w['KodePosAsal'] : $w['KodePos'];
$Telepon = empty($w['Telepon']) ? $w['TeleponAsal'] : $w['Telepon'];
$RW = empty($RW) ? '' : "/{$RW}";
$Data = array($n, $w['MhswID'], $w['Nama'], $Alamat, $RT . $RW, $Kota, $KODEPOS, $Telepon);
InsertDataDBF($DBFName, $Data);
}
echo "<hr><p>Proses pembuatan file <b>Berhasil</b>. Silakan download file di:\r\n\t\t\t<input type=button name='Download' value='Download File' onClick=\"location='downloaddbf.php?fn={$DBFName}'\">\r\n\t\t\t</p>";
}
function BuatDBFIjazah()
{
global $HeaderIjazah;
$whr .= empty($_REQUEST['prodi']) ? '' : "and m.ProdiID='{$_REQUEST['prodi']}'";
$s = "select m.MhswID\r\n from ta ta\r\n left outer join mhsw m on m.MhswID=ta.MhswID\r\n where ta.Lulus='Y'\r\n and ('{$_REQUEST['tahun1']}-{$_REQUEST['bulan1']}-01' <= ta.TglSKYudisium)\r\n and (ta.TglSKYudisium <= '{$_REQUEST['tahun2']}-{$_REQUEST['bulan2']}-31')\r\n {$whr}\r\n order by m.MhswID, ta.TglSKYudisium";
$r = _query($s);
$n = 0;
$ran = rand(1, 1000);
$DBFName = HOME_FOLDER . DS . "tmp/ijazah-{$_REQUEST['prodi']}-{$ran}.DBF";
DBFCreate($DBFName, $HeaderIjazah);
while ($w = _fetch_array($r)) {
$n++;
$_SESSION["DBF-MHSWID-{$n}"] = $w['MhswID'];
}
$_SESSION["DBF-FILES"] = $DBFName;
$_SESSION["DBF-POS"] = 0;
$_SESSION["DBF-MAX"] = $n;
echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
echo "<p><IFRAME src='ijazah.import.php' frameborder=0 height=400 width=600>\r\n </IFRAME></p>";
}
