<?php
ini_set('date.timezone', 'Asia/Jakarta');
require_once "view/indo_tgl.php";
require_once "htmlpurifier/library/HTMLPurifier.auto.php";
$config = HTMLPurifier_Config::createDefault();
$purifier = new HTMLPurifier($config);
$userID = $_SESSION['id_user'];
$params = array(':status' => 1);
$pengaturan = $this->model->selectprepare("pengaturan", $field=null, $params, "status=:status", $other=null);
if($pengaturan->rowCount() >= 1){
$data_pengaturan= $pengaturan->fetch(PDO::FETCH_OBJ);
$kop = $data_pengaturan->logo;
$title = $data_pengaturan->title;
$deskripsi = $data_pengaturan->deskripsi;
}else{
$kop = "default.jpg";
$title = "SIAS - Sistem Informasi Arsip Surat";
$deskripsi = "SIAS merupakan aplikasi pengelolaan arsip surat";
}
if(isset($_GET['smid'])){
$params = array(':id_sm' => trim($_GET['smid']));
$sm = $this->model->selectprepare("surat_masuk", $field=null, $params, "id_sm=:id_sm", $order=null);
if($sm->rowCount() >= 1){
$data_memo = $sm->fetch(PDO::FETCH_OBJ);
$ListUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC");
$TujuanSurat = "";
while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){
if(false !== array_search($dataListUser->id_user, json_decode($data_memo->tujuan_surat, true))){
$TujuanSurat .= '- '.$dataListUser->nama .'<br/>';
}
}
$params = array(':id' => '5', ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "idkop=:id AND id_user=:userid");
if($surat_digital->rowCount() >= 1){
$dataKopSet= $surat_digital->fetch(PDO::FETCH_OBJ);
} else {
$kop_setting = $this->model->selectprepare("kop_setting", $field=null, $params=null, $where=null, "where idkop = '5' ");
$dataKopSet= $kop_setting->fetch(PDO::FETCH_OBJ);
}
$layout = $dataKopSet->layout;
$Rlayout = $layout;
$no_agenda = $this->model->noref_sm($data_memo->id_sm);
$arr = array("=NoAgenda=" => $no_agenda, "=NoSurat=" => $data_memo->no_sm, "=Perihal=" => $data_memo->perihal, "=TujuanSurat=" => $TujuanSurat, "=TglSurat=" =>tgl_indo($data_memo->tgl_sm), "=TglTerima=" => tgl_indo($data_memo->tgl_terima), "=AsalSurat=" =>$data_memo->asal_sm, "=Penerima=" => $_SESSION['nama']);
foreach($arr as $nama => $value){
if(strpos($layout, $nama) !== false) {
$Rlayout = str_replace($nama, $value, $layout);
$layout = $Rlayout;
}
}?>
<html>
<head>
<title><?php echo $title;?></title>
<meta name="description" content="<?php echo $deskripsi;?>" />
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body>
<p style="text-align:center;"><img src="./<?php echo "foto/$kop";?>" width="795"></p>
<table border="0" width="750" style='border-collapse:collapse;' align="center">
<tr align=left height="70">
<td style="padding: 5px; vertical-align: top;"><?php echo $layout;?></td>
</tr>
</table>
</body>
</html><?php
}else{
echo "Belum ada data";
}
} else {
if(isset($_GET['skid'])){
$params = array(':id_sk' => trim($_GET['skid']));
$sk = $this->model->selectprepare("surat_keluar", $field=null, $params, "id_sk=:id_sk", $order=null);
if($sk->rowCount() >= 1){
$data_memo = $sk->fetch(PDO::FETCH_OBJ);
/*$ListUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC");
$TujuanSurat = "";
while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){
if(false !== array_search($dataListUser->id_user, json_decode($data_memo->tujuan_surat, true))){
$TujuanSurat .= '- '.$dataListUser->nama .'<br/>';
}
}*/
$params = array(':id' => '4', ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "idkop=:id AND id_user=:userid");
if($surat_digital->rowCount() >= 1){
$dataKopSet= $surat_digital->fetch(PDO::FETCH_OBJ);
} else {
$kop_setting = $this->model->selectprepare("kop_setting", $field=null, $params=null, $where=null, "where idkop = '4' ");
$dataKopSet= $kop_setting->fetch(PDO::FETCH_OBJ);
}
$layout = $dataKopSet->layout;
$Rlayout = $layout;
$no_agenda = $this->model->noref($data_memo->id_sk);
$arr = array("=NoAgenda=" => $no_agenda, "=Perihal=" => $data_memo->perihal, "=TujuanSurat=" => $data_memo->tujuan, "=TglSurat=" =>tgl_indo($data_memo->tgl_agenda), "=TglTerima=" => tgl_indo($data_memo->tgl_agenda), "=Penerima=" => $_SESSION['nama']);
foreach($arr as $nama => $value){
if(strpos($layout, $nama) !== false) {
$Rlayout = str_replace($nama, $value, $layout);
$layout = $Rlayout;
}
}?>
<html>
<head>
<title><?php echo $title;?></title>
<meta name="description" content="<?php echo $deskripsi;?>" />
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body>
<p style="text-align:center;"><img src="./<?php echo "foto/$kop";?>" width="795"></p>
<table border="0" width="750" style='border-collapse:collapse;' align="center">
<tr align=left height="70">
<td style="padding: 5px; vertical-align: top;"><?php echo $layout;?></td>
</tr>
</table>
</body>
</html><?php
}else{
echo "Belum ada data";
}
} else {
$params = array(':id_sk' => trim($_GET['skiid']));
$sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "id_sk=:id_sk", $order=null);
if($sk->rowCount() >= 1){
$data_memo = $sk->fetch(PDO::FETCH_OBJ);
$ListUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "ORDER BY a.nama ASC");
$TujuanSurat = "";
while($dataListUser = $ListUser->fetch(PDO::FETCH_OBJ)){
if(false !== array_search($dataListUser->id_user, json_decode($data_memo->tujuan_surat, true))){
$TujuanSurat .= '- '.$dataListUser->nama .'<br/>';
}
}
$params = array(':id' => '4', ':userid' => $userID);
$surat_digital = $this->model->selectprepare("setting_surat_digital", $field=null, $params, "idkop=:id AND id_user=:userid");
if($surat_digital->rowCount() >= 1){
$dataKopSet= $surat_digital->fetch(PDO::FETCH_OBJ);
} else {
$kop_setting = $this->model->selectprepare("kop_setting", $field=null, $params=null, $where=null, "where idkop = '4' ");
$dataKopSet= $kop_setting->fetch(PDO::FETCH_OBJ);
}
$layout = $dataKopSet->layout;
$Rlayout = $layout;
$no_agenda = $this->model->noref($data_memo->id_sk, "internal");
$arr = array("=NoAgenda=" => $no_agenda, "=Perihal=" => $data_memo->perihal, "=TujuanSurat=" => $TujuanSurat, "=TglSurat=" =>tgl_indo($data_memo->tgl_agenda), "=TglTerima=" => tgl_indo($data_memo->tgl_agenda), "=Penerima=" => $_SESSION['nama']);
foreach($arr as $nama => $value){
if(strpos($layout, $nama) !== false) {
$Rlayout = str_replace($nama, $value, $layout);
$layout = $Rlayout;
}
}?>
<html>
<head>
<title><?php echo $title;?></title>
<meta name="description" content="<?php echo $deskripsi;?>" />
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body>
<p style="text-align:center;"><img src="./<?php echo "foto/$kop";?>" width="795"></p>
<table border="0" width="750" style='border-collapse:collapse;' align="center">
<tr align=left height="70">
<td style="padding: 5px; vertical-align: top;"><?php echo $layout;?></td>
</tr>
</table>
</body>
</html><?php
}else{
echo "Belum ada data";
}
}
}
/*Cetak Direct PDF*/
if(isset($_GET['act']) AND $_GET['act'] == "pdf"){
$filename="Letter-".$data_memo->id_sm.".pdf"; //ubah untuk menentukan nama file pdf yang dihasilkan nantinya
$content = ob_get_clean();
$content = '<page style="font-family: freeserif">'.nl2br($content).'</page>';
require_once 'html2pdf/html2pdf.class.php';
try{
$html2pdf = new HTML2PDF('P','A4','en', false, 'ISO-8859-15',array(0, 5, 0, 0));
$html2pdf->setDefaultFont('Arial');
$html2pdf->writeHTML($content, isset($_GET['vuehtml']));
$html2pdf->Output($filename);
}catch(HTML2PDF_exception $e){
echo "Terjadi Error kerena : ".$e;
}
}
?>