PHP _query函数代码示例

function AkademikSav()
{
    // Cek Kelengkapan
    $_syarat = array();
    $_syarat = $_REQUEST['PMBSyaratID'];
    $syarat = empty($_syarat) ? '' : '.' . implode('.', $_syarat) . '.';
    // Cek Kelengkapan
    $mhsw = GetFields('mhsw', 'MhswID', $_REQUEST['mhswid'], 'StatusAwalID, ProdiID, Syarat, SyaratLengkap');
    $s = "select PMBSyaratID, Nama\r\n    from pmbsyarat\r\n    where NA='N' and KodeID='{$_SESSION['KodeID']}'\r\n      and INSTR(StatusAwalID, '.{$mhsw['StatusAwalID']}.') >0\r\n      and INSTR(ProdiID, '.{$mhsw['ProdiID']}.') >0\r\n    order by PMBSyaratID";
    $r = _query($s);
    $lkp = True;
    if (!empty($_syarat)) {
        while ($w = _fetch_array($r)) {
            if (array_search($w['PMBSyaratID'], $_syarat) === false) {
                $lkp = false;
            }
        }
    } else {
        $lkp = false;
    }
    $Lengkap = $lkp == true ? 'Y' : 'N';
    // Simpan
    $s = "update mhsw set PenasehatAkademik='{$_REQUEST['PenasehatAkademik']}', ProgramID='{$_REQUEST['ProgramID']}',\r\n    StatusAwalID='{$_REQUEST['StatusAwalID']}', StatusMhswID='{$_REQUEST['StatusMhswID']}',\r\n    Syarat='{$syarat}', SyaratLengkap='{$Lengkap}', BatasStudi='{$_REQUEST['BatasStudi']}'\r\n    where MhswID='{$_REQUEST['mhswid']}' ";
    $r = _query($s);
}

function ABSSAV()
{
    $inFile = $_REQUEST['inFile'];
    echo "Filename is: {$inFile}<br>";
    require_once 'Excel/reader.php';
    $data = new Spreadsheet_Excel_Reader();
    $data->setOutputEncoding('CP1251');
    $data->read($inFile);
    error_reporting(E_ALL ^ E_NOTICE);
    $Target_Database = 'binawan';
    $Target_Table = $Target_Database . '.ruang';
    $Target_KodeID = "BINAWAN";
    $s = "TRUNCATE TABLE {$Target_Table}";
    $r = _query($s);
    for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
        $w = array();
        $w['RuangID'] = trim($data->sheets[0]['cells'][$i][2]);
        $w['Nama'] = trim($data->sheets[0]['cells'][$i][3]);
        $w['Kapasitas'] = trim($data->sheets[0]['cells'][$i][4]);
        $w['KapasitasUjian'] = trim($data->sheets[0]['cells'][$i][4]);
        $w['KolomUjian'] = trim($data->sheets[0]['cells'][$i][5]);
        $w['KampusID'] = trim($data->sheets[0]['cells'][$i][6]);
        $w['Lantai'] = trim($data->sheets[0]['cells'][$i][7]);
        $w['RuangKuliah'] = trim($data->sheets[0]['cells'][$i][8]);
        $s = "insert into {$Target_Table}\r\n          (RuangID, Nama, Kapasitas, KapasitasUjian, KolomUjian, KampusID, Lantai, KodeID, RuangKuliah, UntukUSM\r\n\t      )\r\n          values\r\n          ('{$w['RuangID']}', '{$w['Nama']}', '{$w['Kapasitas']}', '{$w['KapasitasUjian']}', '{$w['KolomUjian']}', '{$w['KampusID']}', '{$w['Lantai']}', 'BINAWAN', '{$w['RuangKuliah']}', '{$w['RuangKuliah']}'\r\n\t      )";
        $r = _query($s);
    }
    echo "<script>window.location = '?{$mnux}={$_SESSION['mnux']}'</script>";
}

