sm_report_print.php
5.72 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
<?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);
/*$tglfrom = htmlspecialchars($purifier->purify(trim($_GET['start'])), ENT_QUOTES);
$tglto = htmlspecialchars($purifier->purify(trim($_GET['to'])), ENT_QUOTES);
$arsip_sm = $this->model->selectprepare("arsip_sm", $field=null, $params=null, $where=null, "where tgl_terima between '$tglfrom' and '$tglto' order by tgl_terima ASC");*/
$jenis_surat = $_POST['jenis_surat'];
$checkrangetgl = isset($_POST['checkrangetgl']) ? $_POST['checkrangetgl'] : '0';
$where_go = " ";
$where_tgl = "";
if($checkrangetgl == 0){
$tglfrom = $_POST['tglfrom'];
$tglto = $_POST['tglto'];
$where_go = "where ";
$where__ .= " tgl_sm 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_sm = ".$jenis_surat.".id_sm) 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");
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";
}
if(isset($_GET['act']) AND $_GET['act'] == "pdf"){
$width="700";
$size="";
}else{
$width="100%";
$size="250";
}?>
<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 Masuk <b><?php if($checkrangetgl == 0){ echo tgl_indo($tglfrom);?></b> s/d <b><?php echo tgl_indo($tglto); }?></b></h3>
<table width="<?php echo $width;?>" border="1" cellspacing="3" cellpadding="3" style='border-collapse:collapse;' align="center">
<tr>
<td style="padding: 5px; vertical-align: top;">No</td>
<td style="padding: 5px; vertical-align: top;">No Agenda</td>
<td style="padding: 5px; vertical-align: top;">No / Tgl Surat</td>
<td style="padding: 5px; vertical-align: top;">Asal Surat</td>
<td style="padding: 5px; vertical-align: top;">Perihal</td>
<td style="padding: 5px; vertical-align: top;">Tgl Terima</td>
<td style="padding: 5px; vertical-align: top;">Tujuan Surat</td>
</tr><?php
while($data_sm = $arsip_sm->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$data_sm;
}
$no=1;
foreach($dump_sm as $key => $object){
$tglsurat = explode("-", $object->tgl_sm);
$tglsurat = $tglsurat[2]."/".$tglsurat[1]."/".$tglsurat[0];
$tgltrm = explode("-", $object->tgl_terima);
$tgltrm = $tgltrm[2]."/".$tgltrm[1]."/".$tgltrm[0];
$ListUser = json_decode($object->tujuan_surat, true);?>
<tr>
<td style="padding: 5px; vertical-align: top;"><?php echo $no;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $this->model->noref_sm($object->id_sm);?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $object->no_sm."<br>".$tglsurat;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $object->asal_sm;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $object->perihal;?></td>
<td style="padding: 5px; vertical-align: top;"><?php echo $tgltrm;?></td>
<td><?php
foreach($ListUser as $ValueUser){
$CekUser = $this->model->selectprepare("user a join user_jabatan b on a.jabatan=b.id_jab", $field=null, $params=null, $where=null, "WHERE a.id_user='$ValueUser' ORDER BY a.nama ASC")->fetch(PDO::FETCH_OBJ);
echo '-'.$CekUser->nama .'<br/>';
}?>
</td>
</tr><?php
$no++;
}?>
</table>
</div>
</div>
</body>
</html><?php
}else{
echo "Belum ada data";
}
/*Cetak Direct PDF*/
if($_POST['print'] == "pdf"){
$filename= "Report-SM.pdf"; //ubah untuk menentukan nama file pdf yang dihasilkan nantinya
$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;
}
}?>