function CetakKursi($id, $pdf)
{
$jdwl = GetFields("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\tLEFT OUTER JOIN kelas k ON k.KelasID = j.NamaKelas\r\n ", "j.JadwalID", $id, "j.*, CONCAT(d.Nama, ', ', d.Gelar) as DSN,\r\n prd.Nama as _PRD, prg.Nama as _PRG,\r\n mk.Sesi,\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,\r\n\tk.Nama AS namaKelas\r\n ");
$TahunID = $jdwl['TahunID'];
$thn = GetFields('tahun', "KodeID = '" . KodeID . "' and ProdiID = '{$jdwl['ProdiID']}' and ProgramID = '{$jdwl['ProgramID']}' and TahunID", $TahunID, "*");
// Cetak
BuatHeaderKursi($jdwl, $thn, $pdf);
BuatIsinya($jdwl, $pdf);
}
function CetakKursi($id, $pdf)
{
$jdwl = GetFields("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 huts on huts.HariID = date_format(j.UTSTanggal, '%w')\r\n ", "j.JadwalID", $id, "j.*, concat(d.Nama, ', ', d.Gelar) as DSN,\r\n prd.Nama as _PRD, prg.Nama as _PRG,\r\n mk.Sesi,\r\n date_format(j.UTSTanggal, '%d-%m-%Y') as _UTSTanggal,\r\n date_format(j.UTSTanggal, '%w') as _UTSHari,\r\n huts.Nama as HRUTS,\r\n LEFT(j.UTSJamMulai, 5) as _UTSJamMulai, LEFT(j.UTSJamSelesai, 5) as _UTSJamSelesai\r\n ");
$TahunID = $jdwl['TahunID'];
$thn = GetFields('tahun', "KodeID = '" . KodeID . "' and ProdiID = '{$jdwl['ProdiID']}' and ProgramID = '{$jdwl['ProgramID']}' and TahunID", $TahunID, "*");
// Cetak
BuatHeaderKursi($jdwl, $thn, $pdf);
BuatIsinya($jdwl, $pdf);
}