function TampilkanDaftarProgramStudi()
{
    global $Cari;
    $Max = 50;
    $arrcr = explode(',', $Cari);
    $arrwhr = array();
    if (!empty($arrcr[0])) {
        $arrwhr[] = "(Nama like '%" . TRIM($arrcr[0]) . "%') ";
    }
    $whr = implode(' and ', $arrwhr);
    // Hitung jumlah baris
    $Jml = GetaField('perguruantinggi', "{$whr} and NA", 'N', "count(PerguruanTinggiID)");
    if ($Jml > $Max) {
        $_Jml = number_format($Jml);
        echo "<p><b>Catatan:</b> Jumlah program studi yang Anda cari mencapai: <b>{$_Jml}</b>, tetapi sistem membatasi\r\n      jumlah program studi yang ditampilkan dan hanya menampilkan: <b>{$Max}</b>.\r\n      Gunakan Nama program studi dengan lebih spesifik untuk membatasi\r\n      jumlah program studi yang ditampilkan.</p>\r\n\r\n      <p><b>Format Pencarian:</b> NamaProgramStudi</p>";
    }
    // Tampilkan
    $s = "select ProdiDiktiID, Nama\r\n    from prodidikti\r\n    where {$whr} and NA='N'\r\n    order by Nama limit {$Max}";
    $r = _query($s);
    $n = 0;
    echo "<p><table class=box cellspacing=1 cellpadding=4 width=100%>\r\n    <tr><th class=ttl>#</th>\r\n    <th class=ttl>Kode Prodi</th>\r\n    <th class=ttl>Nama</th>\r\n    </tr>";
    while ($w = _fetch_array($r)) {
        $n++;
        echo "<tr><td class=ul>{$n}</td>\r\n    <td class=ul><a href='javascript:kembalikan(\"{$w['ProdiDiktiID']}\", \"{$w['Nama']}\")'>{$w['ProdiDiktiID']}</a></td>\r\n    <td class=ul>{$w['Nama']}&nbsp;</td>\r\n    </tr>";
    }
    echo "</table></p>";
}

function BuatIsinya($jdwl, $p)
{
    $s = "select pm.MhswID, m.Nama, sum(pm.Nilai) as HDR\r\n    from presensimhsw pm\r\n      left outer join mhsw m on m.MhswID = pm.MhswID and m.KodeID = '" . KodeID . "'\r\n    where pm.JadwalID = '{$jdwl['JadwalID']}'\r\n    group by pm.MhswID";
    $r = _query($s);
    $n = 0;
    $t = 6;
    // Buat header dulu
    $p->SetFont('Helvetica', 'BI', 9);
    $p->Cell(10, $t, 'No', 'BT', 0);
    $p->Cell(22, $t, 'NIM', 'BT', 0);
    $p->Cell(70, $t, 'Mahasiswa', 'BT', 0);
    $p->Cell(20, $t, 'Hadir', 'BT', 0, 'R');
    $p->Cell(20, $t, 'Persen', 'BT', 0, 'R');
    $p->Ln($t);
    // Isinya
    $p->SetFont('Helvetica', '', 9);
    while ($w = _fetch_array($r)) {
        $n++;
        $persen = $jdwl['Kehadiran'] > 0 ? $w['HDR'] / $jdwl['Kehadiran'] * 100 : 0;
        $_persen = number_format($persen, 2);
        $p->Cell(10, $t, $n, 'B', 0);
        $p->Cell(22, $t, $w['MhswID'], 'B', 0);
        $p->Cell(70, $t, $w['Nama'], 'B', 0);
        $p->Cell(20, $t, $w['HDR'] . '/' . $jdwl['Kehadiran'], 'B', 0, 'R');
        $p->Cell(20, $t, $_persen . '%', 'B', 0, 'R');
        $p->Ln($t);
    }
}

function Gagalkan($jdwl)
{
    $id = $_REQUEST['id'];
    $NilaiGagal = $_REQUEST['NilaiGagal'];
    if (empty($NilaiGagal)) {
        echo ErrorMsg("Nilai Belum Diset", "Anda harus mengeset nilai gagal penilaian dosen untuk matakuliah ini.<br>\r\n      Proses Gagal Nilai Dosen tidak dilakukan.");
    } else {
        // Gagalkan jadwal
        $Nilai = GetFields('nilai', 'NilaiID', $NilaiGagal, '*');
        $BobotNilai = $Nilai['Bobot'];
        $GradeNilai = $Nilai['Nama'];
        $CatatanGagal = sqling($_REQUEST['CatatanGagal']);
        $s = "update jadwalremedial set Gagal='Y', Final = 'Y', \r\n      CatatanGagal = '{$CatatanGagal}', NilaiGagal = '{$GradeNilai}'\r\n      where JadwalID = '{$id}' ";
        $r = _query($s);
        // Set semua nilai mahasiswa
        $s1 = "update krsremedial set GradeNilai='{$GradeNilai}', BobotNilai={$BobotNilai}, Final='Y'\r\n      where JadwalRemedialID='{$id}' and NA = 'N' ";
        $r1 = _query($s1);
        // Anggap Remedial sudah beres dan bisa di-remedialkan lagi bila diperlukan lagi nanti
        $s = "select KRSID from krsremedial where JadwalRemedialID='{$JadwalRemedialID}' and KodeID='" . KodeID . "'";
        $r = _query($s);
        while ($w = _fetch_array($r)) {
            $s1 = "update krs set SedangRemedial = 'N' where KRSID='{$w['KRSID']}' and KodeID='" . KodeIID . "'";
            $r1 = _query($s1);
        }
        // Kembali
        TutupScript($id);
    }
}

