Untitled

<?php
// cek akses halaman
defined('__VALID_ENTRANCE') or die('Akses terbatas');
$conn->debug = false; //clean debug
ob_clean(); //clean debug
// hak akses
Auth::getFileAuth();

// include  
require_once(Route::getModelPath('laporanmhs'));
require_once(Route::getModelPath('jenismk'));
require_once(Route::getModelPath('universitas'));
require_once(Route::getModelPath('unit'));
require_once(Route::getModelPath('predikat'));
require_once(Route::getModelPath('pegawai'));
require_once(Route::getModelPath('mahasiswa'));
require_once(Route::getModelPath('jenista'));
require_once(Route::getModelPath('skalanilai'));
require_once($conf['app_includes'] . 'fpdf2/tcetak2.php');

// parameter halaman
$p_title = 'Transkrip';
$p_tbwidth = 900;
$p_namafile = 'transkrip';

// variabel request
$r_unit = Page::SetRequest($_REQUEST['idunit']);
$r_angkatan = Page::SetRequest($_REQUEST['angkatan']);
$a_jenista = mJenisTA::jenisTA($conn);
$rektor = mUnit::getRektor($conn);

if (Akademik::isMhs())
    $r_npm = Auth::getUserName();
else
    $r_npm = Page::SetRequest($_REQUEST['nim']);

/* jika mahasiswa peserta didik baru ambil dari perwalian dan urut sesuai periode jika mahasiswa transfer maka transkrip akan ditampilkan sesuai kurikulum*/
if (!empty($dt_mhs['istransfer']))
    $order_by = 'semmk asc, k.idmk asc';
else
    $order_by = 'idperiode asc, k.idmk asc';

$order_by = "case when idjenismk = 'S' then 1 else 0 end asc, " . $order_by;

$a_data = mLaporanMhs::getTranskripNew($conn, $r_unit, $r_angkatan, $r_npm, $order_by);
$akreditasi = mUnit::getAkreditasi();
$data_prodi = mUnit::getData($conn, $row['idunit']);
$namafile = $a_data[0]['nim'];
if (!empty($a_data)) {
    // header('Pragma: public');
    // header("Content-Type: application/pdf");
    // header('Content-Transfer-Encoding: binary');
    // header('Last-Modified: ' . gmdate('D, d M Y H:i:s', filemtime($namafile)) . ' GMT');
    // header('Expires: 0');
    // header('Cache-Control: must-revalidate');
}

$a_univ = mUnit::getDataUniversitas($conn);
$akreditasi = mUnit::getAkreditasi();
$a_predikat = mPredikat::getList($conn);
$data_prodi = mUnit::getData($conn, $row['idunit']);


//Info
$idFont = 'times';
$font_size = 7;
$font_size_en = 6.9;

$tabX = 5;
$borderbio = 0;
$space = 3;

// legal size
$page_width = 330;
$page_height = 210;
$t = new tcetak2("L", "mm", [$page_height, $page_width]);
$t->SetMargins(0, 30, 0);
$t->SetAutoPageBreak(false, 1);

