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;
}