function PredDel()
{
    $PredikatID = $_REQUEST['PredikatID'];
    $s = "delete from predikat where PredikatID = '{$PredikatID}' ";
    $r = _query($s);
    BerhasilSimpan("?mnux={$_SESSION['mnux']}&mk=pred&sub=", 100);
}

function KurSav()
{
    $md = $_REQUEST['md'] + 0;
    $KurikulumID = $_REQUEST['KurikulumID'];
    $KurikulumKode = $_REQUEST['KurikulumKode'];
    $Nama = sqling($_REQUEST['Nama']);
    $Sesi = sqling($_REQUEST['Sesi']);
    $JmlSesi = $_REQUEST['JmlSesi'] + 0;
    $NA = empty($_REQUEST['NA']) ? 'N' : $_REQUEST['NA'];
    // simpan
    if ($md == 0) {
        $s = "update kurikulum set KurikulumKode='{$KurikulumKode}',\r\n      Nama='{$Nama}', Sesi='{$Sesi}', JmlSesi='{$JmlSesi}', NA='{$NA}', TglEdit=now(), LoginEdit='{$_SESSION['_Login']}'\r\n      where KurikulumID='{$_REQUEST['KurikulumID']}' ";
        $r = _query($s);
        // update jika jadi aktif
    } else {
        $s = "insert into kurikulum (KurikulumKode, KodeID, ProdiID, Nama, Sesi, JmlSesi, NA, TglBuat, LoginBuat)\r\n      values('{$KurikulumKode}', '{$_REQUEST['KodeID']}', '{$_SESSION['prodi']}', '{$Nama}', '{$Sesi}', '{$JmlSesi}', '{$NA}', now(), '{$_SESSION['_Login']}')";
        $r = _query($s);
        $KurikulumID = GetLastID();
    }
    // Non aktifkan yg lain
    /* ~~~ 03/11/2008 --> supaya bisa banyak kurikulum aktif
      if ($NA == 'N') {
        $s1 = "update kurikulum set NA='Y'
          where ProdiID='$_SESSION[prodi]' and KurikulumID<>$KurikulumID";
        $r1 = _query($s1);
      }
      */
    BerhasilSimpan("?mnux={$_SESSION['mnux']}", 100);
}

function CreateDBFNilaiMhsw()
{
    global $HeaderTRNLM;
    if (!empty($_SESSION['DariNPM'])) {
        $_SESSION['SampaiNPM'] = empty($_SESSION['SampaiNPM']) ? $_SESSION['DariNPM'] : $_SESSION['SampaiNPM'];
        $_npm = "'{$_SESSION['DariNPM']}' <= MhswID and MhswID <= '{$_SESSION['SampaiNPM']}' ";
    } else {
        $_npm = '';
    }
    $_prd = empty($_SESSION['prodi']) ? "" : "and ProdiID = '{$_SESSION['prodi']}'";
    $s = "select MhswID\r\n    from khs\r\n    where \r\n\t\t\t TahunID = '{$_SESSION['tahun']}' {$_prd} {$_npm}\r\n\t\t\t and StatusMhswID in ('A', 'C')\r\n\t\torder by MhswID";
    $r = _query($s);
    $n = 0;
    $DBFName = "dikti/TRNLM-{$_SESSION['tahun']}.DBF";
    DBFCreate($DBFName, $HeaderTRNLM);
    while ($w = _fetch_array($r)) {
        $n++;
        $_SESSION["DBF-MHSWID-{$n}"] = $w['MhswID'];
    }
    $_SESSION["DBF-TAHUN"] = $_SESSION['tahun'];
    $_SESSION["DBF-FILES"] = $DBFName;
    $_SESSION["DBF-POS"] = 0;
    $_SESSION["DBF-MAX"] = $n;
    echo "<p>Akan diproses <font size=+1>{$n}</font> data.</p>";
    echo "<p><IFRAME src='dikti.nilaimhsw.go.php' frameborder=0 height=400 width=600>\r\n  </IFRAME></p>";
}