foreach ($a_data as $row) {

    $t->AddPage();
    $t->Bookmark($row['nim']);

    $t->SetY(22.23);
    $rowString = array(
        array($idFont, 'B', 8, 'TRANSKRIP AKADEMIK / ', $space + 1, $borderbio, $idColor),
        array($enFont, 'BI', 8, 'ACADEMIC TRANSCRIPT', $space + 1, $borderbio, $idColor)
    );

    $t->customFontMid($rowString, $page_width, 0, 'C');
    $t->Line(144, 25.5, 213, 25.5);

    $t->SetX(148);
    $t->SetFont($idFont, '', $font_size_isi);
    $t->Cell($page_width, 2, 'No. ' . $row['noskyudisium'], 0, 0, 'L');
    $t->Ln(6);

    $colbio = array(35, 2, 70);

    $lahir = strtolower($row['tmplahir'] . ', ' . cstr::formatDateInd($row['tgllahir']));

    $arrayBio = array(
        array("Nama", "Name", $row['nama'], "", "Fakultas", "Faculty", $row['namafakultas'], $row['namafakultasen'], "Program Studi", "Study Programe", $row['jurusan'], $row['jurusanen']),
        array("Tempat/ Tgl. Lahir", "Place/ Date of Birth", $lahir, "", "Status Akreditasi", "Accreditation Status", $data_prodi['akreditasi'], "", "Jenjang Studi", "Study Level", $row['idjenjang'], ""),
        array("NPM", "Student Registration Number", $row['nim'], "", "Nomor Seri Ijazah", "Certificate Serial Number", $row['noijasah'], ""),
    );

    $border = "";
    foreach ($arrayBio as $key => $bio) {
        $t->SetX($tabX);
        $t->SetFont($idFont, '', $font_size);
        $t->Cell($colbio[0], $space, $bio[0], $border, 0, 'L');
        $t->Cell($colbio[1], $space, ':', $border, 0, 'L');
        if ($key == 0)
            $t->SetFont($idFont, 'B', $font_size);
        $t->Cell($colbio[2], $space, $bio[2], $border, 0, 'L');
        $t->SetFont($idFont, '', $font_size);
        $t->Cell($colbio[0], $space, $bio[4], $border, 0, 'L');
        $t->Cell($colbio[1], $space, ':', $border, 0, 'L');
        $t->Cell($colbio[2], $space, $bio[6], $border, 0, 'L');
        $t->Cell($colbio[0], $space, $bio[8], $border, 0, 'L');
        if ($bio[8])
            $t->Cell($colbio[1], $space, ':', $border, 0, 'L');
        $t->Cell($colbio[2], $space, $bio[10], $border, 1, 'L');

        $t->SetX($tabX);
        $t->SetFont($idFont, 'I', $font_size_en);
        $t->Cell($colbio[0], $space, $bio[1], $border, 0, 'L');
        $t->Cell($colbio[1], $space, '', $border, 0, 'L');
        $t->Cell($colbio[2], $space, $bio[3], $border, 0, 'L');
        $t->Cell($colbio[0], $space, $bio[5], $border, 0, 'L');
        $t->Cell($colbio[1], $space, '', $border, 0, 'L');
        $t->Cell($colbio[2], $space, $bio[7], $border, 0, 'L');
        $t->Cell($colbio[0], $space, $bio[9], $border, 0, 'L');
        $t->Cell($colbio[1], $space, '', $border, 0, 'L');
        $t->Cell($colbio[2], $space, $bio[11], $border, 1, 'L');
    }


    $tot_sks = 0;
    $tot_nm = 0;

    $border_isi = 'TLBR';
    $font_isi = 'times';
    $space_isi = 3.5;
    $space_isi2 = 7;
    $space_head = 3.5;
    $font_size_isi = 7;
    $blokY = $t->GetY() + 2;
    $no = 1;
    $header_col_size = array(50, 6, 8, 6.5, 6.5, 12);

    $data = mappingData($t, $row['transkrip']);


    $t->SetFont($font_isi, '', $font_size_isi);

    $tempWidth = 20;
    for ($i = 0; $i < 30; $i++) {
        $widthid = $t->GetStringWidth($data[$i][1]);

        if ($widthid > $tempWidth) {
            $tempWidth = $widthid;
        }
    }

    $tempWidth += 1.5;
    //Tabel 1
    $kond = true;
    if ($data[0][1] == Null) {
        $kond = false;
    }

    if ($kond == true) {
        $t->SetY($blokY);
        $t->SetX($tabX);
        $t->SetFont($font_isi, 'B', $font_size_isi);

        $t->Cell(5, $space_isi + 3.5, 'No.', 'LRT', 0, 'C');
        $t->Cell($header_col_size[5], $space_head, 'KODE', 'LRT', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'MATA KULIAH', 'LRT', 0, 'C');
        $t->Cell($header_col_size[1], $space_head, 'Sks', 'TLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Nilai', 'TLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'BN', 'LRT', 1, 'C');
        $t->SetX($tabX);

        $t->Cell(5, $space_isi, '', 'LR', 0, 'C');

        $t->Cell($header_col_size[5], $space_head, 'MK/CS', 'BLR', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'SUBJECT', 'BLR', 0, 'C');
        $t->SetFont($font_isi, 'BI', $font_size_isi);
        $t->Cell($header_col_size[1], $space_head, 'Crd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Grd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'Wg.', 'BLR', 1, 'C');

        $t->SetFont($font_isi, '', $font_size_isi);


        for ($i = 0; $i < 30; $i++) {
            $t->SetX($tabX);
            $t->SetFont($font_isi, '', $font_size_isi);

            if ($data[$i][0] != '') {
                $t->SetFont($font_isi, '', $font_size_isi);
                $t->Cell(5, $space_isi2, $no, 1, 0, 'C');
                $t->Cell($header_col_size[5], $space_isi2, str_replace("X", "", $data[$i][0]), 1, 0, 'C');
                $t->Cell($tempWidth, $space_isi, $data[$i][1], 'LR', 0, 'L');
                $t->Cell($header_col_size[1], $space_isi2, $data[$i][3], 'LBR', 0, 'C');
                $t->Cell($header_col_size[3], $space_isi2, $data[$i][5], 'LBR', 0, 'C');
                $t->Cell($header_col_size[4], $space_isi2, ($data[$i][3] * $data[$i][4]) ? $data[$i][3] * $data[$i][4] : '', 'LBR' . $borderin, 1, 'C');
                $no++;
            } else {
                $t->SetFont($font_isi, 'I', $font_size_en);
                $t->Cell(5, 0, '', 1, 0, 'C');
                $t->Cell($header_col_size[5], 0, '', 1, 0, 'C');
                $t->Cell($tempWidth, -3.5, $data[$i][1], 'LTR' . $borderin, 0, 'L');
                $t->Cell($header_col_size[1], 0, '', 'LBR' . $borderin, 0, 'C');
                $t->Cell($header_col_size[3], 0, '', 'LBR' . $borderin, 0, 'C');
                $t->Cell($header_col_size[4], 0, '', 'LBR' . $borderin, 1, 'C');
            }

            $tot_sks += $data[$i][3];
            $tot_nm += $data[$i][3] * $data[$i][4];
        }
    }



    $tabXright = $tabX + 5 + $header_col_size[5] + $tempWidth + $header_col_size[1] + $header_col_size[3] + $header_col_size[4];

    $t->SetFont($font_isi, '', $font_size_isi);
    $tempWidth = 20;
    for ($i = 30; $i < 60; $i++) {
        $widthid = $t->GetStringWidth($data[$i][1]);
        if ($widthid > $tempWidth) {
            $tempWidth = $widthid;
        }
    }
    $tempWidth += 1.5;


    //Tabel 2
    $kond = true;
    if ($data[30][1] == Null) {
        $kond = false;
    }

    if ($kond == true) {
        $t->SetY($blokY);

        $t->SetX($tabXright);

        $t->SetFont($font_isi, 'B', $font_size_isi);
        $t->Cell(5, $space_isi + 3.5, 'No.', 'LRT', 0, 'C');
        $t->Cell($header_col_size[5], $space_head, 'KODE', 'LRT', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'MATA KULIAH', 'LRT', 0, 'C');
        $t->Cell($header_col_size[1], $space_head, 'Sks', 'TLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Nilai', 'TLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'BN', 'LRT', 1, 'C');

        $t->SetX($tabXright);
        $t->Cell(5, $space_isi, '', 'LR', 0, 'C');

        $t->Cell($header_col_size[5], $space_head, 'MK/CS', 'BLR', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'SUBJECT', 'BLR', 0, 'C');
        $t->SetFont($font_isi, 'BI', $font_size_isi);
        $t->Cell($header_col_size[1], $space_head, 'Crd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Grd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'Wg.', 'BLR', 1, 'C');


        $t->SetFont($font_isi, '', $font_size_isi);
        for ($i = 30; $i < 60; $i++) {
            $t->SetX($tabXright);
            if ($data[$i][0] != '') {
                $t->SetFont($font_isi, '', $font_size_isi);
                $t->Cell(5, $space_isi2, $no, 1, 0, 'C');
                $t->Cell($header_col_size[5], $space_isi2, str_replace("X", "", $data[$i][0]), 1, 0, 'C');
                $t->Cell($tempWidth, $space_isi, $data[$i][1], 'LR', 0, 'L');
                $t->Cell($header_col_size[1], $space_isi2, $data[$i][3], 'LBR', 0, 'C');
                $t->Cell($header_col_size[3], $space_isi2, $data[$i][5], 'LBR', 0, 'C');
                $t->Cell($header_col_size[4], $space_isi2, ($data[$i][3] * $data[$i][4]) ? $data[$i][3] * $data[$i][4] : '', 'LBR' . $borderin, 1, 'C');
                $no++;
            } else {
                $t->SetFont($font_isi, 'I', $font_size_en);
                $t->Cell(5, 0, '', 1, 0, 'C');
                $t->Cell($header_col_size[5], 0, '', 1, 0, 'C');
                $t->Cell($tempWidth, -3.5, $data[$i][1], 'LTR' . $borderin, 0, 'L');
                $t->Cell($header_col_size[1], 0, '', 'LBR' . $borderin, 0, 'C');
                $t->Cell($header_col_size[3], 0, '', 'LBR' . $borderin, 0, 'C');
                $t->Cell($header_col_size[4], 0, '', 'LBR' . $borderin, 1, 'C');
            }

            $tot_sks += $data[$i][3];
            $tot_nm += $data[$i][3] * $data[$i][4];
        }
    }


    $tabXright = $tabXright + 5 + $header_col_size[5] + $tempWidth + $header_col_size[1] + $header_col_size[3] + $header_col_size[4];

    $t->SetFont($font_isi, '', $font_size_isi);
    $tempWidth = 20;
    for ($i = 60; $i < 90; $i++) {
        $widthid = $t->GetStringWidth($data[$i][1]);
        if ($widthid > $tempWidth) {
            $tempWidth = $widthid;
        }
    }
    $tempWidth += 1.5;


    //Tabel 3
    $kond = true;
    if ($data[60][1] == Null) {
        $kond = false;
    }

    if ($kond == true) {

        $t->SetY($blokY);
        $t->SetX($tabXright);

        $t->SetFont($font_isi, 'B', $font_size_isi);
        $t->Cell(5, $space_isi + 3.5, 'No.', 'LRT', 0, 'C');
        $t->Cell($header_col_size[5], $space_head, 'KODE', 'LRT', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'MATA KULIAH', 'LRT', 0, 'C');
        $t->Cell($header_col_size[1], $space_head, 'Sks', 'TLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Nilai', 'TLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'BN', 'LRT', 1, 'C');

        $t->SetX($tabXright);

        $t->Cell(5, $space_isi, '', 'LR', 0, 'C');

        $t->Cell($header_col_size[5], $space_head, 'MK/CS', 'BLR', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'SUBJECT', 'BLR', 0, 'C');
        $t->SetFont($font_isi, 'BI', $font_size_isi);
        $t->Cell($header_col_size[1], $space_head, 'Crd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[3], $space_head, 'Grd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[4], $space_head, 'Wg.', 'BLR', 1, 'C');

        $t->SetFont($font_isi, '', $font_size_isi);

        for ($i = 60; $i < 90; $i++) {
            $t->SetX($tabXright);
            if ($data[$i][0] != '') {
                $t->SetFont($font_isi, '', $font_size_isi);
                $t->Cell(5, $space_isi2, $no, 1, 0, 'C');
                $t->Cell($header_col_size[5], $space_isi2, str_replace("X", "", $data[$i][0]), 1, 0, 'C');
                $t->Cell($tempWidth, $space_isi, $data[$i][1], 'LR', 0, 'L');
                $t->Cell($header_col_size[1], $space_isi2, $data[$i][3], 'LBR', 0, 'C');
                $t->Cell($header_col_size[3], $space_isi2, $data[$i][5], 'LBR', 0, 'C');
                $t->Cell($header_col_size[4], $space_isi2, ($data[$i][3] * $data[$i][4]) ? $data[$i][3] * $data[$i][4] : '', 'LBR' . $borderin, 1, 'C');
                $no++;
            } else {
                $t->SetFont($font_isi, 'I', $font_size_en);
                $t->Cell(5, 0, '', 1, 0, 'C');
                $t->Cell($header_col_size[5], 0, '', 1, 0, 'C');
                $t->Cell($tempWidth, -3.5, $data[$i][1], 'LTR' . $borderin, 0, 'L');
                $t->Cell($header_col_size[1], 0, '', 'LBR', 0, 'C');
                $t->Cell($header_col_size[3], 0, '', 'LBR', 0, 'C');
                $t->Cell($header_col_size[4], 0, '', 'LBR', 1, 'C');
            }

            $tot_sks += $data[$i][3];
            $tot_nm += $data[$i][3] * $data[$i][4];
        }
    }


    $tabXright = $tabXright + 5 + $header_col_size[5] + $tempWidth + $header_col_size[1] + $header_col_size[3] + $header_col_size[4];

    $t->SetFont($font_isi, '', $font_size_isi);
    $tempWidth = 20;
    for ($i = 90; $i < 120; $i++) {
        $widthid = $t->GetStringWidth($data[$i][1]);
        if ($widthid > $tempWidth) {
            $tempWidth = $widthid;
        }
    }
    $tempWidth += 1.5;

    //Tabel 4
    $kond = true;
    if ($data[90][1] == Null) {
        $kond = false;
    }

    if ($kond == true) {
        $t->SetY($blokY);
        $t->SetX($tabXright);
        $t->SetFont($font_isi, 'B', $font_size_isi);

        $t->Cell(5, $space_isi + 3.5, 'No.', 'LRT', 0, 'C');
        $t->Cell($header_col_size[5], $space_head, 'KODE', 'LRT', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'MATA KULIAH', 'LRT', 0, 'C');
        $t->Cell($header_col_size[1] + 1, $space_head, 'Sks', 'TLR', 0, 'C');
        $t->Cell($header_col_size[3] + 1, $space_head, 'Nilai', 'TLR', 0, 'C');
        $t->Cell($header_col_size[4] + 1, $space_head, 'BN', 'LRT', 1, 'C');
        $t->SetX($tabXright);




        $t->Cell(5, $space_isi, '', 'LR', 0, 'C');

        $t->Cell($header_col_size[5], $space_head, 'MK/CS', 'BLR', 0, 'C');
        $t->Cell($tempWidth, $space_head, 'SUBJECT', 'BLR', 0, 'C');
        $t->SetFont($font_isi, 'BI', $font_size_isi);
        $t->Cell($header_col_size[1] + 1, $space_head, 'Crd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[3] + 1, $space_head, 'Grd', 'BLR', 0, 'C');
        $t->Cell($header_col_size[4] + 1, $space_head, 'Wg.', 'BLR', 1, 'C');;

        $t->SetFont($font_isi, '', $font_size_isi);


        for ($i = 90; $i < 120; $i++) {
            $t->SetX($tabXright);
            if ($data[$i][0] != '') {
                $t->SetFont($font_isi, '', $font_size_isi);
                $t->Cell(5, $space_isi2, $no, 1, 0, 'C');
                $t->Cell($header_col_size[5], $space_isi2, str_replace("X", "", $data[$i][0]), 1, 0, 'C');
                $t->Cell($tempWidth, $space_isi, $data[$i][1], 'LR', 0, 'L');
                $t->Cell($header_col_size[1] + 1, $space_isi2, $data[$i][3], 'LR', 0, 'C');
                $t->Cell($header_col_size[3] + 1, $space_isi2, $data[$i][5], 'LR', 0, 'C');
                $t->Cell($header_col_size[4] + 1, $space_isi2, ($data[$i][3] * $data[$i][4]) ? $data[$i][3] * $data[$i][4] : '', 'LBR' . $borderin, 1, 'C');
                $no++;
            } else {
                $t->SetFont($font_isi, 'I', $font_size_en);
                $t->Cell(5, 0, '', 1, 0, 'C');
                $t->Cell($header_col_size[5], 0, '', 1, 0, 'C');
                $t->Cell($tempWidth, -3.5, $data[$i][1], 'LTR' . $borderin, 0, 'L');
                $t->Cell($header_col_size[1] + 1, 0, '', 'LBR', 0, 'C');
                $t->Cell($header_col_size[3] + 1, 0, '', 'LBR', 0, 'C');
                $t->Cell($header_col_size[4] + 1, 0, '', 'LBR', 1, 'C');
            }

            $tot_sks += $data[$i][3];
            $tot_nm += $data[$i][3] * $data[$i][4];
        }
    }


    $t->SetFont('times', '', 7);
    $space_isi = 3.5;

    $t->SetX($tabXright);
    $t->WriteHtmlCell(5 + $header_col_size[5] + $tempWidth, "Jumlah / Total", 4, 0);
    $t->SetX($tabXright + 5 + $header_col_size[5] + $tempWidth);
    $t->Cell($header_col_size[1] + 1, $space_isi, $tot_sks, 'BLR', 0, 'L');
    $t->Cell($header_col_size[3] + 1, $space_isi, '', 'BLR', 0, 'C');
    $t->Cell($header_col_size[4] + 1, $space_isi, number_format($tot_nm, 0), 'BLR', 1, 'C');

    $t->SetX($tabXright);
    $t->WriteHtmlCell(5 + $header_col_size[5] + $tempWidth, "IPK / GPA", 4, 0);
    $t->SetX($tabXright + 5 + $header_col_size[5] + $tempWidth);
    $t->Cell($header_col_size[1] + $header_col_size[3] + $header_col_size[4] + 3, $space_isi, number_format(($tot_nm / $tot_sks), 2), 'BLR', 1, 'C');

    $baba = mMahasiswa::getData($conn, $row['nim']);

    $append_info = [
        ['label' => 'Predikat Kelulusan', 'value' => mPredikat::getPredikatMhs($conn, $row['nim'])['namapredikat'], 'language' => 'id'],
        ['label' => 'Graduation Predicate', 'value' => mPredikat::getPredikatMhs($conn, $row['nim'])['namapredikaten'], 'language' => 'en'],
        ['label' => 'Tanggal Lulus', 'value' => Date::indoDate($row['tglskyudisium']), 'language' => 'id'],
        ['label' => 'Graduation Period', 'value' => date('F d, Y', strtotime($row['tglskyudisium'])), 'language' => 'en'],
        ['label' => 'Lama Studi', 'value' => '', 'langauge' => 'id'],
        ['label' => 'Study Period', 'value' => '', 'langauge' => 'en']
    ];

    foreach ($append_info as $info) {
        $t->SetX($tabXright);
        $t->SetFont($idFont, ($info['language'] == 'en' ? 'I' : ''), 7);
        $t->Cell(5 + $header_col_size[5] + $tempWidth, $space_isi, $info['label'], 'TBLR', 0, 'L');
        $t->Cell($header_col_size[1] + $header_col_size[3] + $header_col_size[4] + 3, $space_isi, $info['value'], 'BLR', 1, 'C');
    }

    //isian perlu dibuah menjadi data dinamis
    $t->ln(4);
    $t->SetX($tabXright + 1);
    $t->SetFont($idFont, '', 7);
    $t->WriteHtmlCell(5 + $header_col_size[5] + $tempWidth, 'Keterangan / Remark :', 4, 1);
    $t->ln(1);

    $a_keterangan = [
        'CS' => 'Subject Code / Kode MK',
        'Crd' => 'Credit / Kredit',
        'Grd' => 'Grade / Nilai (A, B+, B, C+, C, D+, D)',
        'Wg' => 'Weight / Bobot (4, 3.5, 3, 2.5, 2, 1.5, 1)',
        'GPA' => 'Grade Point Average /  Indek Prestasi Akademik',
    ];

    foreach ($a_keterangan as $key => $val) {
        $t->SetX($tabXright + 1);
        $t->SetFont($idFont, '', 7);
        $t->Cell($header_col_size[5], $space_isi, $key, '', 0, 'L');
        $t->Cell(5, $space_isi, ':', '', 0, 'L');
        $t->Cell($header_col_size[5] + $tempWidth, $space_isi, $val, '', 1, 'L');
    }

    $t->SetY(170);
    $border_ttd = 0;
    $ttdX = 15;
    $space_ttd = 4;
    $font_size_isi = 8;
    $t->SetFont($idFont, '', $idFont_size);
    $colttdsize = 62;

    $t->SetX(190);
    //isian perlu dibuah menjadi data dinamis
    $t->Cell($colttdsize, $space_ttd + 2, Auth::getSettingSIM('university_city') . ', ' . Date::indoDate($row['tglskyudisium']), 0, 1, 'C');
    $t->Cell($colttdsize, $space_ttd + 2, Auth::getSettingSIM('university_city') . ', ' . date("Y-m-d", strtotime($row['tglskyudisium'])), 0, 1, 'C');
    
    $t->SetX(130);
    //isian perlu dibuah menjadi data dinamis
    $t->Cell($colttdsize, $space_ttd, 'Rektor /' . ' Rector', 0, 1, 'C');
    $t->SetX(130);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(130);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(130);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(130);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(130);
    $t->SetFont($idFont, 'B', $idFont_size);
    //perlu diubah
    $t->Cell($colttdsize, $space_ttd, $row['namaketua'], 0, 1, 'C');
    $t->SetX(130);
    $t->SetFont($idFont, '', $idFont_size);
    //perlu diubah
    $t->Cell($colttdsize, $space_ttd, 'NIDN / OFFICIAL NO. ' . $row['nidnketua'], 0, 1, 'C');

    $t->SetX(190);
    //isian perlu dibuah menjadi data dinamis
    $t->Cell($colttdsize, $space_ttd, 'Dekan / Dean', 0, 1, 'C');
    $t->SetX(190);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(190);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(190);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(190);
    $t->Cell($colttdsize, $space_ttd, '', 0, 1, 'C');
    $t->SetX(190);
    $t->SetFont($idFont, 'B', $idFont_size);
    //perlu diubah
    $t->Cell($colttdsize, $space_ttd, $row['namadekan'], 0, 1, 'C');
    $t->SetX(190);
    $t->SetFont($idFont, '', $idFont_size);
    //perlu diubah
    $t->Cell($colttdsize, $space_ttd, 'NIDN / OFFICIAL NO. ' . $row['nidndekan'], 0, 1, 'C');
    $t->Ln(0);
    $br++;
    $t->Image(Route::getImageURL('fotomhs', $row['nim'], 'nopic.png', null, true, true), 150, 170, 27, 35);
}

$t->Output($namafile . '.pdf', 'I');


function mappingData($t, $arrayData)
{
    $data = [];

    foreach ($arrayData as $rowkey) {
        $data[] = array($rowkey['idmk'], strtolower($rowkey['namamk']), $rowkey['semmk'], $rowkey['sksmk'], $rowkey['nangka'], $rowkey['nhuruf']);
        $data[] = array('', strtolower($rowkey['namamk']), '', '', '', '');
    }

    return $data;
}