progress_report_print.php
5.42 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
<?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);
$start = htmlspecialchars($purifier->purify(trim($_GET['start'])), ENT_QUOTES);
$to = htmlspecialchars($purifier->purify(trim($_GET['to'])), ENT_QUOTES);
$noagenda = htmlspecialchars($purifier->purify(trim($_GET['noagenda'])), ENT_QUOTES);
$wherekCon = '';
if(isset($start) AND $start !='' AND isset($to) AND $to !=''){
$wherekCon .= "WHERE tgl_sm between '$start' AND '$to'";
}
if(isset($noagenda) AND $noagenda !=''){
if(isset($start) AND $start !='' AND isset($to) AND $to !=''){
$wherekCon .= "AND (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 surat_masuk 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 = surat_masuk.id_sm) LIKE '%".$noagenda."%' OR no_sm LIKE '%".$noagenda."%'";
}else{
$wherekCon .= " 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 surat_masuk 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 = surat_masuk.id_sm) LIKE '%".$noagenda."%' OR no_sm LIKE '%".$noagenda."%'";
}
}
$ArsipSM = $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "$wherekCon order by tgl_sm ASC");
if($ArsipSM->rowCount() >= 1){
while($dataArsipSM = $ArsipSM->fetch(PDO::FETCH_OBJ)){
$dump_sm[]=$dataArsipSM;
}
$kopSet = $this->model->selectprepare(" pengaturan", $field=null, $params=null, $where=null, "WHERE id='1'");
$dataKopSet= $kopSet->fetch(PDO::FETCH_OBJ);?>
<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/$dataKopSet->logo";?>" width="795"></p>
<div id="container">
<div id="row">
<h3 style="text-align:center;">Laporan Progress Surat<?php
if(isset($start) AND $start !='' AND isset($to) AND $to !=''){?><br/>
<b><?php echo tgl_indo($start);?></b> s/d <b><?php echo tgl_indo($to);?></b><?php
}?></h3>
<table width="100%" border="1" cellspacing="3" cellpadding="3" style='border-collapse:collapse;' align="center">
<tr align=left>
<td nowrap style="padding: 5px; vertical-align: top;">No</td>
<td nowrap style="padding: 5px; vertical-align: top;">No Agenda</td>
<td nowrap style="padding: 5px; vertical-align: top;">No Surat</td>
<td nowrap style="padding: 5px; vertical-align: top;" width="200">Perihal</td>
<td nowrap style="padding: 5px; vertical-align: top;" width="140">Asal Surat</td>
<td nowrap style="padding: 5px; vertical-align: top;" width="400">Progress</td>
</tr><?php
$no=1;
foreach($dump_sm as $key => $object){
$CekSM = $this->model->selectprepare("surat_masuk", $field=null, $params=null, $where=null, "WHERE id_sm = '$object->id_sm'");
if($CekSM->rowCount() >= 1){
$tglsurat = explode("-", $object->tgl_sm);
$tglsurat = $tglsurat[2]."/".$tglsurat[1]."/".$tglsurat[0];
$tgltrm = explode("-", $object->tgl_terima);
$tgltrm = $tgltrm[2]."/".$tgltrm[1]."/".$tgltrm[0];?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $this->model->noref_sm($object->id_sm);?></td>
<td><?php echo $object->no_sm;?></td>
<td><?php echo $object->perihal;?></td>
<td><?php echo $object->asal_sm;?></td>
<td><?php
$CekProgress = $this->model->selectprepare("status_surat", $field=null, $params=null, $where=null, "WHERE id_sm = '$object->id_sm' order by statsurat ASC");
while($dataCekProgress = $CekProgress->fetch(PDO::FETCH_OBJ)){
$CekUser = $this->model->selectprepare("user", $field=null, $params=null, $where=null, "WHERE id_user = '$dataCekProgress->id_user'")->fetch(PDO::FETCH_OBJ);
if($dataCekProgress->statsurat == 1){
$statusSirat = "Sedang diproses";
}elseif($dataCekProgress->statsurat == 2){
$statusSirat = "Selesai";
}elseif($dataCekProgress->statsurat == 0){
$statusSirat = "Dibatalkan";
}?>
<ul><li><b><?php echo $CekUser->nama;?></b> status : <b><?php echo $statusSirat;?></b> <br/><?php echo $dataCekProgress->ket;?><br/><?php echo tgl_indo1($dataCekProgress->created);?>, <?php echo substr($dataCekProgress->created,-9,-3);?> WIB</ul></li><?php
}?>
</td>
</tr><?php
}
$no++;
}?>
</table>
</div>
</div>
</body>
</html><?php
}else{?>
<div class="alert alert-danger">
<button type="button" class="close" data-dismiss="alert">
<i class="ace-icon fa fa-times"></i>
</button>
<p>
<strong><i class="ace-icon fa fa-check"></i>Perhatian!</strong>
Data tidak ditemukan. Terimakasih.
</p>
<p>
<a href="./index.php?op=report_disposisi"><button class="btn btn-minier btn-danger">Kembali</button></a>
</p>
</div><?php
}?>