function SekSav()
{
    $md = $_REQUEST['md'] + 0;
    $SekolahID = $_REQUEST['SekolahID'];
    $Nama = sqling($_REQUEST['Nama']);
    $JenisSekolahID = $_REQUEST['JenisSekolahID'];
    $Alamat1 = sqling($_REQUEST['Alamat1']);
    $Alamat2 = sqling($_REQUEST['Alamat2']);
    $Kota = sqling($_REQUEST['Kota']);
    $KodePos = $_REQUEST['KodePos'];
    $Telephone = sqling($_REQUEST['Telephone']);
    $Fax = sqling($_REQUEST['Fax']);
    $Website = sqling($_REQUEST['Website']);
    $Email = sqling($_REQUEST['Email']);
    $Kontak = sqling($_REQUEST['Kontak']);
    $JabatanKontak = sqling($_REQUEST['JabatanKontak']);
    $HandphoneKontak = sqling($_REQUEST['HandphoneKontak']);
    $EmailKontak = sqling($_REQUEST['EmailKontak']);
    $NA = empty($_REQUEST['NA']) ? 'N' : $_REQUEST['NA'];
    if ($md == 0) {
        $s = "update asalsekolah set Nama='{$Nama}', Alamat1='{$Alamat1}', Alamat2='{$Alamat2}',\r\n      JenisSekolahID='{$JenisSekolahID}', Kota='{$Kota}', KodePos='{$KodePos}', NA='{$NA}',\r\n      Website='{$Website}', Email='{$Email}', Telephone='{$Telephone}', Fax='{$Fax}',\r\n      Kontak='{$Kontak}', JabatanKontak='{$JabatanKontak}',\r\n      HandphoneKontak='{$HandphoneKontak}', EmailKontak='{$EmailKontak}'\r\n      where SekolahID='{$SekolahID}'";
        $r = _query($s);
    } else {
        $ada = GetFields('asalsekolah', 'SekolahID', $SekolahID, '*');
        if (!empty($ada)) {
            echo ErrorMsg("Data tidak dapat disimpan", "Data tidak dapat disimpan karena kode sekolah <b>{$SekolahID}</b> telah digunakan oleh\r\n      sekolah <b>{$ada['Nama']}</b>.<br>\r\n      Gunakan kode sekolah yg lain.");
        } else {
            $s = "insert into asalsekolah (SekolahID, Nama, JenisSekolahID, Alamat1, Alamat2, Kota, KodePos, NA,\r\n        Telephone, Fax, Website, Email, \r\n        Kontak, JabatanKontak, HandphoneKontak, EmailKontak)\r\n        values('{$SekolahID}', '{$Nama}', '{$JenisSekolahID}', '{$Alamat1}', '{$Alamat2}', '{$Kota}', '{$KodePos}', '{$NA}',\r\n        '{$Telephone}', '{$Fax}', '{$Website}', '{$Email}',\r\n        '{$Kontak}', '{$JabatanKontak}', '{$HandphoneKontak}', '{$EmailKontak}')";
            $r = _query($s);
        }
    }
    TutupScript();
}

function TampilkanDaftar()
{
    //echo $ProdiID;
    $s = "select d.Login, d.Nama, d.Gelar, d.NA\r\n    from dosen d\r\n    where d.KodeID = '" . KodeID . "'\r\n      and d.Nama like '%{$_SESSION['Nama']}%'\r\n      and INSTR(d.ProdiID, '{$_SESSION['ProdiID']}') > 0\r\n    order by d.Nama";
    $r = _query($s);
    $i = 0;
    echo "<table class=bsc cellspacing=1 width=100%>";
    echo "<tr>\r\n    <th class=ttl>#</th>\r\n    <th class=ttl>Kode/NIP</th>\r\n    <th class=ttl>Nama Dosen</th>\r\n    <th class=ttl>NA</th>\r\n    </tr>";
    while ($w = _fetch_array($r)) {
        $i++;
        if ($w['NA'] == 'Y') {
            $c = "class=nac";
            $d = "{$w['Nama']} <sup>{$w['Gelar']}</sup>";
        } else {
            $c = "class=ul";
            $d = "<a href=\"javascript:{$_SESSION['frm']}.DosenID{$_SESSION['indexKompre']}.value='{$w['Login']}';{$_SESSION['frm']}.NamaDosen{$_SESSION['indexKompre']}.value='{$w['Nama']}';toggleBox('{$_SESSION['div']}', 0)\">\r\n        &raquo;\r\n        {$w['Nama']}</a>\r\n        <sup>{$w['Gelar']}</sup>";
        }
        echo <<<SCR
      <tr>
      <td class=inp width=20>{$i}</td>
      <td {$c} width=100 align=center>{$w['Login']}</td>
      <td {$c}>{$d}</td>
      <td class=ul width=20 align=center><img src='../img/book{$w['NA']}.gif' /></td>
      </tr>
SCR;
    }
    echo "</table>";
}

