<?php
include('../../koneksi.php');

$penilai_evaluasi_id=$_POST['id'];
 
$kpl=pg_query("SELECT p.nama,j.nama,s.nama,a.nama,k.nama_pelatihan,
    e.riwayat_evaluasi_id,p.nipb
    FROM penilai_evaluasi e
    INNER JOIN riwayat_evaluasi w ON (w.id=e.riwayat_evaluasi_id)
    INNER JOIN riwayat_kegiatan k ON (k.id=w.riwayat_kegiatan_id)
    INNER JOIN jenis_pelatihan a ON (a.id=k.jenis_pelatihan_id)
    INNER JOIN riwayat_peserta t ON (t.id=w.riwayat_peserta_id)
    INNER JOIN data_pegawai p ON (p.id=t.data_pegawai_id)
    INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
    INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
    WHERE e.id='$penilai_evaluasi_id'
");
while($rkpl=pg_fetch_array($kpl)) {
  $ev_nama_peserta=$rkpl[0];
  $ev_jabatan_peserta=$rkpl[1];
  $ev_satker_peserta=$rkpl[2];
  $ev_kegiatan=$rkpl[3].' - '.$rkpl[4];
}

$pen=pg_query("SELECT p.nama,p.nipb,s.nama,j.nama,e.id 
FROM penilai_evaluasi e
INNER JOIN data_pegawai p ON (p.id=e.penilai)
INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja)
INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
WHERE e.id='$penilai_evaluasi_id'
");
while($rpen=pg_fetch_array($pen)) {

$ev_nama_penilai=$rpen[0];
$ev_nip_penilai=$rpen[1];
$ev_satker_penilai=$rpen[2];
$ev_jabatan_penilai=$rpen[3];
$id=$rpen[4];
}

$template_file_name = 'blangko.docx';

$rand_no = rand(111111, 999999);
$fileName = "BLANGKO_".$ev_nama_penilai.".docx";
 
$folder   = $id;
$full_path = $folder . '/' . $fileName;
 
try
{
    if (!file_exists($folder))
    {
        mkdir($folder);
    }       
         
    //Copy the Template file to the Result Directory
    copy($template_file_name, $full_path);
 
    // add calss Zip Archive
    $zip_val = new ZipArchive;
 
    //Docx file is nothing but a zip file. Open this Zip File
    if($zip_val->open($full_path) == true)
    {
        // In the Open XML Wordprocessing format content is stored.
        // In the document.xml file located in the word directory.
         
        $key_file_name = 'word/document.xml';
        $message = $zip_val->getFromName($key_file_name);                
        $timestamp = date('d-M-Y H:i:s');

        $message = str_replace("ev_nama_penilai", $ev_nama_penilai, $message);
        $message = str_replace("ev_jabatan_penilai", $ev_jabatan_penilai, $message);
        $message = str_replace("ev_satker_penilai", $ev_satker_penilai, $message);
        $message = str_replace("ev_nip_penilai", $ev_nip_penilai, $message);

        $message = str_replace("ev_nama_peserta", $ev_nama_peserta, $message);
        $message = str_replace("ev_jabatan_peserta", $ev_jabatan_peserta, $message);
        $message = str_replace("ev_satker_peserta", $ev_satker_peserta, $message);
        $message = str_replace("ev_kegiatan", $ev_kegiatan, $message);

        $zip_val->addFromString($key_file_name, $message);
        $zip_val->close();
        
    }
}
catch (Exception $exc) 
{
    $error_message =  "Error creating the Word Document";
    var_dump($exc);
}

echo $fileName;



?>