Untitled

<?php

$json_dataT = file_get_contents('C:/xampp/htdocs/sevima/json/dataSKPI.json');
$data_skpi = json_decode($json_dataT, true);

$json_dataA = file_get_contents('C:/xampp/htdocs/sevima/json/aktivitasmahasiswa.json');
$data_aktivitas = json_decode($json_dataA, true);


require_once 'C:/xampp/htdocs/sevima/vendor/autoload.php';
require_once('C:/xampp/htdocs/sevima/phpword/TemplateProcessorMod.php');

use PhpOffice\PhpWord\TemplateProcessor;

ob_clean();

$document = 'C:/xampp/htdocs/sevima/unizar/unizar_230803.docx';


if (!empty($data_skpi)) {

    $templateProcessor = new \PhpOffice\PhpWord\TemplateProcessorMod($document);

    $var = $templateProcessor->getVariables();



    //here

    // Define Parent Aktivitas Kelompokf
    $arrKompetisi = [45, 49];
    $arrSeminar = [37, 39, 117];
    $arrOrganisasi = [18, 29, 128, 108];
    $arrMagang = [112];
    $arrSertifikasi = [];
    $itt2 = 0;
    foreach ($data_aktivitas as $akt_key => $skpi_item) {
        if (in_array($skpi_item['parentkelompok'], $arrOrganisasi)) {
            $itt2++;
            $arr_kegiatan = [
                'noorganisasi' => $itt2, 'namaorganisasi' => ($skpi_item['nama'])
            ];

            $data_organisasi[] = $arr_kegiatan;
        }
        $itt2++;
    }

    $itt = 1;
    // var_dump(count($data_aktivitas));
    $templateProcessor->cloneBlockMod('loop_a', count($data_aktivitas), true, true);
    foreach ($data_aktivitas as $val) {
        $replace["namakegiatan#" . $itt] = $val['jenis'];
        // echo '<pre>';
        // var_dump($val['nama'] . $itt);
        $itt++;
    }
    // die();

    $templateProcessor->setValues($replace);

    // $templateProcessor->cloneBlockMod('BLOCKCODE', count($data_skpi), true, true);

    // foreach ($var as $k => $v) {
    //     $val[$v] = htmlspecialchars($val[$v]);
    //     $replace[$v . "#" . $itt] = $val['yudisium_no_sk'];
    // }

    // $replace["nomorskpi#" . $itt] = $val['yudisium_no_sk'];
    // $replace["nama#" . $itt] = $val['mhs_nama'];
    // $replace["tempatlahir#" . $itt] = $val['mhs_tmplahir'];
    // $replace["tanggallahir#" . $itt] = $val['mhs_tgllahir'];
    // $replace["tanggallahir_en#" . $itt] = tanggalen($val['mhs_tgllahir']);
    // $replace["nim#" . $itt] = $val['mhs_nim'];
    // $replace["tanggalmasuk#" . $itt] = '05 September 2016';
    // $replace["tanggalmasuk_en#" . $itt] = 'September 05, 2016';
    // $replace["tanggalkeluar#" . $itt] = '01/21/2023';
    // $replace["ijazah_number#" . $itt] = $val['yudisium_no_ijasah'];
    // $replace["deskgelar#" . $itt] = $val['unit_deskgelar'];
    // $replace["gelar#" . $itt] = $val['unit_gelar'];
    // $replace["deskgelaren#" . $itt] = $val['unit_deskgelaren'];

    // $replace["skpendirian#" . $itt] = '0378/O/1984';
    // $replace["university_name#" . $itt] = 'Universitas Islam Al-Azhar';
    // $replace["university_nameen#" . $itt] = 'Islamic University of Al-Azhar';
    // $replace["namafakultas#" . $itt] = $val['fakultas_nama'];
    // $replace["namafakultasen#" . $itt] = $val['jenjang_namaen'];
    // $replace["jenispendidikan#" . $itt] = $val['jenis_pendidikan'];
    // $replace["jenispendidikan_en#" . $itt] = $val['jenis_pendidikan_en'];
    // $replace["level_kkni#" . $itt] = $val['level_kkni'];

    // $replace["levelbahasapengantar#" . $itt] = $val['bhs_pengantar'];
    // $replace["sistempenilaian#" . $itt] = $val['sistem_penilaian'];
    // $replace["sistempenilaian_en#" . $itt] = $val['sistem_penilaian_en'];
    // $replace["jurusan#" . $itt] = $val['unit_nama'];
    // $replace["jurusanen#" . $itt] = $val['unit_namaen'];
    // $replace["lamastudi#" . $itt] = convertSemester('ind', $val['lama_studi']);
    // $replace["lamastudi_en#" . $itt] = convertSemester('en', $val['lama_studi']);
    // $replace["syarat_terima#" . $itt] = $val['syarat_terima'];
    // $replace["syarat_terima_en#" . $itt] = $val['syarat_terima_en'];
    // $replace["jenjanglanjut_nama#" . $itt] = $val['jenjanglanjut_nama'];
    // $replace["jenjanglanjut_nama_en#" . $itt] = $val['jenjanglanjut_namaen'];

    // $replace["university_city#" . $itt] = 'Mataram';
    // $replace["tglhariini#" . $itt] = date("Y-m-d");
    // $replace["tglhariini_en#" . $itt] = date("Y-m-d");
    // $replace["namapejabat2#" . $itt] = 'Rakyan';
    // $replace["labelpejabat2#" . $itt] = 'Dekan';
    // $replace["labelpejabat2_en#" . $itt] = 'Dean';
    // $replace["nippejabat2#" . $itt] = '0831126913';


    // $templateProcessor->setValues(array('mhs_nim' => $nim));
    // $templateProcessor->setValues(array('yudisium_no_sk' => $val['yudisium_no_sk']));

    //until here

    if (!empty($replace)) {
        $templateProcessor->setValues($replace);
    }
    $dir = "C:/xampp/htdocs/sevima/done_ijazah/";
    $name = 'skpi' . date('dmyhhis') . '.docx';

    $templateProcessor->saveAs($dir . $name);

    if (!empty($data_skpi)) {
        header("Content-Disposition: attachment; filename=" . $name);
        readfile($dir . $name);
        unlink($dir . $name);
    }
} else {
    $message = "Data Tidak Ditemukan / Mahiswa Belum di Yudisium";
    echo "<script type='text/javascript'>alert('$message');</script>";
}


function tanggalen($oldDate)
{
    $newDateTimestamp = strtotime($oldDate);
    $newDateTimestamp = strtotime("August 31, 2000", $newDateTimestamp);
    $newDateFormatted = date("F d, Y", $newDateTimestamp);

    return $newDateFormatted;
}

function convertSemester($lang, $tahun)
{
    $tahun = $tahun * 2;
    if ($lang == 'ind') {
        return  $tahun . ' Semester';
    } else {
        return  $tahun . ' Semesters';
    }
}