function CetakDataLulus($gels, $p)
{
    $s = "select p.PMBID, p.Nama, p.AsalSekolah, p.NilaiUjian, p.NilaiSekolah,\n      p.ProdiID, p.ProgramID,\n      prg.Nama as _PRG, prd.Nama as _PRD\n    from pmb p\n      left outer join program prg on prg.ProgramID = p.ProgramID and prg.KodeID='" . KodeID . "'\n      left outer join prodi prd on prd.ProdiID = p.ProdiID and prd.KodeID='" . KodeID . "'\n    where p.KodeID = '" . KodeID . "'\n      and p.PMBPeriodID = '{$gels['PMBPeriodID']}'\n      and p.LulusUjian = 'Y'\n    order by p.ProdiID, p.ProgramID, p.PMBID ";
    $r = _query($s);
    $n = 0;
    $t = 6;
    $pr = 'alskdjflaksjdf';
    while ($w = _fetch_array($r)) {
        $n++;
        if ($pr != $w['ProdiID'] . $w['ProgramID']) {
            $pr = $w['ProdiID'] . $w['ProgramID'];
            $p->Ln(1);
            $p->SetFont('Helvetica', 'B', 11);
            $p->Cell(190, 8, "Program Studi: {$w['_PRD']} ~ {$w['_PRG']}", 0, 1);
            BuatHeaderTabel($p);
        }
        $p->SetFont('Helvetica', '', 10);
        $p->Cell(16, $t, $n, 'LB', 0, 'R');
        $p->Cell(24, $t, $w['PMBID'], 'B', 0);
        $p->Cell(60, $t, $w['Nama'], 'B', 0);
        $p->Cell(70, $t, $w['AsalSekolah'], 'B', 0);
        $p->Cell(10, $t, $w['NilaiSekolah'], 'B', 0, 'R');
        $p->Cell(10, $t, $w['NilaiUjian'], 'BR', 0, 'R');
        $p->Ln($t);
    }
}

function CetakMKSetara($kurid, $p)
{
    $lbr = 190;
    $t = 6;
    $p->SetFont('Helvetica', 'B', 11);
    $p->Cell(10, $t, 'No.', 1, 0, 'R');
    $p->Cell(30, $t, 'MKKode', 1, 0, 'L');
    $p->Cell(100, $t, 'Nama Mata Kuliah', 1, 0, 'L');
    $p->Cell(10, $t, 'SKS', 1, 0, 'C');
    $p->Cell(10, $t, 'Sesi', 1, 0, 'C');
    $p->Cell(30, $t, 'MK Setara', 1, 0, 'C');
    $p->Ln($t);
    // tuliskan
    $s = "select MKKode, Nama, SKS, Sesi, MKSetara\r\n    from mk\r\n    where KurikulumID='{$kurid}' and NA='N'\r\n    order by Sesi, MKKode";
    $r = _query($s);
    $n = 0;
    while ($w = _fetch_array($r)) {
        $n++;
        $p->SetFont('Helvetica', 'B', 11);
        $p->Cell(10, $t, $n, 1, 0, 'R');
        $p->Cell(30, $t, $w['MKKode'], 1, 0, 'L');
        $p->Cell(100, $t, $w['Nama'], 1, 0, 'L');
        $p->Cell(10, $t, $w['SKS'], 1, 0, 'C');
        $p->Cell(10, $t, $w['Sesi'], 1, 0, 'C');
        $p->Cell(30, $t, $w['MKSetara'], 1, 0, 'C');
        $p->Ln($t);
    }
}

