function AmbilJadwal($TahunID, $dsn, $p) { $s = "select j.*,\r\n left(j.JamMulai, 5) as _JM,\r\n left(j.JamSelesai, 5) as _JS, \r\n\t k.Nama AS namaKelas\r\n from jadwal j\r\n\tLEFT OUTER JOIN kelas k ON k.KelasID = j.NamaKelas\r\n where j.TahunID = '{$TahunID}'\r\n and j.DosenID = '{$dsn['Login']}'\r\n and j.KodeID = '" . KodeID . "'\r\n order by j.HariID, j.JamMulai, j.JamSelesai"; $r = _query($s); $n = 0; $t = 6; $hr = -25; $ttl = 0; while ($w = _fetch_array($r)) { if ($hr != $w['HariID']) { $hr = $w['HariID']; $NamaHari = GetaField('hari', 'HariID', $hr, 'Nama'); TampilkanHeaderTabel($NamaHari, $p); } $n++; $ttl += $w['SKS']; $p->SetFont('Helvetica', '', 9); $p->Cell(7, $t, $n, 1, 0); $p->Cell(20, $t, $w['_JM'] . '-' . $w['_JS'], 1, 0); $p->Cell(24, $t, $w['MKKode'], 1, 0); $p->Cell(70, $t, $w['Nama'], 1, 0); $p->Cell(8, $t, $w['SKS'], 1, 0, 'R'); $p->Cell(18, $t, $w['namaKelas'], 1, 0); $p->Cell(18, $t, $w['RuangID'], 1, 0); $p->Cell(14, $t, $w['ProgramID'], 1, 0); $p->Cell(14, $t, $w['ProdiID'], 1, 0); $p->Ln($t); } $p->SetFont('Helvetica', '', 10); $p->Cell(100, $t, "Total SKS: " . $ttl, 0, 1); }
function DaftarMhsw($dsn, $p) { $s = "select m.MhswID, m.Nama as NamaMhsw, m.TahunID,\r\n m.ProdiID, p.Nama as _Prodi, m.ProdiID\r\n from mhsw m\r\n left outer join prodi p on p.ProdiID = m.ProdiID and p.KodeID = '" . KodeID . "'\r\n where m.KodeID = '" . KodeID . "'\r\n and m.PenasehatAkademik = '{$dsn['Login']}'\r\n and m.Keluar = 'N'\r\n order by m.TahunID, m.ProdiID, m.MhswID"; $r = _query($s); $n = 0; $t = 5; $_prd = 'lkasjdhfaksdjkhf-19823'; $lbr = 190; while ($w = _fetch_array($r)) { if ($_prd != $w['ProdiID']) { $_prd = $w['ProdiID']; $p->SetFont('Helvetica', 'B', 9); $p->Cell($lbr, $t + 1, $w['ProdiID'] . ' - ' . $w['_Prodi'], 0, 1); TampilkanHeaderTabel($p); $n = 0; } $n++; $p->SetFont('Helvetica', '', 9); $p->Cell(18, $t, $n, 1, 0); $p->Cell(30, $t, $w['MhswID'], 1, 0); $p->Cell(100, $t, $w['NamaMhsw'], 1, 0); $p->Cell(30, $t, $w['TahunID'], 1, 0); $p->Ln($t); } }
function BuatRekap($TahunID, $ProdiID, $ProgramID, $HariID, $p) { global $lbr; $whr_program = $ProgramID == '' ? '' : "and j.ProgramID = '{$ProgramID}' "; $whr_hari = $HariID == '' ? '' : "and j.HariID = '{$HariID}' "; $s = "select j.*, left(concat(d.Nama, ', ', d.Gelar), 25) as DSN,\r\n left(j.Nama, 22) as MKNama,\r\n prd.Nama as _PRD, prg.Nama as _PRG,\r\n mk.Sesi, h.Nama as _HR,\r\n left(j.JamMulai, 5) as _JM, left(j.JamSelesai, 5) as _JS,\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 LEFT(j.UASJamMulai, 5) as _UASJamMulai, LEFT(j.UASJamSelesai, 5) as _UASJamSelesai, k.Nama AS namaKelas\r\n from jadwal j\r\n left outer join dosen d on d.Login = j.DosenID and d.KodeID = '" . KodeID . "'\r\n left outer join prodi prd on prd.ProdiID = j.ProdiID and prd.KodeID = '" . KodeID . "'\r\n left outer join program prg on prg.ProgramID = j.ProgramID and prg.KodeID = '" . KodeID . "'\r\n left outer join mk mk on mk.MKID = j.MKID\r\n left outer join hari huas on huas.HariID = date_format(j.UASTanggal, '%w')\r\n left outer join hari h on h.HariID = j.HariID \r\n\t LEFT OUTER JOIN kelas k ON k.KelasID = j.NamaKelas\r\n where j.NA = 'N'\r\n and j.TahunID = '{$TahunID}'\r\n and j.ProdiID = '{$ProdiID}'\r\n {$whr_program}\r\n {$whr_hari}\r\n order by j.ProgramID, j.HariID, j.JamMulai, j.JamSelesai\r\n "; $r = _query($s); $n = 0; $t = 5; $prghr = ';lasdkjf;asdf'; while ($w = _fetch_array($r)) { if ($prghr != $w['ProgramID'] . $w['HariID']) { $prghr = $w['ProgramID'] . $w['HariID']; $p->SetFont('Helvetica', 'B', 10); $p->Cell($lbr, 10, $w['_HR'] . " -- (" . $w['_PRG'] . ")", 'B', 1); TampilkanHeaderTabel($p); $n = 0; } $persen = $w['RencanaKehadiran'] == 0 ? 0 : $w['Kehadiran'] / $w['RencanaKehadiran'] * 100; $persen = number_format($persen, 2); $n++; $p->SetFont('Helvetica', '', 9); $p->Cell(10, $t, $n, 'B', 0); $p->Cell(20, $t, $w['MKKode'], 'B', 0); $p->Cell(45, $t, $w['MKNama'], 'B', 0); $p->Cell(10, $t, $w['SKS'], 'B', 0, 'C'); $p->Cell(10, $t, $w['namaKelas'], 'B', 0); $p->Cell(20, $t, $w['_JM'] . '-' . $w['_JS'], 'B', 0); $p->Cell(50, $t, $w['DSN'], 'B', 0); $p->Cell(15, $t, $w['Kehadiran'] . "/" . $w['RencanaKehadiran'], 'B', 0, 'R'); $p->Cell(10, $t, $persen, 'B', 0, 'R'); $p->Ln($t); } }
function JadwalDosen($TahunID, $dsn) { TampilkanPilihanTahun($TahunID, $dsn['Login']); $s = "select j.*,\r\n left(j.JamMulai, 5) as _JM, left(j.JamSelesai, 5) as _JS,\r\n p.Nama as NamaProdi, if(jd.DosenID = '08.0211.037','Team Teaching','Dosen Pengampu') as Status\r\n from jadwal j\r\n left outer join prodi p on p.ProdiID = j.ProdiID and p.KodeID = '" . KodeID . "'\r\n left outer join jadwaldosen jd on jd.JadwalID = j.JadwalID\r\n where j.TahunID = '{$TahunID}'\r\n and j.KodeID = '" . KodeID . "'\r\n and j.DosenID = '{$dsn['Login']}' or (jd.DosenID = '{$_SESSION['dsnid']}')\r\n order by j.HariID, j.JamMulai, j.JamSelesai"; $r = _query($s); $n = 0; $ttl = 0; $hr = -25; echo "<table class=box cellspacing=1 align=center width=810>"; while ($w = _fetch_array($r)) { if ($hr != $w['HariID']) { $hr = $w['HariID']; $Hari = GetaField('hari', 'HariID', $hr, 'Nama'); TampilkanHeaderTabel($Hari); } $n++; $ttl += $w['SKS']; echo <<<ESD <tr> <td class=inp>{$n}</td> <td class=ul><sup>{$w['_JM']}</sup>→<sub>{$w['_JS']}</td> <td class=ul>{$w['MKKode']}</td> <td class=ul>{$w['Nama']}</td> <td class=ul align=right>{$w['SKS']}</td> <!--<td class=ul>{$w['NamaKelas']}</td>--> <td class=ul>{$w['RuangID']}</td> <td class=ul> <sup>{$w['ProgramID']}</sup> <div align=right> <sub><abbr title='{$w['NamaProdi']}'>→{$w['ProdiID']}</abbr></sub> </div> </td> <td class=ul>{$w['Status']}</td> ESD; } RandomStringScript(); echo <<<ESD <tr><td class=ul1 colspan=4 align=right>Total SKS:</td> <td class=ul1 align=right><font size=+1>{$ttl}</font></td> <td class=ul1 colspan=4></td> </tr> </table> <script> <!-- function CetakJadwal(thn, dsn) { var _rnd = randomString(); lnk = "{$_SESSION['mnux']}.cetak.php?TahunID="+thn+"&DosenID="+dsn+"&_rnd="+_rnd; win2 = window.open(lnk, "", "width=800, height=600, scrollbars, status"); if (win2.opener == null) childWindow.opener = self; } //--> </script> ESD; }