ryan.akbar.0107/simutu
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
simutu/app/print/pdf_undsatker.php
ryan b1a76076bf add simutu on git
2025-10-09 12:30:11 +07:00

231 lines
7.8 KiB
PHP
Raw Permalink Blame History

<?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();
?>
Reference in New Issue View Git Blame Copy Permalink