function BuatIsinya($jdwl, $p)
{
    $sudahbayar = "and (h.Biaya - h.Bayar + h.Tarik - h.Potongan) <= 0";
    $sudahpenuhiabsen = "and (select count(pm.PresensiMhswID) from presensimhsw pm left outer join jenispresensi jp on pm.JenisPresensiID=jp.JenisPresensiID where pm.KRSID=k.KRSID and jp.Nilai = 0) < {$jdwl['MaxAbsen']}";
    $s = "select k.MhswID, m.Nama, k._Presensi, k.KRSID\r\n    from krs k\r\n      left outer join mhsw m on m.MhswID = k.MhswID and m.KodeID = '" . KodeID . "'\r\n      left outer join khs h on k.KHSID = h.KHSID\r\n    where k.JadwalID = '{$jdwl['JadwalID']}'\r\n      {$sudahbayar}\r\n\t  {$sudahpenuhiabsen}\r\n    order by k.MhswID";
    $r = _query($s);
    $t = 7;
    $n = 0;
    // Header
    $p->SetFont('Helvetica', 'B', 10);
    $p->Cell(25, $t, 'N I M', 'B', 0);
    $p->Cell(100, $t, 'Nama Mahasiswa', 'B', 0);
    $p->Cell(20, $t, 'No. Kursi', 'B', 0, 'R');
    $p->Cell(20, $t, 'TTD', 'B', 0, 'C');
    $p->Ln($t);
    // Data
    $p->SetFont('Helvetica', '', 9);
    while ($w = _fetch_array($r)) {
        $n++;
        $p->SetFont('Helvetica', '', 9);
        $p->Cell(25, $t, $w['MhswID'], 0, 0);
        $p->Cell(100, $t, $w['Nama'], 0, 0);
        $p->SetFont('Helvetica', 'B', 9);
        $p->Cell(20, $t, $n, 0, 0, 'C');
        $p->Cell(20, $t, '', 'B', 0, 'C');
        $p->Ln($t);
    }
    $p->SetFont('Helvetica', '', 9);
    $p->Cell(165, 2, ' ', 'B', 1);
    $p->Cell(165, $t, 'Jumlah Peserta Ujian : ' . $n, 0, 1);
    $p->Cell(165, $t, 'Catatan: Mahasiswa yang tidak tercetak di daftar berarti belum melunasi kewajibannya.', 0, 1);
}

function DelWawancara()
{
    $id = $_REQUEST['id'];
    $s = "delete from wawancarausm where WawancaraUSMID = '{$id}' ";
    $r = _query($s);
    echo "<script>window.location='index.php?mnux={$_SESSION['mnux']}&gos=wawancarausm'</script>";
}

function CetakMatakuliahnya($MKPaketID, $p)
{
    $whr_pid = empty($MKPaketID) ? "" : "and mp.MKPaketID='{$MKPaketID}'";
    $s = "select mk.Sesi, mk.MKKode, mk.Nama, mk.Responsi, mk.PraktekKerja, mk.TugasAkhir, mk.SKS\r\n    from mkpaketisi mp left outer join mk mk on mp.MKID=mk.MKID\r\n    where mk.KodeID='" . KodeID . "'\r\n\t\t{$whr_pid}\r\n\torder by mk.Sesi, mk.Nama";
    $r = _query($s);
    $n = 0;
    $t = 6;
    $_sesi = '02q350mq3';
    BuatHeaderTabel($p);
    while ($w = _fetch_array($r)) {
        /*if ($_sesi != $w['Sesi']) { 
            $_sesi = $w['Sesi'];
            $p->SetFont('Helvetica', 'B', 10);
            $p->Ln(2);
            $p->Cell(170, $t+2, $w['Sesi'], 1, 1);
            BuatHeaderTabel($p);
          }*/
        $n++;
        $p->SetFont('Helvetica', '', 10);
        $p->Cell(10, $t, $n . '.', 1, 0, 'R');
        $p->Cell(30, $t, $w['MKKode'], 1, 0);
        $p->Cell(100, $t, $w['Nama'], 1, 0);
        $p->Cell(10, $t, $w['SKS'], 1, 0, 'C');
        $p->Cell(1, $t, '', 1, 0, '', true);
        $p->Cell(10, $t, $w['Sesi'], 1, 0, 'C');
        $p->Cell(1, $t, '', 1, 0, '', true);
        $p->Cell(10, $t, $w['Responsi'] == 'Y' ? 'Lab' : '', 1, 0, 'C');
        $p->Cell(10, $t, $w['PraktekKerja'] == 'Y' ? 'KP' : '', 1, 0, 'C');
        $p->Cell(10, $t, $w['TugasAkhir'] == 'Y' ? 'TA' : '', 1, 0, 'C');
        $p->Ln($t);
    }
}