/** *_paging 分页函数 *@param $_type *@return 返回分页 */ function _page($_sql, $_size) { //将里面的所有变量取出来,外部可以访问 global $_page, $_pagesize, $_pagenum, $_pageabsolute, $_num; if (isset($_GET['page'])) { $_page = $_GET['page']; if (empty($_page) || $_page < 0 || !is_numeric($_page)) { $_page = 1; } else { $_page = intval($_page); //取整,取一个小数的整数部分 } } else { $_page = 1; } $_pagesize = $_size; //每页多少条 //首先要得到所有的数据总和 $_num = _num_rows(_query($_sql)); if ($_num == 0) { $_pageabsolute = 1; } else { $_pageabsolute = ceil($_num / $_pagesize); } if ($_page > $_pageabsolute) { $_page = $_pageabsolute; } $_pagenum = ($_page - 1) * $_pagesize; //从第几条开始 }
function BuatIsinya($TahunID, $ProdiID, $p) { $whr_prodi = empty($ProdiID) ? '' : "and k.ProdiID = '{$ProdiID}' "; $whr_tahun = empty($TahunID) ? '' : "and k.TahunID = '{$TahunID}'"; $s = "select k.MhswID, m.Nama, k.ProdiID, k.IP, k.SKS, k.TahunID, \r\n (k.Biaya - k.Potongan) as Tagihan,\r\n\t k.Bayar\r\n from khs k \r\n left outer join mhsw m on m.MhswID = k.MhswID and m.KodeID = '" . KodeID . "'\r\n where k.KodeID='" . KodeID . "'\r\n\t {$whr_tahun}\r\n {$whr_prodi}\r\n\t and ((k.Biaya-k.Potongan)-k.Bayar) != 0\r\n order by k.MhswID"; $r = _query($s); $n = 0; $t = 5; $ttl = 0; $_mhsw = ';alskdjfa;lsdhguairgsofjhjg9e8rgjpsofjg'; if (_num_rows($r) > 0) { while ($w = _fetch_array($r)) { $n++; $ttlsks += $w['SKS']; $ttlipk += $w['IP']; $selisih = $w['Tagihan'] - $w['Bayar']; $ttlselisih += $selisih; $p->SetFont('Helvetica', '', 10); $p->Cell(10, $t, $n, 'LB', 0); $p->Cell(25, $t, $w['MhswID'], 'B', 0); $p->Cell(70, $t, $w['Nama'], 'B', 0); $p->Cell(22, $t, $w['IP'] . '/' . $w['SKS'], 'B', 0, 'C'); $p->Cell(15, $t, $w['TahunID'], 'B', 0, 'C'); $p->Cell(22, $t, number_format($selisih, 0, ',', '.'), 'B', 0, 'R'); $p->Ln($t); } $_ttl = number_format($ttl + 0); $p->SetFont('Helvetica', 'B', 11); $p->Cell($lbr, 1, ' ', 1, 1); $p->Cell(105, $t, 'TOTAL :', 0, 0, 'R'); $p->Cell(22, $t, number_format($ttlipk / $n, 2) . '/' . number_format($ttlsks / $n, 2), 0, 0, 'R'); $p->Cell(22, $t, $_ttl, 0, 0, 'R'); $p->Ln($t + 2); } }
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 BuatIsinya2($TahunID, $ProdiID, $p) { $maxentryperpage = 45; BuatHeader2($TahunID, 'Quota Absensi', ceil($ttl / $maxentryperpage) + 1, $p); $whr_prodi = empty($ProdiID) ? '' : "j.ProdiID = '{$ProdiID}' "; $whr_tahun = empty($TahunID) ? '' : "and j.TahunID = '{$TahunID}' "; $s = "select DISTINCT(p.MhswID), count(p.PresensiID) as _countAbsensi,\r\n m.Nama as NamaMhsw, j.Nama,\r\n d.Nama as NamaPA, d.Gelar,\r\n\t j.MaxAbsen\r\n from presensimhsw p\r\n\t left outer join jadwal j on j.JadwalID=p.JadwalID and j.KodeID= '" . KodeID . "'\r\n\t left outer join jenispresensi jp on p.JenisPresensiID=jp.JenisPresensiID\r\n\t left outer join mhsw m on m.MhswID = p.MhswID and m.KodeID = '" . KodeID . "'\r\n\t left outer join dosen d on d.Login = m.PenasehatAkademik and d.KodeID = '" . KodeID . "'\r\n where \r\n {$whr_prodi}\r\n\t {$whr_tahun}\r\n\t and jp.Nilai = 0\r\n\tgroup by p.MhswID, j.JadwalID\r\n order by p.MhswID"; $r = _query($s); $n = 0; $t = 5; if (_num_rows($r) > 0) { while ($w = _fetch_array($r)) { if ($w['_countAbsensi'] > $w['MaxAbsen']) { $n++; $NamaPA = empty($w['NamaPA']) ? '(Belum diset)' : $w['NamaPA']; $p->SetFont('Helvetica', '', 8); $p->Cell(10, $t, $n, 'LB', 0); $p->Cell(25, $t, $w['MhswID'], 'B', 0); $p->Cell(60, $t, $w['NamaMhsw'], 'B', 0); $p->Cell(10, $t, $w['_countAbsensi'], 'B', 0, 'C'); $p->Cell(10, $t, $w['MaxAbsen'], 'B', 0, 'C'); $p->Cell(75, $t, $w['Nama'], 'BR', 0); $p->Ln($t); } } } else { $p->SetFont('Helvetica', 'B', 8); $p->Cell(0, $t, '(Tidak ada mahasiswa yang dapat dicetak)', 0, 1, 'C'); } $p->Ln($t); $p->SetFont('Helvetica', 'B', 12); $p->Cell(100, $t, 'Jumlah Mahasiswa: ' . $n, 0, 0); }
function Proses() { $_max = 100; $_praPrc = GetSetVar('_praPrc'); $_praCnt = GetSetVar('_praCnt'); $_dari = $_praPrc * $_max; $s = "select m.MhswID, m.Nama\r\n from mhsw m\r\n where m.KodeID = '" . KodeID . "'\r\n and m.ProdiID = '{$_SESSION['ProdiID']}'\r\n and m.StatusMhswID = 'A'\r\n order by m.MhswID\r\n limit {$_dari}, {$_max}"; //die($s); $r = _query($s); $jml = _num_rows($r); if ($jml > 0) { while ($w = _fetch_array($r)) { $_SESSION['_praCnt']++; // Proses satu per satu $MhswID = $w['MhswID']; $Nama = $w['Nama']; $oke = true; $psn = ''; // Apakah ada SKS Minimalnya? $oke = CheckSKSMin($MhswID, $psn); // Apakah ada IP Minimalnya? if ($oke) { $oke = CheckIPMin($MhswID, $psn); } // Apakah ada MK Prasyaratnya? if ($oke) { $oke = CheckPrasyarat($MhswID, $psn); } echo <<<ESD <script> self.parent.Progresnya({$_SESSION['_praCnt']}, '{$MhswID}', '{$Nama}', '{$psn}'); </script> ESD; // Jika memenuhi syarat if ($oke == true) { $f = fopen("../" . $_SESSION['_praFile'] . ".txt", 'a'); fwrite($f, "{$MhswID}|{$Nama}|Oke\r\n"); fclose($f); } else { // Jika tidak memenuhi syarat $f = fopen("../" . $_SESSION['_praFile'] . "_gagal.txt", 'a'); fwrite($f, "{$MhswID}|{$Nama}|{$psn}\r\n"); fclose($f); } } // Nex Process $_SESSION['_praPrc']++; $time = 10; echo <<<ESD <script> <!-- //window.setTimeout("location='{$_SESSION['mnux']}.proses.php?gos=Proses&_praPrc={$_praPrc}&_praCnt={$_SESSION['_praCnt']}'", {$time}); window.setTimeout("location='../{$_SESSION['mnux']}.proses.php'", {$time}); //--> </script> ESD; } else { echo "\r\n <script>\r\n self.parent.Selesai();\r\n </script>\r\n "; } }
function ProsesBeneran() { global $arrprodi; $strprd = ''; foreach ($arrprodi as $val) { $strprd .= ",'{$val}'"; } $strprd = TRIM($strprd, ','); $s = "select khs.MhswID, khs.ProdiID, khs.KHSID\r\n from khs\r\n where khs.ProdiID in ({$strprd}) and khs.TahunID='{$_SESSION['tahun']}'\r\n order by khs.MhswID"; $r = _query($s); $jml = _num_rows($r); $_SESSION['CEK-KRS-JML'] = $jml; $_SESSION['CEK-KRS-POS'] = 0; echo "<p>Ada terdaftar <font size=+1>{$jml}</font> mhsw.</p>"; $n = 0; while ($w = _fetch_array($r)) { $n++; $_SESSION["CEK-KRS-MHSWID-{$n}"] = $w['MhswID']; $_SESSION["CEK-KRS-PRODIID-{$n}"] = $w['ProdiID']; $_SESSION["CEK-KRS-KHSID-{$n}"] = $w['KHSID']; } $_SESSION["CEK-KRS-JML"] = $n; $_SESSION["CEK-KRS-DIHAPUS"] = 0; // IFRAME echo "<p><IFRAME src='_Cek_KRS_Double.gos.php' frameborder=0 height=100% width=100%>\r\n </IFRAME></p>"; }
function ProsesHitungMundur() { $tahun1 = $_REQUEST['tahun1']; $DariNPM = $_REQUEST['DariNPM']; $SampaiNPM = $_REQUEST['SampaiNPM']; $_SESSION['HM-tahun1'] = $tahun1; // Bila hanya 1 mhsw if (empty($SampaiNPM)) { $_SESSION['HM-JML'] = 1; $_SESSION['HM-MhswID-1'] = $DariNPM; $_SESSION['HM-POS'] = 0; } else { $s = "select MhswID\r\n from mhsw\r\n where '{$DariNPM}' <= MhswID and MhswID <= '{$SampaiNPM}'\r\n and NA='N'"; $r = _query($s); $jml = _num_rows($r); $n = 0; while ($w = _fetch_array($r)) { $n++; $_SESSION['HM-MhswID-' . $n] = $w['MhswID']; } $_SESSION['HM-JML'] = $n; $_SESSION['HM-POS'] = 0; } echo "<p>Akan diproses: <font size=+2>" . $_SESSION['HM-JML'] . "</font> mahasiswa.</p>\r\n <p><IFRAME SRC='_jumlahsks_akademik.php?gos=PRCMUNDUR&tahun={$tahun}&prodi={$prodi}&prid={$prid}' width=90% frameborder=0>\r\n </IFRAME></p>"; }
function DaftarMatrikulasi() { $s = "select Nama, MhswID, Kelamin, ProdiID, NilaiUjian, MatriHadir from `mhsw` where MatriID='{$_SESSION['matri_kelompok']} order by Nama'"; $r = _query($s); $xx = _num_rows($r); $sss = "select KapasitasSekarang, KapasitasMaksimum from `matrikulasi` where MatriID='{$_SESSION['matri_kelompok']}'"; $rrr = _query($sss); $www = _fetch_array($rrr); $wheretahun = "TahunID='{$_SESSION['matri_tahun']}'"; if (empty($_SESSION['matri_tahun']) or $_SESSION['matri_tahun'] == '') { $optkelompok = "<option value=''>--Isi Tahun Dulu--</option>"; } else { $optkelompok = GetOption2('matrikulasi', "Nama", 'Nama', $_SESSION['matri_kelompok'], $wheretahun, 'MatriID'); if ($optkelompok == '' or empty($optkelompok)) { $optkelompok = "<option value=''>--Tidak ada kelompok--</option>"; } } echo "<p><table class=box cellspacing=1 align=center width=395>\r\n\t\t\t\t<form action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}' />\r\n\t\t\t\t<input type=hidden id='gos' name='gos' value='' />\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=inp width=130>Tahun Akademik: </td>\r\n\t\t\t\t\t<td class=ul1 colspan=3><input type=text name='matri_tahun' value='{$_SESSION['matri_tahun']}' size=3 maxlength=10>\r\n\t\t\t\t\t\t\t\t\t\t\t<input type=submit name='Set' value='Set'>\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=inp>Kelompok: </td>\r\n\t\t\t\t\t<td class=ul1 colspan=3><select name='matri_kelompok' onChange='this.form.submit()'>{$optkelompok}</select></td>\r\n\t\t\t\t\t\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td class=inp>Kapasitas Sekarang:</td>\r\n\t\t\t\t\t<td class=ul1>{$www['KapasitasSekarang']}</td>\r\n\t\t\t\t\t<td class=inp width=200>Kapasitas Maksimum:</td>\r\n\t\t\t\t\t<td class=ul1>{$www['KapasitasMaksimum']}</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t</form>\r\n\t\t\t</table></p>"; echo "<table class=box cellspacing=1 align=center width=395>\r\n\t\t\t\t<form name='form2' action='?' method=POST>\r\n\t\t\t\t<input type=hidden name='mnux' value='{$_SESSION['mnux']}' />\r\n\t\t\t\t<input type=hidden name='sub' value='KehadiranSiswa' />\r\n\t\t\t\t\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<th class=ttl>No</th>\r\n\t\t\t\t\t<th class=ttl>Mahasiswa di Kelompok ini</th>\r\n\t\t\t\t\t<th class=ttl align=center><input type=button name='CheckAllMember' value='Cek Semua' onClick=\"CheckAll('HM')\" /></th>\t\r\n\t\t\t\t</tr>\r\n\t\t\t"; if (!empty($_SESSION['matri_kelompok'])) { $x1 = 0; while ($w = _fetch_array($r)) { $x1++; $ck = $w['MatriHadir'] == 'Y' ? 'checked' : ''; echo "<tr>\r\n\t\t\t\t\t\t<td class=ul1 width=12 align=right>{$x1}.</td> \r\n\t\t\t\t\t\t<td class=ul1>{$w['Nama']} <img src='img/{$w['Kelamin']}.bmp'></img><font size=1 color=teal>{$w['ProdiID']} - {$w['NilaiUjian']}</font></td>\r\n\t\t\t\t\t\t<td class=ul1 align=center><input type=checkbox id='HM{$x1}' name='PilihKehadiran[]' value='{$w['MhswID']}' {$ck}>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<input type=hidden name='SemuaPilihan[]' value='{$w['MhswID']}'></td>\r\n\t\t\t\t\t</tr>"; } echo "<input type=hidden id='JumlahHM' name='JumlahHM' value='{$x1}'>"; if ($xx > 0) { echo "\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td></td>\r\n\t\t\t\t\t\t<td class=ul1 align=center><input type=submit name='Kehadiran Siswa' value='Simpan Kehadiran'/></td>\r\n\t\t\t\t\t\t<td class=ul1 align=center><input type=button name='UnCheckAllMember' value='Clear Semua' onClick=\"UnCheckAll('HM')\" /></td>\r\n\t\t\t\t\t</tr>"; } } echo "\r\n\t\t\t\t</form>\r\n\t\t\t</table>"; }
function ProsesSekarang() { //$arrPot = array('U'=>'5', 'S'=>'3'); $s = "select *\r\n from _tagihan\r\n where POTNGMSTAG > 0 or POTMBMSTAG > 0\r\n order by NIMHSMSTAG"; $r = _query($s); $jml = _num_rows($r); echo "<p>Data yg akan diproses: <font size=+1>{$jml}</font></p>"; echo "<ol>"; while ($w = _fetch_array($r)) { $pot1 = number_format($w['POTNGMSTAG']); $pot2 = number_format($w['POTMBMSTAG']); echo "<li>{$w['NIMHSMSTAG']} » {$pot1} » {$pot2}\r\n </li>"; // ambil detail dari TRPTG $sp = "select * from _potongan where NIMHSTRPTG='{$w['NIMHSMSTAG']}' "; $rp = _query($sp); echo "<ul>"; while ($wp = _fetch_array($rp)) { $jmlpot = number_format($wp['NLPOTTRPTG']); $bn = $wp['JNPOTTRPTG'] == 'U' ? 5 : 3; $ada = GetaField('bipotmhsw', "TahunID='{$wp['THSMSTRPTG']}' \r\n and MhswID='{$wp['NIMHSTRPTG']}' \r\n and TrxID=-1\r\n and BIPOTNamaID", $bn, "BIPOTMhswID"); if (empty($ada)) { $prc = "insert into bipotmhsw\r\n (PMBMhswID, TrxID, MhswID, TahunID, BIPOTNamaID,\r\n Jumlah, Besar, Dibayar, Catatan,\r\n LoginBuat, TanggalBuat)\r\n values (1, -1, '{$wp['NIMHSTRPTG']}', '{$wp['THSMSTRPTG']}', {$bn},\r\n 1, {$wp['NLPOTTRPTG']}+0, {$wp['NLPOTTRPTG']}, '{$wp['KETR1TRPTG']} {$wp['KETR2TRPTG']}',\r\n 'IMPORT-POT-20061', now())"; $rprc = _query($prc); } else { $prc = "(Sudah ada)"; } echo "<li>{$wp['JNPOTTRPTG']} » {$jmlpot} {$prc}</li>"; } echo "</ul>"; } echo "</ol>"; }
function Isinya($Tanggal, $Kampus, $p) { $lbr = 290; $t = 6; JudulKolomnya($p); $p->SetFont('Helvetica', '', 10); $PilihanKompre = GetaField('prodi', "ProdiID='{$_SESSION['ProdiID']}' and KodeID", KodeID, 'PilihanKompre'); if ($PilihanKompre == 'Y') { $s = "select kd.*, m.MhswID,left(m.Nama, 28) as Mhsw,m.KelasID, d.Nama as _DosenPenguji, kmu.Nama as _NamaMataUji,\r\n\t\t\tdate_format(kd.Tanggal, '%a') as _Hari, LEFT(kd.JamMulai, 5) as _JamUjian, LEFT(kd.JamSelesai, 5) as _JamSelesai, pa.Nama as _DosenPA\r\n\t\t\tfrom kompredosen kd \r\n\t\t\t\tleft outer join kompre k on kd.KompreID=k.KompreID and k.KodeID='" . KodeID . "'\r\n\t\t\t\tleft outer join mhsw m on m.MhswID = k.MhswID and m.KodeID = '" . KodeID . "'\r\n\t\t\t\tleft outer join dosen pa on pa.Login = m.PenasehatAkademik\r\n\t\t\t\tleft outer join dosen d on d.Login = kd.DosenID\r\n\t\t\t\tleft outer join komprematauji kmu on kmu.KompreMataUjiID=kd.KompreMataUjiID and kmu.KodeID='" . KodeID . "'\r\n\t\t\twhere kd.KodeID = '" . KodeID . "'\r\n\t\t and k.Lulus = 'N'\r\n\t\t and kd.Tanggal = '{$Tanggal}'\r\n\t\t and kd.NA = 'N'\r\n\t\tgroup by k.MhswID\r\n\t\torder by kd.Tanggal"; } else { $s = "select k.*, m.MhswID,left(m.Nama, 28) as Mhsw,m.KelasID, d.Nama as _DosenPenguji, \r\n\t\t\tdate_format(k.TanggalUjian, '%a') as _Hari, LEFT(k.JamMulai, 5) as _JamUjian, LEFT(k.JamSelesai, 5) as _JamSelesai, pa.Nama as _DosenPA\r\n\t\t\tfrom kompre k \r\n\t\t\t\tleft outer join mhsw m on m.MhswID = k.MhswID and m.KodeID = '" . KodeID . "'\r\n\t\t\t\tleft outer join dosen pa on pa.Login = m.PenasehatAkademik\r\n\t\t\t\tleft outer join dosen d on d.Login = k.DosenID\r\n\t\t\twhere k.KodeID = '" . KodeID . "'\r\n\t\t and k.Lulus = 'N'\r\n\t\t and k.TanggalUjian = '{$Tanggal}'\r\n\t\t and k.NA = 'N'\r\n\t\tgroup by k.MhswID\r\n\t\torder by k.TanggalUjian"; } $r = _query($s); $n = 0; $jum = _num_rows($r); while ($w = _fetch_array($r)) { $n++; $MataUji = $PilihanKompre == 'Y' ? ' (' . $w['_NamaMataUji'] . ')' : ''; $p->Cell(8, $t, $n, 1, 0, 'C'); $p->Cell(30, $t, $w['MhswID'], 1, 0, 'C'); $p->Cell(60, $t, $w['Mhsw'], 1, 0); $p->Cell(50, $t, $w['_DosenPA'], 1, 0); $p->Cell(50, $t, $w['_DosenPenguji'] . $MataUji, 1, 0); $p->Cell(55, $t, $w['_JamUjian'] . ' - ' . $w['_JamSelesai'] . ' WIB', 1, 0, 'C'); $p->Cell(20, $t, $w['RuangID'], 1, 0, 'C'); } }
function DaftarGolongan() { $s = "select * \r\n from golongan \r\n where ProdiID='{$_SESSION['prodi']}' order by GolonganID, KategoriID"; $r = _query($s); $n = 0; $count = _num_rows($r); if ($count == 0) { echo "<a href='?mnux=golongan&gos=GolImprt'>Import Default Golongan</a>"; } echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr><th class=ttl>No</th>\r\n <th colspan=2 class=ttl title='Golongan'>Gol</th>\r\n <th class=ttl title='Kategori'>Kat</th>\r\n <th class=ttl>Pangkat</th>\r\n <th class=ttl>Nama</th>\r\n <th class=ttl title='Tunjangan Fungsional'>Fungsional</th>\r\n <th class=ttl title='Tunjangan per SKS'>per SKS</th>\r\n <th class=ttl title='Tunjangan Tranport'>Transport</th>\r\n <th class=ttl title='Tunjangan Tetap'>Tetap</th>\r\n <th class=ttl title='Tidak Aktif?'>NA</th>\r\n </tr>"; $_gol = 'qwertyuiop'; while ($w = _fetch_array($r)) { $n++; if ($_gol != $w['GolonganID']) { $_gol = $w['GolonganID']; $_strgol = "<b>{$w['GolonganID']}</b>"; } else { $_strgol = "<img src='img/brch.gif'>"; } $TFun = number_format($w['TunjanganFungsional']); $TSKS = number_format($w['TunjanganSKS']); $TTra = number_format($w['TunjanganTransport']); $TTtp = number_format($w['TunjanganTetap']); $c = $w['NA'] == 'Y' ? 'class=nac' : 'class=ul'; echo "<tr>\r\n <td class=inp>{$n}</td>\r\n <td class=ul><a href='?mnux=golongan&md=0&gos=GolEdt&_GID={$w['GolonganID']}&_KID={$w['KategoriID']}'><img src='img/edit.png'></a></td>\r\n <td class=ul>{$_strgol}</td>\r\n <td {$c}>{$w['KategoriID']}</td>\r\n <td {$c}>{$w['Pangkat']} </td>\r\n <td {$c}>{$w['Nama']} </td>\r\n <td {$c} align=right>{$TFun}</td>\r\n <td {$c} align=right>{$TSKS}</td>\r\n <td {$c} align=right>{$TTra}</td>\r\n <td {$c} align=right>{$TTtp}</td>\r\n <td class=ul><img src='img/book{$w['NA']}.gif'></td>\r\n </tr>"; } echo "</table></p>"; }
function ProsesTransferDep() { $s = "select *\r\n from _transferdeposit\r\n order by TahunID, MhswID"; $r = _query($s); $jml = _num_rows($r); echo "<p>Ada <font size=+2>{$jml}</font> data yg akan diproses.</p>"; echo "<ol>"; $bn_dep = 32; // transfer deposit. Lihat di BipotNama $bn_nm = "Transfer Deposit"; while ($w = _fetch_array($r)) { $_dep = number_format($w['Jumlah']); $ada = GetFields('bipotmhsw', "TahunID='{$w['TahunID']}' and BIPOTNamaID={$bn_dep} and MhswID", $w['MhswID'], "*"); if (empty($ada)) { $str = "Diproses "; $s0 = "insert into bipotmhsw\r\n (PMBMhswID, MhswID, TahunID, \r\n BIPOTNamaID, Nama, TrxID, Draft,\r\n Jumlah, Besar, Dibayar,\r\n Catatan, LoginBuat, TanggalBuat)\r\n values (1, '{$w['MhswID']}', '{$w['TahunID']}',\r\n {$bn_dep}, '{$bn_nm}', -1, 'N',\r\n 1, {$w['Jumlah']}, {$w['Jumlah']}, \r\n 'import-061030', 'import-061030', now())"; //$str .= $s0; $r0 = _query($s0); } else { $str = "<font color=red>Sudah</font>"; } echo "<li>{$w['MhswID']} - {$w['TahunID']} » {$_dep} » {$str}</li>"; } echo "</ol>"; }
function CetakPerolehanSKS() { $s = "select m.MhswID, m.Nama, sm.Nama as SM\r\n from mhsw m\r\n left outer join statusmhsw sm on m.StatusMhswID=sm.StatusMhswID\r\n where ('{$_SESSION['DariNPM']}' <= m.MhswID)\r\n and (m.MhswID <= '{$_SESSION['SampaiNPM']}')\r\n and sm.Nilai=1\r\n order by m.MhswID"; $r = _query($s); $jml = _num_rows($r); if ($jml == 0) { echo ErrorMsg("Tidak ada Data", "Tidak ada mahasiswa dalam rentang NPM: <b>{$_SESSION['DariNPM']}</b> s/d <b>{$_SESSION['SampaiNPM']}</b>."); } else { echo "<p>Akan diproses: <font size=+1>{$jml}</font> mahasiswa.\r\n Tunggu sampai proses selesai. Setelah selesai baru akan dicetak.</p>"; // Simpan data ke memori $n = 0; while ($w = _fetch_array($r)) { $n++; $_SESSION["PERO-MhswID-{$n}"] = $w['MhswID']; } $_SESSION["PERO-POS"] = 0; $_SESSION["PERO-MAX"] = $jml; $_SESSION["PERO-FILE"] = "tmp/{$_SESSION['_Login']}.PerolehanSKS.dwoprn"; // init file $f = fopen($_SESSION["PERO-FILE"], 'w'); fwrite($f, chr(27)); fclose($f); // IFRAME echo "<p><IFRAME src='akd.lap.perolehansks.go.php' frameborder=0 height=100% width=100%>\r\n </IFRAME></p>"; } }
function Prosesnya() { $max = $_SESSION['_bptMax'] + 0; $max = $max == 0 ? 10 : $max; $page = $_SESSION['_bptPage'] + 0; $mulai = $max * $page; $s = "select h.*, m.Nama as NamaMhsw\r\n from khs h\r\n left outer join mhsw m on m.MhswID = h.MhswID and m.KodeID = '" . KodeID . "'\r\n where h.KodeID = '" . KodeID . "'\r\n and h.TahunID = '{$_SESSION['TahunID']}'\r\n and left(m.TahunID, 4) = '{$_SESSION['TahunID2']}' \r\n order by h.MhswID\r\n limit {$mulai}, {$max}"; $r = _query($s); $jml = _num_rows($r); if ($jml > 0) { while ($w = _fetch_array($r)) { $_SESSION['_bptCounter']++; $jml = ProsesBIPOT($w['MhswID'], $w['TahunID']) + 0; $_jml = number_format($jml); echo "\r\n <script>\r\n parent.fnProgress({$_SESSION['_bptCounter']}, '{$w['MhswID']}', '{$w['NamaMhsw']}', '{$_jml}');\r\n </script>"; } $_SESSION['_bptPage']++; $tmr = 1; echo <<<ESD <script> window.onload=setTimeout("window.location='../{$_SESSION['mnux']}.prc.php'", {$tmr}); </script> ESD; } else { echo <<<ESD <script> parent.fnSelesai('{$_SESSION['TahunID']}', {$_SESSION['_bptCounter']}); </script> ESD; } }
function TampilkanDaftarYudisium() { $optprd = GetOption2('prodi', "concat(ProdiID, ' - ', Nama)", "ProdiID", $_SESSION['prodi'], '', "ProdiID"); $bulan1 = GetMonthOption($_SESSION['bulan1']); $bulan2 = GetMonthOption($_SESSION['bulan2']); $tahun1 = GetNumberOption(date('Y') - 10, date('Y'), $_SESSION['tahun1']); $tahun2 = GetNumberOption(date('Y') - 10, date('Y') + 1, $_SESSION['tahun2']); $TglYudisium = GetDateOption($_SESSION['TglYudisium'], 'TglYudisium'); echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <form action='?' method=POST>\r\n <tr><td class=ul colspan=2><font size=+1>Filter</font></td></tr>\r\n <tr><td class=inp>Prodi :</td><td class=ul><select name='prodi'>{$optprd}</select> Kosongkan jika ingin melihat semua</td></tr>\r\n <tr><td class=inp>Lulus bulan :</td><td class=ul>\r\n <select name='bulan1'>{$bulan1}</select><select name='tahun1'>{$tahun1}</select> s/d\r\n <select name='bulan2'>{$bulan2}</select><select name='tahun2'>{$tahun2}</select> <input type=submit name='Filter' value='Filter Daftar'></td></tr>\r\n </form>\r\n \r\n <tr><td class=ul colspan=2><font size=+1>SK Yudisium</font></td></tr>\r\n <tr><td colspan=2>Set mahasiswa yang bertanda centang dalam daftar di bawah ini dengan SK Yudisium berikut ini:</td></tr> \r\n <form action='?' method=POST>\r\n <input type=hidden name='mnux' value='skyudisium'>\r\n <input type=hidden name='gos' value='SKYSAV'>\r\n <tr><td class=inp>No SK Yudisium :</td><td class=ul><input type=text name='SKYudisium' value='{$_SESSION['SKYudisium']}' size=50 maxlength=100></td></tr>\r\n <tr><td class=inp>Tanggal Yudisium :</td><td class=ul>{$TglYudisium} <input type=submit name='Simpan' value='Set SK Semua yg Dicentang'></td></tr>\r\n </table></p>"; if ($_SESSION['prodi'] != '10') { $_whr = "('{$_SESSION['tahun1']}-{$_SESSION['bulan1']}-01' <= ta.TglUjian) \r\n and (ta.TglUjian <= '{$_SESSION['tahun2']}-{$_SESSION['bulan2']}-31') and "; } else { $_whr = ""; } $s = "select ta.*, m.Nama\r\n from ta ta\r\n left outer join mhsw m on ta.MhswID=m.MhswID\r\n where ta.Lulus='Y'\r\n and m.ProdiID = '{$_SESSION['prodi']}'\r\n \r\n order by ta.MhswID"; $r = _query($s); $n = 0; $TotalSKY = _num_rows($r) + 0; echo "<input type=hidden name='TotalSKY' value={$TotalSKY}>\r\n <p><table class=box cellspacing=1 cellpadding=4>\r\n <tr><th class=ttl>#</th>\r\n <th class=ttl>N.P.M</th>\r\n <th class=ttl>Nama Mahasiswa</th>\r\n <th class=ttl>Tgl Ujian</th>\r\n <th class=ttl>Judul</th>\r\n <th class=ttl>SK Yudisium</th>\r\n <th class=ttl>Tgl Yudisium</th>\r\n <th class=ttl>Centang</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $n++; $TglSKYudisium = FormatTanggal($w['TglSKYudisium']); 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>{$w['TglUjian']}</td>\r\n <td class=ul>{$w['Judul']}</td>\r\n <td class=ul>{$w['SKYudisium']} </td>\r\n <td class=ul>{$TglSKYudisium}</td>\r\n <td class=ul><input type=checkbox name='SKY[]' value='{$w['TAID']}'></td>\r\n </tr>"; } echo "</table></form></p>"; }
function ExportKRSSetara() { $mhswstrID = $_REQUEST['mhswstrID']; $prodiID = $_REQUEST['prodit']; $s = "select mps.*, mp.*, n.Bobot as BOBOT, mps.GradeNilai as GRADE\r\n from mhswpindahansetara mps \r\n left outer join nilai n on n.Nama = mps.GradeNilai\r\n left outer join mhswpindahan mp on mp.MhswPindahanID = mps.MhswPindahanID\r\n where mps.sudah=0 \r\n and mps.MhswPindahanID = {$mhswstrID}\r\n and n.ProdiID = {$prodiID}"; $r = _query($s); $jml = _num_rows($r); echo "<p>Jumlah data: <font size=+1>{$jml}</font></p>"; echo "<ol>"; while ($w = _fetch_array($r)) { //$ada = GetaField('krs', "MhswID='$w[MhswID]' and JadwalID", $w[JadwalID], 'KRSID'); //if (empty($ada)) { echo "<li>{$w['MhswID']} » {$w['MKKode']}\r\n </li>"; // Export $s1 = "insert into krs\r\n (KHSID, MhswID, TahunID, JadwalID, \r\n MKID, MKKode, SKS, StatusKRSID,\r\n Harga, HargaStandar,\r\n GradeNilai, BobotNilai, Final,\r\n Catatan,\r\n LoginBuat, TanggalBuat)\r\n values ('{$w['KHSID']}', '{$w['MhswID']}', '00000', '{$w['JadwalID']}',\r\n '{$w['MKID']}', '{$w['MKKode']}', '{$w['SKS']}', 'A',\r\n {$w['Harga']}, '{$w['HargaStandar']}',\r\n '{$w['GRADE']}', '{$w['BOBOT']}', 'Y',\r\n '{$w['Catatan']}',\r\n '{$w['LoginBuat']}', now())\r\n "; //echo "<pre>$s1</pre>"; $r1 = _query($s1); // Set bahwa sudah di export $s2 = "update mhswpindahansetara set sudah=1 where KRSID={$w['KRSID']}"; $r2 = _query($s2); echo "<pre>{$s2}</pre>"; //} //else echo "<li>$w[MhswID] » $w[KRSID]</li>"; } $s3 = "update mhswpindahan set Sudah=1 where MhswPindahanID={$mhswstrID}"; $r3 = _query($s3); $up = GetFields('mhswpindahan', "MhswPindahanID", $mhswstrID, "*"); $s4 = "update mhsw set BatasStudi='{$up['BatasStudi']}', TotalSKSPindah='{$up['JumlahSetara']}', SKPenyetaraan='{$up['SKPenyetaraan']}',\r\n TglSKPenyetaraan='{$up['TglSKPenyetaraan']}', ProdiAsalPT='{$up['ProdiAsalPT']}', AsalPT='{$up['AsalPT']}', IPKAsalPT='{$up['IPKAsalPT']}'\r\n where MhswID='{$up['MhswID']}'"; $r4 = _query($s4); echo "</ol>"; }
function AmbilJadwal($query, $p) { // Buat headernya dulu $p->SetFont('Helvetica', 'B', 12); $t = 7; $count = 0; $p->Cell(15, $t, 'NO', 1, 0, 'C'); $p->Cell(110, $t, 'MATA KULIAH', 1, 0, 'C'); $p->Cell(75, $t, 'HARI/TANGGAL', 1, 0, 'C'); $p->Cell(40, $t, 'WAKTU', 1, 0, 'C'); $p->Cell(30, $t, 'RUANG', 1, 0, 'C'); $p->Ln($t); while ($w = _fetch_array($query)) { $count++; $s1 = "select * from presensiremedial where JadwalRemedialID='{$w['JadwalRemedialID']}' and KodeID='" . KodeID . "'"; $r1 = _query($s1); $n1 = _num_rows($r1); $p->Cell(15, $n1 * $t, $count, 1, 0, 'C'); $p->Cell(110, $n1 * $t, $w['Nama'], 1, 0, 'C'); $nx = 0; while ($w1 = _fetch_array($r1)) { if ($nx > 0) { $p->Cell(125); } $p->Cell(75, $t, $w1['Tanggal'], 1, 0, 'C'); $p->Cell(40, $t, substr($w1['JamMulai'], 0, 5) . ' - ' . substr($w1['JamSelesai'], 0, 5), 1, 0, 'C'); $p->Cell(30, $t, $w1['RuangID'], 1, 1, 'C'); $nx++; } $p->Ln($t + 1); } }
function ProsesSekarang() { $s = "select * from _pembayaran where RESTAMSTAR='A' order by NIMHSMSTAR"; $r = _query($s); $jml = _num_rows($r); echo "<p>Jumlah yg akan diproses: <font size=+1>{$jml}</font></p>"; echo "<ol>"; while ($w = _fetch_array($r)) { $byr = number_format($w['NLBPMMSTAR']); $jml = $w['NLBPMMSTAR'] - $w['NLLN2MSTAR'] + 0; $TglBank = DeFormatTanggal($w['TGBANMSTAR']); $TglBuat = DeFormatTanggal($w['TGBPMMSTAR']); // Cek apakah BPM sudah ada? $ada = GetFields('bayarmhsw', 'BayarMhswID', $w['NOBPMMSTAR'], '*'); if (empty($ada)) { // Tampilkan echo "<li>{$w['NOBPMMSTAR']} » \r\n {$w['NIMHSMSTAR']} » {$w['NOTESMSTAR']} = \r\n <font size=+1>{$byr}</font>\r\n </li>"; // Insert $s1 = "insert into bayarmhsw\r\n (BayarMhswID, TahunID, RekeningID, \r\n PMBMhswID, MhswID, TrxID,\r\n Bank, BuktiSetoran,\r\n Tanggal, Jumlah, JumlahLain,\r\n Proses, Keterangan,\r\n LoginBuat, TanggalBuat)\r\n values\r\n ('{$w['NOBPMMSTAR']}', '{$w['THSMSMSTAR']}', 'Import-20061',\r\n 1, '{$w['NIMHSMSTAR']}', 1,\r\n '{$w['KDBANMSTAR']}', '{$w['NOTESMSTAR']}',\r\n '{$TglBank}', {$jml}, {$w['NLLN2MSTAR']}+0,\r\n 1, 'IMPORT-20061',\r\n 'IMPORT-20061', '{$TglBuat}')"; //echo $s1; $r1 = _query($s1); } else { echo "<li>{$w['NOBPMMSTAR']} » XXX</li>"; } } echo "</ol>"; }
function BuatIsinya($_DosenID, $_Tahun, $_Bulan, $_id, $p) { $whr_id = empty($_id) ? "" : "and p.HonorDosenID = '{$_id}'"; $s = "select h.*, m.Nama as Mgg \r\n from honordosen h\r\n left outer join minggu m on h.Minggu=m.MingguID\r\n where h.DosenID = '{$_DosenID}'\r\n\t and h.Bulan = '{$_Bulan}'\r\n and h.Tahun = '{$_Tahun}'"; /* $s = "select DISTINCT(j.MKKode), j.SKS, p.SKSHonor, j.Nama, sum(p.TunjanganSKS) as _TunjanganSKS, sum(p.TunjanganTetap) as _TunjanganTetap, sum(p.TunjanganTransport) as _TunjanganTransport, count(p.PresensiID) as _Pertemuan from presensi p left outer join jadwal j on j.JadwalID = p.JadwalID left outer join prodi prd on prd.ProdiID = j.ProdiID and prd.KodeID = '".KodeID."' where p.DosenID = '$_DosenID' and MONTH(p.Tanggal) = '$_Bulan' and YEAR(p.Tanggal) = '$_Tahun' $whr_id group by p.HonorDosenID order by p.Pertemuan, j.MKKode, p.Tanggal"; */ $r = _query($s); $n = 0; $t = 5; $ttl = 0; $_mhsw = ';alskdjfa;lsdhguairgsofjhjg9e8rgjpsofjg'; $ttlsks = 0; $ttlhonor = 0; if (_num_rows($r) > 0) { while ($w = _fetch_array($r)) { $n++; $honor = $w['TunjanganSKS'] + $w['TunjanganTransport'] + $w['TunjanganTetap'] + 0; $pajak = $honor * $w['Pajak'] / 100; $total = $honor - $pajak; $ttlhonor += $honor; $ttlpajak += $pajak; $ttltotal += $total; $p->SetFont('Helvetica', '', 10); $p->Cell(10, $t, $n, 'LB', 0, 'R'); $p->Cell(85, $t, $w['Mgg'], 'B', 0); $p->Cell(30, $t, number_format($honor, 0, ',', '.'), 'B', 0, 'R'); $p->Cell(30, $t, number_format($pajak, 0, ',', '.'), 'B', 0, 'R'); $p->Cell(35, $t, number_format($total, 0, ',', '.'), 'B', 0, 'R'); $p->Ln($t); } $_ttl = number_format($ttl + 0); $p->SetFont('Helvetica', 'B', 11); $p->Cell($lbr, 1, ' ', 1, 1); $p->Cell(95, $t, 'TOTAL :', 0, 0, 'R'); $p->Cell(30, $t, number_format($ttlhonor, 0, ',', '.'), 0, 0, 'R'); $p->Cell(30, $t, number_format($ttlpajak, 0, ',', '.'), 0, 0, 'R'); $p->Cell(35, $t, number_format($ttltotal, 0, ',', '.'), 0, 0, 'R'); $p->Ln($t); } }
function Cetak() { global $_lf; // Parameters $jdwlid = $_REQUEST['JadwalID']; $jdwl = GetFields("jadwal", 'JadwalID', $jdwlid, "*"); if (empty($jdwl)) { die("Data tidak ditemukan."); } // Buat File $nmf = HOME_FOLDER . DS . "tmp/{$_SESSION['_Login']}.dwoprn"; $f = fopen($nmf, 'w'); fwrite($f, chr(27) . chr(15)); $hal = 0; $n = 0; $brs = 0; $maxbaris = 20; $mrgisi = str_pad(' ', 11, ' '); //$hdr = BuatHeader($jdwl, $); // Daftar mhsw $s = "select m.Nama as NamaM,krs.Mhswid as IDM \r\n from krstemp as krs left outer join mhsw m on m.MhswID = krs.MhswID\r\n where \r\n\tkrs.JadwalID = '{$jdwlid}' \r\n\tand krs.NA = 'N'\r\n\torder by krs.Mhswid"; $r = _query($s); $jumrec = _num_rows($r); $jumhal = ceil($jumrec / $maxbaris); $hdr = BuatHeader($jdwl, $jumhal, $hal); fwrite($f, $hdr); while ($w = _fetch_array($r)) { if ($brs >= $maxbaris) { fwrite($f, chr(12)); fwrite($f, BuatHeader($jdwl, $jumhal, $hal)); $brs = 0; } //$brs++; $n++; //fwrite($f, str_pad($n.'. ', 4) . $w['IDM'] . ' » ' . $w['NamaM']); //fwrite($f, $_lf); $brs++; $n++; $item = $mrgisi . str_pad($n . '. ', 5) . str_pad($w['IDM'], 12) . $w['NamaM']; //if ($brs == 2) $item2 = " Jumlah Tatap Muka : " . $jdwl['Kehadiran'] . 'x'; // else $item2 = ''; //fwrite($f, $mrgisi . str_pad($n.'. ', 5) . $w['MhswID']. ' ' . str_pad($NamaMhsw, 50)); if (!empty($item)) { fwrite($f, $item . $item2 . $_lf . $_lf); } } //fclose($f); //TampilkanFileDWOPRN($nmf); for ($i = $brs; $i < $maxbaris; $i++) { fwrite($f, $mrgisi . str_pad(' ', 5) . "** Tidak diperkenankan menambah pada baris ini **" . $_lf . $_lf); } fwrite($f, $_lf . "Dicetak Oleh : " . $_SESSION['_Login'] . ', ' . Date("d-m-Y H:i")); fwrite($f, chr(12)); fclose($f); TampilkanFileDWOPRN($nmf); }
function ListWawancara($gelombang) { $s1 = "select * from `pmb` \r\n\t\t\twhere (PMBID like '%{$_SESSION['_wawanEntry']}%'\r\n\t\t\t\tor Nama like '%{$_SESSION['_wawanEntry']}%')\r\n\t\t\t\tand PMBPeriodID='{$gelombang}'\r\n\t\t\t\tand KodeID='" . KodeID . "'\r\n\t\t\torder by PMBID"; $r1 = _query($s1); $n1 = _num_rows($r1); $x1 = 0; loadJavaScripts(); if ($n1 == 0) { // Jika nama calon mahasiswa/no.PMB tidak diketemukan dalam table pmb if (!empty($_REQUEST['_wawanEntry'])) { echo "<br>Nama/No. Pmb: <b>{$_REQUEST['_wawanEntry']}</b> tidak diketemukan. Silakan mencoba lagi"; } } else { echo "<p>\r\n\t\t\t\t\t<table class=box cellspacing=1 cellpadding=4 width=800>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th class=ttl width=80 rowspan=2 valign=center>No. PMB (Daftar)</th>\r\n\t\t\t\t\t\t<th class=ttl width=200 rowspan=2 valign=center>Nama Calon Mahasiswa</th>\r\n\t\t\t\t\t\t<th class=ttl width=20 rowspan=2 valign=center>Prodi</th>\r\n\t\t\t\t\t\t<th class=ttl width=600 colspan=7>Data Wawancara</th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<th class=ttl width=20 align=center>#</th>\r\n\t\t\t\t\t\t<th class=ttl width=80>Tgl.</th>\r\n\t\t\t\t\t\t<th class=ttl width=240>Pewawancara</th>\r\n\t\t\t\t\t\t<th class=ttl width=20>Saran</th>\r\n\t\t\t\t\t\t<th class=ttl width=100>Rekomendasi</th>\r\n\t\t\t\t\t\t<th class=ttl width=20></th>\r\n\t\t\t\t\t\t<th class=ttl width=20></th>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t"; while ($w1 = _fetch_array($r1)) { // Jika nama calon mahasiswa/no.PMB ditemukan $s = "select * from `wawancara` \r\n\t\t\t\t\twhere PMBID = '{$w1['PMBID']}' and KodeID='" . KodeID . "' and PMBPeriodID='{$gelombang}'"; $r = _query($s); $n = _num_rows($r); $x = 0; if ($n == 0) { echo "<tr>\r\n\t\t\t\t\t\t<td class=ul1 align=center><b>{$w1['PMBID']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 align=center><b>{$w1['Nama']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 valign=center align=center>{$w1['Pilihan1']}<br><hr color=green><br>{$w1['Pilihan2']}</td>\r\n\t\t\t\t\t<td class=ul1 colspan=4 align=center><b> - Belum ada wawancara -</b></td>\r\n\t\t\t\t\t<td colspan=3 align=right>\t\t\r\n\t\t\t\t\t\t<input type=button name='Tambah' value='Tambah Wawancara'\r\n\t\t\t\t\t\t\tonClick=\"javascript:fnEditCama('{$gelombang}', 1, '{$w1['PMBID']}')\" />\r\n\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=10>\r\n\t\t\t\t\t\t\t<hr color=green width=100%>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>"; } else { if ($n < 3) { $n_row = 3; } else { $n_row = $n + 1; } //Set Variable bila Nama/No.PMB ada/tidak ada di dalam table `wawancara` $x1++; echo "<tr>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center><b>{$w1['PMBID']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center><b>{$w1['Nama']}</b></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$w1['Pilihan1']}<br><hr color=green><br>{$w1['Pilihan2']}</td>"; while ($arr = _fetch_array($r)) { $x++; if ($n == 0) { $n_row = 2; } else { if ($n == 1) { $n_row = 2; } else { $n_row = 1; } } $tanggalwawancara = substr($arr['TanggalWawancara'], 0, 16); echo "\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=right>{$x}.</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$tanggalwawancara}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center >{$arr['Pewawancara']} , {$arr['Pewawancara2']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$arr['SaranProgram']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center align=center>{$arr['HasilWawancara']}</td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center ><a href=\"javascript:fnEditCama('{$gelombang}', 0, '{$arr['WawancaraID']}')\"><img src='img/edit.png' border=0></a></td>\r\n\t\t\t\t\t\t<td class=ul1 rowspan={$n_row} valign=center ></td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t"; if ($n < 2) { echo "</tr><tr>"; } } echo "\t<td colspan=7 align=right>\t\t\r\n\t\t\t\t\t\t<input type=button name='Tambah' value='Tambah Wawancara'\r\n\t\t\t\t\t\t\tonClick=\"javascript:fnEditCama('{$gelombang}', 1, '{$w1['PMBID']}')\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=10>\r\n\t\t\t\t\t\t\t<hr color=green width=100%>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t"; } } echo "</table></p>"; } }
function daftar() { global $_lf; $whr = array(); if (!empty($_SESSION['dsnkeycr']) && !empty($_SESSION['dsncr'])) { $whr[] = "{$_SESSION['dsnkeycr']} like '%{$_SESSION['dsncr']}%'"; } $where = implode(' and ', $whr); $where = empty($where) ? '' : "and {$where}"; $hom = empty($_SESSION['prodi']) ? '' : "and Homebase = '{$_SESSION['prodi']}'"; $s = "select * from dosen\r\n where KodeID='{$_SESSION['KodeID']}' {$where} {$hom}\r\n order by {$_SESSION['dsnurt']} "; $r = _query($s); $Nhom = GetaField("prodi", "ProdiID", $_SESSION['prodi'], 'Nama'); $nmf = HOME_FOLDER . DS . "tmp/{$_SESSION['_Login']}.dwoprn"; $maxcol = 155; $f = fopen($nmf, 'w'); fwrite($f, chr(27) . chr(15) . chr(77) . chr(27) . chr(108) . chr(5)); $div = str_pad('-', $maxcol, '-') . $_lf; // parameter2 $n = 0; $hal = 1; $brs = 0; $maxbrs = 52; $_Tgl = date("d-m-Y"); $hdr = str_pad("** LAPORAN DAFTAR DOSEN **", $maxcol, ' ', STR_PAD_BOTH) . $_lf . $_lf . $_lf; $hdr .= str_pad("Urut Berdasarkan : " . $_SESSION['dsnurt'], 30, ' ') . $_lf; $hdr .= str_pad("Homebase : " . $_SESSION['prodi'] . " - " . $Nhom, 30, ' ') . $_lf; $hdr .= $div; $hdr .= "No. KODE NAMA GELAR HOMEBASE TELEPON ALAMAT" . $_lf . $div; $jumlahrec = _num_rows($r); $jumhal = ceil($jumlahrec / $maxbrs); fwrite($f, $hdr); while ($w = _fetch_array($r)) { $n++; $brs++; if ($brs > $maxbrs) { fwrite($f, $div); fwrite($f, str_pad('Halaman : ' . $hal . "/" . $jumhal, 10, ' ') . $_lf); $hal++; $brs = 1; fwrite($f, chr(12)); fwrite($f, $hdr . $_lf); } $isi = str_pad($n . ".", 5, ' ') . ' ' . str_pad($w['Login'], 8, ' ') . str_pad($w['Nama'], 35, ' ') . ' ' . str_pad($w['Gelar'], 22, ' ') . str_pad($w['Homebase'], 6, ' ') . str_pad($w['Telephone'], 15, ' ') . str_pad($w['Alamat'], 50, ' ') . $_lf; fwrite($f, $isi); } fwrite($f, $div); fwrite($f, str_pad('Halaman : ' . $hal . "/" . $jumhal, 10, ' ') . $_lf); fwrite($f, str_pad("Dicetak oleh : " . $_SESSION['_Login'], 20, ' ') . str_pad("Dicetak Tgl : " . $_Tgl, 130, ' ', STR_PAD_LEFT) . $_lf . $_lf); fwrite($f, str_pad("Akhir laporan", 149, ' ', STR_PAD_LEFT)); fwrite($f, chr(12)); fclose($f); TampilkanFileDWOPRN($nmf, "dosen"); }
function AmbilJadwal($thn, $p) { // Buat headernya dulu $p->SetFont('Helvetica', 'B', 9); $t = 6; $p->Cell(10, $t, 'Ambil', 1, 0, 'C'); $p->Cell(8, $t, 'No', 1, 0); $p->Cell(20, $t, 'Kode MK', 1, 0); $p->Cell(90, $t, 'Matakuliah', 1, 0); $p->Cell(9, $t, 'SKS', 1, 0); $p->Cell(70, $t, 'Dosen Pengajar', 1, 0); $p->Cell(14, $t, 'Hari', 1, 0); $p->Cell(22, $t, 'Jam', 1, 0); $p->Cell(14, $t, 'Kelas', 1, 0, 'C'); $p->Cell(18, $t, 'Ruangan', 1, 0, 'C'); $p->Ln($t); // Parameters $whr_hari = $_SESSION['_jdwlHari'] == '' ? '' : "and j.HariID = '{$_SESSION['_jdwlHari']}' "; $whr_kelas = $_SESSION['_jdwlKelas'] == '' ? '' : "and j.NamaKelas= '{$_SESSION['_jdwlKelas']}' "; $whr_smt = $_SESSION['_jdwlSemester'] == '' ? '' : "and mk.Sesi = '{$_SESSION['_jdwlSemester']}' "; // Ambil Isinya $s = "select j.*,\r\n j.Nama as MK,\r\n h.Nama as HR, \r\n LEFT(j.JamMulai, 5) as JM, LEFT(j.JamSelesai, 5) as JS,\r\n if (d.Nama is NULL or d.Nama = '', 'Belum diset', concat(d.Nama, ', ', d.Gelar)) as DSN,\r\n date_format(j.UASTanggal, '%d-%m-%Y') as _UASTanggal,\r\n date_format(j.UASTanggal, '%w') as _UASHari,\r\n huas.Nama as HRUAS,\r\n \t if (j.JadwalRefID != 0,'(LAB)','') as _lab,\r\n LEFT(j.UASJamMulai, 5) as _UASJamMulai, LEFT(j.UASJamSelesai, 5) as _UASJamSelesai,\r\n\t k.Nama AS namaKelas\r\n from jadwal j\r\n left outer join hari h on h.HariID = j.HariID\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n left outer join hari huas on huas.HariID = date_format(j.UASTanggal, '%w')\r\n left outer join mk on mk.MKID = j.MKID \r\n\t LEFT OUTER JOIN kelas k ON k.KelasID = j.NamaKelas\r\n where j.KodeID = '" . KodeID . "'\r\n and j.TahunID = '{$_SESSION['_jdwlTahun']}'\r\n and j.ProdiID = '{$_SESSION['_jdwlProdi']}'\r\n and j.ProgramID = '{$_SESSION['_jdwlProg']}'\r\n {$whr_hari} {$whr_kelas} {$whr_smt}\r\n order by j.Nama, j.HariID"; $r = _query($s); //die("<pre>$s</pre>"); $n = 0; $_h = 'akjsdfh'; $_p = 'la;skdjfadshg'; $t = 6; if (_num_rows($r) > 0) { while ($w = _fetch_array($r)) { $n++; $hr = $w['HR']; $p->SetFont('Helvetica', '', 8); $p->Cell(10, $t, '', 1, 0); $p->Cell(8, $t, $n, 1, 0, 'R'); $p->Cell(20, $t, $w['MKKode'], 1); $p->Cell(90, $t, $w['MK'] . ' ' . $w[_lab], 1); $p->Cell(9, $t, $w['SKS'], 1, 0, 'C'); $p->Cell(70, $t, $w['DSN'], 1); $p->Cell(14, $t, $hr, 1); $p->Cell(22, $t, $w['JM'] . ' - ' . $w['JS'], 1); $p->Cell(14, $t, $w['namaKelas'], 1, 0, 'C'); $p->Cell(18, $t, $w['RuangID'], 1, 0, 'C'); $p->SetXY(13, $p->GetY() + 1); $p->Cell(4, 4, '', 1, 0); $p->SetXY(10, $p->GetY() - 1); $p->Ln($t); } } else { $p->Cell(100, $t, 'TAHUN TIDAK DITEMUKAN! Harap menghubungi KaBaa untuk mensetup tahun akademik ini', 0, 1); } }
function Proses_Tutup_Keuangan() { global $_lf; $tahun = $_REQUEST['tahun']; $keu = GetFields("keusetup", "NA", "N", "*"); $prid = $_REQUEST['prid']; $prodi = $_REQUEST['prodi']; // Ambil data next semester $s0 = "select TahunID from tahun\r\n where TahunID>'{$tahun}'\r\n and ProgramID='{$prid}' and ProdiID='{$prodi}'\r\n limit 1"; $r0 = _query($s0); if (_num_rows($r0) == 0) { die("Tahun akademik setelah <b>{$tahun}</b> belum dibuat. <br />\r\n Hubungi Ka BAA untuk membuat tahun akademik baru terlebih dahulu."); } $w0 = _fetch_array($r0); $tahun2 = $w0['TahunID']; echo "<p>Proses untuk <b>{$tahun}</b>, Program: <b>{$prid}</b>, Program Studi: <b>{$prodi}</b><br />\r\n Nilai hutang/deposit akan ditransfer ke: <b>{$tahun2}</b></p><hr size=1>"; if (!empty($tahun) && !empty($prid) && !empty($prodi)) { $s = "select khs.KHSID, khs.MhswID, khs.Sesi, khs.SKS, khs.BIPOTID,\r\n khs.SaldoAwal, khs.Biaya, khs.Potongan, khs.Bayar, khs.Tarik\r\n from khs khs\r\n where khs.TahunID='{$tahun}'\r\n and khs.ProgramID='{$prid}'\r\n and khs.ProdiID='{$prodi}'\r\n and khs.Tutup='N'\r\n order by khs.MhswID"; $r = _query($s); $btn = "<input type=button name='Tutup' value='Tutup' onClick='javascript:window.close()'>"; echo $btn . "<pre>"; while ($w = _fetch_array($r)) { $posisi = $w['Biaya'] - $w['Bayar'] - $w['Potong'] + $w['Tarik']; $TrxID = $posisi >= 0 ? 1 : -1; // Jika ada transaksi if ($posisi > 0) { // set data semester ini $str1 = "{$keu['HutangNext']}=>{$posisi}, {$keu['HutangPrev']}=>{$posisi}"; $s1 = "insert into bipotmhsw (TahunID, PMBMhswID, PMBID, MhswID,\r\n BIPOT2ID, BIPOTNamaID, TrxID, Jumlah, Besar, \r\n Dibayar, Catatan,\r\n LoginBuat, TanggalBuat)\r\n values('{$tahun}', 1, '', '{$w['MhswID']}',\r\n '0', '{$keu['HutangNext']}', -1, 1, '0', \r\n '{$posisi}', 'Transfer ke semester berikutnya',\r\n '{$_SESSION['_Login']}', now() )"; $r1 = _query($s1); // Set balance $s1a = "update khs set Bayar=Bayar+{$posisi} where KHSID={$w['KHSID']}"; $r1a = _query($s1a); // set data semester depan $s2 .= "insert into bipotmhsw (TahunID, PMBMhswID, PMBID, MhswID,\r\n BIPOT2ID, BIPOTNamaID, TrxID, Jumlah, Besar,\r\n Dibayar, Catatan, LoginBuat, TanggalBuat)\r\n values('{$tahun2}', -1, '', '{$w['MhswID']}',\r\n '0', '{$keu['HutangNext']}', 1, 1, '{$posisi}',\r\n '0', 'Transfer dari semester sebelumnya', '{$_SESSION['_Login']}', now() )"; $r2 = _query($s2); // Set balance semester berikutnya $s2a = "update khs set Biaya=Biaya+{$posisi} where MhswID='{$w['MhswID']}' and TahunID='{$tahun2}' "; $r2a = _query($s2a); } elseif ($posisi < 0) { $s1 = "{$keu['DepositNext']}=>{$posisi}, {$keu['DepositPrev']}=>{$posisi}"; } else { $str1 = " >< "; } echo str_pad($w['MhswID'], 20) . str_pad(number_format($posisi), 20, ' ', STR_PAD_LEFT) . ' ' . $str1 . $_lf; } echo "</pre>" . $btn; } else { echo ErrorMsg("Gagal Proses", "Tentukan Tahun Akademik, Program, dan Program Studi terlebih dahulu."); } }
function TampilkanAD() { $s = "select pm.Mhswid as MhswID, pm.Nilai as Nilai, jp.Nama\r\n from presensimhsw pm\r\n left outer join jadwal on jadwal.JadwalID = pm.jadwalID\r\n left outer join jenispresensi jp on pm.JenisPresensiID = jp.JenisPresensiID\r\n where jadwal.tahunID = '20061'\r\n and pm.JenisPresensiID in ('I','S')"; $r = _query($s); $n = 0; $jumlahrec = _num_rows($r); echo "<b><p>Jumlah Record : {$jumlahrec}</p></b>"; echo "<table><tr><td class=ul><a href=_proses_Presensi.php>Proses Presensi</a></td></tr></table>"; echo "<p><table class=box cellspacing=1 cellpadding=4>\r\n <tr><th class=ttl>#</th>\r\n <th class=ttl>NIM</th>\r\n <th class=ttl>Kehadiran</th>\r\n <th class=ttl>Nilai</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $n++; echo "<tr><td class=inp>{$n}</td>\r\n\t <td class=ul>{$w['MhswID']}</td>\r\n\t <td class=ul>{$w['Nama']}\r\n\t <td class=ul>{$w['Nilai']}</td>\r\n\t </tr>"; } echo "</table></p>"; }
function TampilkanDaftar() { $s = "select mk.MKID, mk.MKKode, mk.Nama, mk.SKS, k.KurikulumKode as KUR, mk.Sesi, hs.DefKehadiran as RencanaKehadiran, hs.DefMaxAbsen as MaxAbsen, mk.Responsi\r\n from mk mk\r\n left outer join kurikulum k on mk.KurikulumID = k.KurikulumID\r\n\t left outer join hadirsks hs on mk.SKS = hs.SKS and mk.ProdiID = hs.ProdiID and hs.KodeID='" . KodeID . "'\r\n where mk.KodeID = '" . KodeID . "'\r\n and mk.Nama like '%{$_SESSION['Nama']}%'\r\n and mk.NA = 'N'\r\n and mk.ProdiID = '{$_SESSION['ProdiID']}'\r\n and k.NA = 'N'\r\n order by mk.MKKode, mk.Nama"; $r = _query($s); $i = 0; //echo "<pre>$s</pre>"; $jml = _num_rows($r); if ($jml == 0) { echo "<p style='background-color: red; color: white; text-align:center'>\r\n <b>Tidak ada data matakuliah.<br />\r\n Mungkin tidak ada kurikulum yang aktif.<br />\r\n Hubungi BAA atau Sysadmin untuk informasi lebih detail.\r\n </b></p>"; } echo "<table class=bsc cellspacing=1 width=100%>"; echo "<tr>\r\n <th class=ttl>#</th>\r\n <th class=ttl>Kode MK</th>\r\n <th class=ttl>Nama MK</th>\r\n <th class=ttl>SKS</th>\r\n <th class=ttl>Sesi</th>\r\n\t<th class=ttl>Lab?</th>\r\n <th class=ttl>Kurikulum</th>\r\n </tr>"; while ($w = _fetch_array($r)) { $i++; $RencanaKehadiranDariProdi = GetaField('prodi', "KodeID='" . KodeID . "' and ProdiID", $_SESSION['ProdiID'], 'DefKehadiran'); $RencanaKehadiran = empty($w[RencanaKehadiran]) ? "{$RencanaKehadiranDariProdi}" : "{$w['RencanaKehadiran']}"; $MaxAbsenDariProdi = GetaField('prodi', "KodeID='" . KodeID . "' and ProdiID", $_SESSION['ProdiID'], 'DefMaxAbsen'); $MaxAbsen = empty($w[MaxAbsen]) ? "{$MaxAbsenDariProdi}" : "{$w['MaxAbsen']}"; echo <<<SCR <tr> <td class=inp width=20>{$i}</td> <td class=ul1 width=100>{$w['MKKode']}</td> <td class=ul1> <a href="javascript: \t\t\t\t{$_SESSION['frm']}.MKID.value='{$w['MKID']}'; \t\t\t\t{$_SESSION['frm']}.MKKode.value='{$w['MKKode']}'; \t\t\t\t{$_SESSION['frm']}.MKNama.value='{$w['Nama']}'; \t\t\t\t{$_SESSION['frm']}.SKS.value='{$w['SKS']}'; /* fungsi ini dihilangkan \t\t\tif('{$w['Responsi']}'=='Y') {$_SESSION['frm']}.AdaResponsi.checked=true; \t\t\t\t{$_SESSION['frm']}.RencanaKehadiran.value='{$RencanaKehadiran}'; \t\t\t\t{$_SESSION['frm']}.MaxAbsen.value='{$MaxAbsen}'; */ \t\t\t\ttoggleBox('{$_SESSION['div']}', 0)"> \t\t\t\t\t{$w['Nama']} \t\t</a> </td> <td class=ul1 width=10 align=right>{$w['SKS']}</td> <td class=ul1 width=10 align=right>{$w['Sesi']}</td> \t <td class=ul1 width=10 align=right>{$w['Responsi']}</td> <td class=ul1>{$w['KUR']}</td> </tr> SCR; } echo "</table></p>"; }
function ProsesMhswCuti0() { TampilkanJudul("Proses..."); $s = "select * from _mhswcuti order by TahunID, MhswID"; $r = _query($s); $n = 0; $_SESSION['CUTI-JML'] = _num_rows($r); $_SESSION['CUTI-POS'] = 0; while ($w = _fetch_array($r)) { $n++; $_SESSION['CUTI-MhswID-' . $n] = $w['MhswID']; $_SESSION['CUTI-TahunID-' . $n] = $w['TahunID']; $_SESSION['CUTI-StatusMhswID-' . $n] = $w['StatusMhswID']; } echo "<IFRAME src='_proses_mhsw_cuti.php?gos=ProsesMhswCuti' width=90% height=80%></IFRAME>"; }
function TampilkanDaftarMhsw($jdwl) { $s = "select k.KRSID, k.MhswID, m.Nama\r\n from krs k\r\n left outer join mhsw m on k.MhswID=m.MhswID\r\n where k.JadwalID='{$jdwl['JadwalID']}'\r\n order by k.MhswID"; $r = _query($s); $n = 0; $jml = _num_rows($r) + 0; echo "<input type=hidden name='JmlMhsw' value={$jml}>"; echo "<p><table class=box cellspacing=1 cellpadding=4>"; $hdr = "<tr><th class=ttl>#</th>\r\n <th class=ttl>N.P.M</th>\r\n <th class=ttl>Nama</th>\r\n <th class=ttl>Centang</th>\r\n </tr>"; echo $hdr; 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><input type=checkbox id='KRSID_{$n}' name='KRSID_{$n}' value='{$w['KRSID']}' checked></td>\r\n </tr>"; } echo "</table></form>"; }
function ProsesHitung() { $s = "select KHSID, MhswID\r\n from khs\r\n where TahunID='{$_SESSION['tahun']}'\r\n and ProdiID='{$_SESSION['prodi']}'\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']; } $_SESSION['HTG-Max-' . $_SESSION['prodi']] = $jml; $_SESSION['HTG-Pos-' . $_SESSION['prodi']] = 0; // IFRAME echo "<p><IFRAME src='_proseshitungkeumhsw.go.php?gos=prckeu' frameborder=0 height=400 width=300>\r\n </IFRAME></p>"; }
function ProsesHitung() { $s = "select KHSID, MhswID\r\n from khs\r\n where TahunID='{$_SESSION['tahun']}'\r\n and ProdiID='{$_SESSION['prodi']}'\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>"; echo "<p><table class=box cellpadding=4 cellspacing=1>\r\n <tr><th class=ttl>MHSWID</th><th class=ttl>Balance 20061</th><th class=ttl>Balance 20062</th>"; while ($w = _fetch_array($r)) { $khs = GetFields('khs', 'tahunid', 20061, "Biaya , Bayar , Tarik , Potongan"); $balance = $khs['Bayar'] - $khs['Biaya'] + $khs['Potongan'] - $khs['Tarik']; $bal = GetFields('bipotmhsw bm', 'tahunID = 20062 and MhswID', $w['MhswID'], "(bm.Jumlah * bm.Besar) as TOT,\r\n format(bm.Jumlah * bm.Besar, 0) as TOTS,\r\n format(bm.Dibayar, 0) as BYR, format(bm.Besar, 0) as BSR"); $balance2 = $bal['TOT'] - $bal['BSR']; echo "<tr><td class=ul>{$w['MhswID']}</td><td class=ul>" . number_format($balance) . "</td><td class=ul>" . number_format($balance2) . "</td></tr>"; } echo "</table></p>"; }