149 lines
5.6 KiB
PHP
149 lines
5.6 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
|
|
|
|
|
|
//echo "Hari ini adalah ". hari_ini();
|
|
|
|
$riwayat_peserta_id=$_POST['riwayat_peserta_id'];
|
|
|
|
$ket=pg_query("SELECT a1.id,a1.nama,a2.id,a2.tgl_nd,a2.no_nd,k.thn,k.nama_pelatihan,
|
|
k.tanggal_mulai,k.tanggal_selesai,k.waktu_mulai,k.waktu_selesai,k.tempat,
|
|
k.id,s.nama,p.nama,j.nama,a2.sebagai_id
|
|
FROM satuan_kerja a1
|
|
INNER JOIN riwayat_peserta a2 ON (a2.satuan_kerja_id=a1.id)
|
|
INNER JOIN riwayat_kegiatan k ON (a2.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN sebagai s ON (s.id=a2.sebagai_id)
|
|
INNER JOIN data_pegawai p ON (p.id=a2.data_pegawai_id)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id)
|
|
WHERE a2.id='$riwayat_peserta_id'
|
|
");
|
|
|
|
while($rket=pg_fetch_array($ket)) {
|
|
$id=$rket[2];
|
|
$satker_nd=str_replace("&","dan",$rket[1]);
|
|
$tgl_nd_1=$rket[3];
|
|
$no_nd_1=$rket[4];
|
|
$thn_nd_1=$rket[5];
|
|
$nama_pelatihan_nd_1=str_replace("&","dan",$rket[6]);
|
|
$tanggal_mulai=$rket[7];
|
|
$tanggal_selesai=$rket[8];
|
|
$waktu_mulai=$rket[9];
|
|
$waktu_selesai=$rket[10];
|
|
$tempat_nd_1=str_replace("&","dan",$rket[11]);
|
|
$sebagai=$rket[13];
|
|
$nama_nd=$rket[14];
|
|
$jabatan_nd=$rket[15];
|
|
$sebagai_id=$rket[16];
|
|
}
|
|
|
|
$kpl=pg_query("SELECT p.nama,p.nipb,k.pangkat
|
|
FROM data_kepala k
|
|
INNER JOIN data_pegawai p ON (p.id=k.data_pegawai_id) WHERE k.aktif='t'");
|
|
while($rkpl=pg_fetch_array($kpl)) {
|
|
$nm_kepala=$rkpl[0];
|
|
$pangkat=$rkpl[2];
|
|
$nip=$rkpl[1];
|
|
}
|
|
$thn=date('Y');
|
|
$array_hari = array(1=>"Senin","Selasa","Rabu","Kamis","Jumat", "Sabtu","Minggu");
|
|
$hari1 = $array_hari[date("N",strtotime($tanggal_mulai))];
|
|
$hari2 = $array_hari[date("N",strtotime($tanggal_selesai))];
|
|
|
|
$bulan = array(
|
|
'01' => 'Januari',
|
|
'02' => 'Februari',
|
|
'03' => 'Maret',
|
|
'04' => 'April',
|
|
'05' => 'Mei',
|
|
'06' => 'Juni',
|
|
'07' => 'Juli',
|
|
'08' => 'Agustus',
|
|
'09' => 'September',
|
|
'10' => 'Oktober',
|
|
'11' => 'November',
|
|
'12' => 'Desember',
|
|
);
|
|
$bulan[date('m')];
|
|
|
|
if (($sebagai_id=='2') || ($sebagai_id=='4')) {
|
|
$template_file_name = 'nd_permohonan_ns.docx';
|
|
$rand_no = rand(111111, 999999);
|
|
$fileName = "NOTA_DINAS_PERMOHONAN_MENTOR_".$nama_nd.'_'.$no_nd_1.".docx";
|
|
} else {
|
|
$template_file_name = 'nd_permohonan_pembuka.docx';
|
|
$rand_no = rand(111111, 999999);
|
|
$fileName = "NOTA_DINAS_PERMOHONAN_PEMBUKA_".$jabatan_nd.'_'.$no_nd_1.".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');
|
|
|
|
// this data Replace the placeholders with actual values
|
|
$message = str_replace("nama_nd", $nama_nd, $message);
|
|
$message = str_replace("jabatan_nd", $jabatan_nd, $message);
|
|
$message = str_replace("satker_nd", $satker_nd, $message);
|
|
$message = str_replace("tgl_nd_1", date('d',strtotime($tgl_nd_1)).' '.($bulan[date('m',strtotime($tgl_nd_1))]).' '.date('Y',strtotime($tgl_nd_1)), $message);
|
|
$message = str_replace("no_nd_1", $no_nd_1, $message);
|
|
$message = str_replace("thn_nd_1", $thn_nd_1, $message);
|
|
$message = str_replace("perihal_nd", 'Permohonan Sebagai '.$sebagai, $message);
|
|
$message = str_replace("nama_pelatihan_nd_1", $nama_pelatihan_nd_1, $message);
|
|
|
|
if ($tanggal_mulai==$tanggal_selesai) {
|
|
$message = str_replace("hari_nd_1", $hari1, $message);
|
|
$message = str_replace("tanggal_nd1", date('d',strtotime($tanggal_mulai)).' '.($bulan[date('m',strtotime($tanggal_mulai))]).' '.date('Y',strtotime($tanggal_mulai)), $message);
|
|
} else {
|
|
$message = str_replace("hari_nd_1", $hari1.' s/d '.$hari2, $message);
|
|
$message = str_replace("tanggal_nd1", date('d',strtotime($tanggal_mulai)).' '.($bulan[date('m',strtotime($tanggal_mulai))]).' '.date('Y',strtotime($tanggal_mulai)).' s/d '.date('d',strtotime($tanggal_selesai)).' '.($bulan[date('m',strtotime($tanggal_selesai))]).' '.date('Y',strtotime($tanggal_selesai)), $message);
|
|
}
|
|
if (date('H:i',strtotime($waktu_selesai))=='00:00') {
|
|
$message = str_replace("waktu_nd_1", date('H:i',strtotime($waktu_mulai)).' s/d Selesai', $message);
|
|
} else {
|
|
$message = str_replace("waktu_nd_1", date('H:i',strtotime($waktu_mulai)).' s/d '.date('H:i',strtotime($waktu_selesai)), $message);
|
|
}
|
|
$message = str_replace("tempat_nd_1", $tempat_nd_1, $message);
|
|
$message = str_replace("sebagai_nd", $sebagai, $message);
|
|
$message = str_replace("kabid_nd_1", $nm_kepala, $message);
|
|
$message = str_replace("pangkat_nd_1", $pangkat, $message);
|
|
$message = str_replace("nip_nd_1", $nip, $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;
|
|
|
|
|
|
|
|
?>
|