<?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);
$jenis_surat = $_POST['jenis_surat'];
$checkrangetgl = $_POST['checkrangetgl'];
$where_go = " ";
$where_tgl = "";
if($checkrangetgl == 0){
$tglfrom = $_POST['tglfrom'];
$tglto = $_POST['tglto'];
$where_go = "where ";
$where__ .= " tgl_agenda between '".$tglfrom."' and '".$tglto."' ";
}
if ($_POST['no_agenda'] != "") {
$where_go = "where ";
$where__ .= $checkrangetgl == 0 ? $_POST['andor_no_agenda'] : "";
$where__ .= " (SELECT (CONCAT(b.kode_masalah, '.', b.primer, '.', b.sekunder, '/', c.kode1, '.', c.kode2, '.', lpad(a.no_agenda,5,'0'), '/', DATE_FORMAT(a.tgl_agenda, '%Y'))) as noref FROM ".$jenis_surat." a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sk = ".$jenis_surat.".id_sk) LIKE '%".$_POST['no_agenda']."%' ";
}
if ($_POST['perihal'] != "") {
$where_go = "where ";
$where__ .= $checkrangetgl == 0 || $_POST['no_agenda'] != "" ? $_POST['andor_perihal'] : "";
$where__ .= " perihal LIKE '%".$_POST['perihal']."%'";
}
$field = array("*", "'".$_POST['jenis_surat']."' as jenis_surat");
$arsip_sm = $this->model->selectprepare($jenis_surat, $field, $params=null, $where=null, $where_go.$where__." order by tgl_agenda ASC");
/*print_r($_POST);
$tglfrom = htmlspecialchars($purifier->purify(trim($_GET['start'])), ENT_QUOTES);
$tglto = htmlspecialchars($purifier->purify(trim($_GET['to'])), ENT_QUOTES);
$arsip_sm = $this->model->selectprepare("arsip_sk", $field=null, $params=null, $where=null, "where tgl_surat between '$tglfrom' and '$tglto' order by tgl_surat ASC");*/
if($arsip_sm->rowCount() >= 1){
$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";
}?>
<html>
<head>
<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 onload="window.print()">
<p style="text-align:center;"><img src="./<?php echo "foto/$kop";?>" width="795"></p>
<div id="container">
<div id="row">
<h3 style="text-align:center;">Data Surat Keluar <?php if($checkrangetgl == 0){?>
<b><?php echo tgl_indo($tglfrom);?></b> s/d <b><?php echo tgl_indo($tglto);?></b>
<?php } ?>
</h3>
<table width="600" border="1" cellspacing="0" cellpadding="0" style='border-collapse:collapse;' align="center">
<tr>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">No</td>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">No Agenda</td>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">Tgl Surat</td>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">Pengolah</td>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">Tujuan Surat</td>
<td style="padding: 5px; vertical-align: top;" style="padding: 5px; vertical-align: top;">Perihal</td>
</tr><?php
while($data_sm = $arsip_sm->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$data_sm;
}
$no=1;
foreach($dump_sm as $key => $object){
if ($object->jenis_surat == 'surat_keluar') {
$no_agenda = $this->model->noref($object->id_sk);
$tujuan = $object->tujuan;
} else {
$no_agenda = $this->model->noref($object->id_sk, "internal");
$tujuan = json_decode($object->tujuan, true);
}
$tglsurat = explode("-", $object->tgl_agenda);
$tglsurat = $tglsurat[2]."/".$tglsurat[1]."/".$tglsurat[0];
//$CekKlasifikasi = $this->model->selectprepare("klasifikasi_sk", $field=null, $params=null, $where=null, "WHERE id_klas='$object->klasifikasi'");
//$ViewKlasifikasi = $CekKlasifikasi->fetch(PDO::FETCH_OBJ);?>
<tr>
<td style="padding: 5px; vertical-align: top;"><?php echo $no;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $no_agenda;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $tglsurat;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $object->pembuat;?></td>
<td style="padding: 5px; vertical-align: top;"><?php
if(is_array($tujuan)){
foreach($tujuan as $field => $value){
$field = array('nama', '(SELECT nama FROM unit_kerja WHERE unit_kerja.id = user.unitkerjaid) as unit_kerja');
$GetUserDis = $this->model->selectprepare("user", $field, $params=null, $where=null, "WHERE id_user='".$value."' ")->fetch(PDO::FETCH_OBJ);
echo '- '.$GetUserDis->nama.' ('.$GetUserDis->unit_kerja.') <br/>';
}
} else {
echo $tujuan;
} ?>
</td>
<td style="padding: 5px; vertical-align: top;"><?php echo $object->perihal;?></td>
</tr><?php
$no++;
}?>
</table>
</div>
</div>
</body>
</html><?php
}else{
echo "Belum ada data";
}
/*Cetak Direct PDF*/
if($_POST['print'] == "pdf"){
//$filename="Report-SK-".$tglfrom."-".$tglto.".pdf";
$filename="Report-SK.pdf";
$content = ob_get_clean();
$content = '<page style="font-family: Verdana,Arial,Helvetica,sans-serif"">'.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;
}
}?>