<?php  
include('../koneksi.php');
date_default_timezone_set('Asia/Jakarta');
require('pdf_md_table.php');

$pdf=new PDF_MD_Table('P','mm','Legal');
$pdf->SetMargins(10,10,10,10);
$pdf->AddPage();
$pdf->SetLineWidth(0);

$id_rw_peserta=$_GET['id'];

$ket=pg_query("SELECT DISTINCT 
k.tanggal_undangan,
k.no_undangan,
(SELECT u.status FROM sifat_undangan u WHERE u.id=k.sifat_undangan_id),
k.lampiran,
(SELECT w.nama FROM data_pegawai w WHERE w.id=p.data_pegawai_id),
(SELECT j.nama FROM jabatan_pegawai j WHERE j.id=(SELECT w.jabatan_pegawai_id FROM data_pegawai w WHERE w.id=p.data_pegawai_id)),
k.tgl_acara,
k.waktu_mulai,
k.waktu_selesai,
(SELECT r.nama FROM data_ruangan r WHERE r.id=k.tempat),
k.tujuan,
(SELECT w.nama FROM data_pegawai w WHERE w.id=k.pimpinan),
p.id,
p.waktu_mulai,
p.waktu_selesai,
(SELECT j2.nama FROM jabatan_pegawai j2 WHERE j2.id=(SELECT w.jabatan_pegawai_id FROM data_pegawai w WHERE w.id=k.pimpinan)),
k.kesimpulan,
p.jabtim,
k.tindak_lanjut,k.status_pemesanan_id,k.status_kegiatan_id
FROM riwayat_kegiatan k 
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
WHERE k.st_persiapan='Ready'
AND p.id='$id_rw_peserta'
");

while($rket=pg_fetch_array($ket)) {
    $tgl_undangan=$rket[0];
    $no_undangan=$rket[1];
    $sifat_undangan=$rket[2];
    $lamp_undangan=$rket[3];
   // $nama=$rket[4];
    $nama=str_replace("&",",",$rket[4]);
    //$jabatan=str_replace("&","dan",$rket[5]);
    $jabatan=str_replace("&","dan",$rket[17]);
    $tgl_kegiatan=$rket[6];
    $m_tor=$rket[7];
    $s_tor=$rket[8];
    $nm_ruangan=str_replace("&","dan",$rket[9]);
    $tujuan_rapat=$rket[10];
    $nm_pimpinan=$rket[11];
    $id=$rket[12];
    $waktu_mulai=$rket[13];
    $waktu_selesai=$rket[14];
    //$jab_pimpinan=str_replace("&","dan",$rket[15]);
    $jab_pimpinan=str_replace("&","dan",$rket[16]);
    $tindak_lanjut=$rket[18];
    $status_pemesanan_id=$rket['status_pemesanan_id'];
	$status_kegiatan_id=$rket['status_kegiatan_id'];
}

if ($status_pemesanan_id==1) {$sapi='';} else {$sapi='RSUD Dr. Saiful Anwar';}
if ($status_kegiatan_id==1) {$sapi2='';} else {$sapi2='RSUD Dr. Saiful Anwar';}

if (($tindak_lanjut==NULL) || ($tindak_lanjut=='')) {
    $head='';
    $isi_catatan='';
} else {
    $head='Catatan';
    $isi_catatan=$tindak_lanjut;
}

$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");
$hari = $array_hari[date("N",strtotime($tgl_kegiatan))];

$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')];

$kg=strtoupper($tujuan_rapat);
$findme='WORKSHOP CURRENT ISSUES';
$pos=strpos($kg,$findme);
if ($pos !== false) {
$template_file_name = 'undangan2.docx';
$tj=ltrim($kg,$findme);
$tujuan_rapat='KE'.$tj;
} else {
$template_file_name = 'undangan.docx';
}

$rand_no = rand(111111, 999999);
$fileName = "UNDANGAN_".$nama.'_'.date('d',strtotime($tgl_undangan)).''.(date('m',strtotime($tgl_undangan))).''.date('Y',strtotime($tgl_undangan)).".docx";


$tgl_undangan_v=date('d',strtotime($tgl_undangan)).' '.($bulan[date('m',strtotime($tgl_undangan))]).' '.date('Y',strtotime($tgl_undangan));
$no_undangan_v=$no_undangan;
$thn_saiki_v=$thn;
$nama_rapat_v=$nama;

$thn_saiki_v=$thn;
$tgl_undangan_v=date('d',strtotime($tgl_undangan)).' '.($bulan[date('m',strtotime($tgl_undangan))]).' '.date('Y',strtotime($tgl_undangan));
$no_undangan_v=$no_undangan;
$sifat_undangan_aa_v=$sifat_undangan;
$lamp_undangan_aa_v=$lamp_undangan;
$nama_rapat_v=$nama;
$jabatan_rapat_v=$jabatan;
$tgl_kegiatan_rapat_v=date('d',strtotime($tgl_kegiatan)).' '.($bulan[date('m',strtotime($tgl_kegiatan))]).' '.date('Y',strtotime($tgl_kegiatan));
    	if (date('H:i',strtotime($waktu_selesai))=='00:00') {
			$jam_rapat_v=date('H:i',strtotime($waktu_mulai)).' s/d Selesai';
        } else {
			$jam_rapat_v=date('H:i',strtotime($waktu_mulai)).' s/d '.date('H:i',strtotime($waktu_selesai));
        }
$abab_v='Ruang Pertemuan '.$nm_ruangan;
$tujuan_rapat_v=$tujuan_rapat;
$sapi2_v=$sapi2;
        if ($jab_pimpinan=='Direktur') {
    		$nm_pimpinan_v=$jab_pimpinan.' '.$sapi;
        	$nm_instansi_v='';
        } else {
        	$nm_pimpinan_v=$jab_pimpinan;
    		$nm_instansi_v=$sapi;
        }
$hari_rapat_v=$hari;
$nm_kepala_v=$nm_kepala;
$pangkat_v=$pangkat;
$nip_v=$nip;
//$2020_v=$thn;
$hd_v=$head;
$isi_catatan_v=$isi_catatan;


$image="jatim.jpg";
$pdf-> Image($image,25,13,20,22);
$pdf->SetFont('Arial','B',12);
$pdf->Cell(189,5,'PEMERINTAH PROVINSI JAWA TIMUR',0,0,'C');
$image2="rssa.jpg";
$pdf-> Image($image2,170,13,22,22);
$pdf->Ln();
$pdf->SetFont('Arial','B',12);
$pdf->Cell(189,5,'RUMAH SAKIT UMUM DAERAH Dr. SAIFUL ANWAR',0,0,'C');
$pdf->Ln();
$pdf->Cell(189,5,'TERAKREDITASI PARIPURNA',0,0,'C');
$pdf->Ln();
$image3="bintang.jpg";
$pdf->Image($image3,87,25,34,5);
$pdf->Ln();
$pdf->Cell(189,5,'30 November 2022 s.d. 20 November 2026',0,0,'C');
$pdf->Ln();
$pdf->SetFont('Arial','',10);
$pdf->Cell(189,4,'Jl. Jaksa Agung Suprapto No.2 MALANG 65111',0,0,'C');
$pdf->Ln();
$pdf->Cell(189,4,'Telp. ( 0341 ) 362101, Fax. ( 0341 ) 369384',0,0,'C');
$pdf->Ln();
$pdf->Cell(189,4,'E-mail : staf-rsu-drsaifulanwar@jatimprov.go.id',0,0,'C');
$pdf->Ln();
$pdf->Cell(189,4,'Website : www.rsusaifulanwar.jatimprov.go.id',0,0,'C');
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->SetFont('Arial','',10);
$pdf->SetWidths(array(10,25,5,57,10,77));
$pdf->RowKOP(array('','','','','','Malang, '.$tgl_undangan_v));
$pdf->Ln(2);
$pdf->SetWidths(array(10,25,5,52,10,77));
$pdf->RowKOP(array('','','','','','K e p a d a'));
$pdf->SetWidths(array(10,25,5,54,7,10,70,10));
$pdf->RowKOP(array('','Nomor',':','005/'.$no_undangan_v.'/102.7/'.$thn_saiki_v,'','Yth. ',$nama_rapat_v,''));
$pdf->RowKOP(array('','Sifat',':',$sifat_undangan_aa_v,'','',$jabatan_rapat_v,''));
$pdf->RowKOP(array('','Lampiran',':',$lamp_undangan_aa_v,'','','RSUD Dr. SAIFUL ANWAR',''));
$pdf->RowKOP(array('','Perihal',':','U N D A N G A N','','','M A L A N G',''));
$pdf->Ln(2);
$pdf->SetWidths(array(10,25,5,134,10));
$pdf->RowKOP(array('','','','Dengan ini mengharap kehadiran Bapak / Ibu / Sdr. pada :',''));
$pdf->Ln(2);
$pdf->SetWidths(array(40,25,4,105,10));
$pdf->RowKOP(array('','H a r i',':',$hari_rapat_v,''));
$pdf->RowKOP(array('','T a n g g a l',':',$tgl_kegiatan_rapat_v,''));
$pdf->RowKOP(array('','P u k u l',':',$jam_rapat_v,''));
$pdf->RowKOP(array('','T e m p a t',':',$abab_v,''));
$pdf->RowKOP(array('','','',$sapi2_v,''));
$pdf->RowKOP(array('','A c a r a',':',$tujuan_rapat_v,''));
$pdf->RowKOP(array('','Pimpinan',':',$nm_pimpinan_v,''));
$pdf->RowKOP(array('','','',$nm_instansi_v,''));
$pdf->Ln(2);
$pdf->SetWidths(array(10,25,5,134,10));
$pdf->RowKOP(array('','','','Demikian atas perhatiannya, kami ucapkan terima kasih.',''));
$pdf->Ln();
$pdf->SetFont('Arial','',10);
$pdf->SetWidths(array(10,64,10,90,10));
$pdf->Row12(array('','','','a.n. DIREKTUR RSUD Dr. SAIFUL ANWAR',''));
$pdf->Row12(array('','','','Kepala Bagian Umum',''));
$pdf->Ln();
$pdf->Ln();
$pdf->Ln();
$pdf->SetFont('Arial','U',10);
$pdf->Row12(array('','','',$nm_kepala_v,''));
$pdf->SetFont('Arial','',10);
$pdf->Row12(array('','','',$pangkat_v,''));
$pdf->Row12(array('','','','NIP. '.$nip_v,''));
$pdf->Ln();
$pdf->SetFont('Arial','U',8);
$pdf->Row12(array('',$hd_v,'','',''));
$pdf->SetFont('Arial','',8);
$pdf->Row12(array('',$isi_catatan_v,'','',''));

$pdf->Output();
?>