function Nilai2($jdwl) { if (!empty($jdwl)) { //CekHakAksesJadwal($_SESSION['_nilaiJadwalID']); TampilkanTabNilai($jdwl); TampilkanHeaderMK($jdwl); TampilkanPenilaian($jdwl); } }
function Nilai2() { if (!empty($_SESSION['_nilaiJadwalID'])) { $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 hari hr on j.HariID = hr.HariID\r\n left outer join hari hruas on hruas.HariID = date_format(j.UASTanggal, '%w')\r\n\tleft outer join jenisjadwal jj on jj.JenisJadwalID = j.JenisJadwalID\r\n\tleft outer join jadwaluas ju on ju.JadwalID = j.JadwalID\r\n\tleft outer join hari huas on huas.HariID = date_format(ju.Tanggal, '%w') \r\n\tLEFT OUTER JOIN kelas k ON k.KelasID = j.NamaKelas\r\n ", "j.JadwalID", $_SESSION['_nilaiJadwalID'], "j.*, concat(d.Nama, ' <sup>', d.Gelar, '</sup>') as DSN,\r\n prd.Nama as _PRD, hr.Nama as _HR, huas.Nama as _HRUAS,\r\n LEFT(j.JamMulai, 5) as _JM, LEFT(j.JamSelesai, 5) as _JS,\r\n LEFT(ju.JamMulai, 5) as _JMUAS, LEFT(ju.JamSelesai, 5) as _JSUAS,\r\n date_format(ju.Tanggal, '%d-%m-%Y') as _UASTanggal,\r\n\tjj.Nama as _NamaJenisJadwal, jj.Tambahan, k.Nama AS namaKelas\r\n "); //CekHakAksesJadwal($_SESSION['_nilaiJadwalID']); TampilkanTabNilai(); TampilkanHeaderMK($jdwl); TampilkanPenilaian($jdwl); } }