view_sk_internal_detail.php
4.89 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
<?php
$params = array(':id_sk' => trim($_GET['skid']));
$sk = $this->model->selectprepare("surat_keluar_internal a INNER JOIN user b on a.id_user=b.id_user", $field=null, $params, "a.id_sk=:id_sk", "ORDER BY tgl_agenda DESC");
if($sk->rowCount() >= 1){
$data_sk= $sk->fetch(PDO::FETCH_OBJ);
$idsk= $data_sk->id_sk;
$tujuan = json_decode($data_sk->tujuan, true);
if(isset($_GET['act']) && $_GET['act'] == "del"){
## Hanya Admin yang bisa menghapus ##
if($HakAkses->hapus_surat != "Y"){
die("<script>alert('Hanya Admin dan User tertentu yang diperbolehkan menghapus data. Terimakasih');window.history.go(-1);</script>");
}
@unlink('berkas/'.$data_sk->file);
$params = array(':id_sk' => $idsk);
$delete = $this->model->hapusprepare("surat_keluar_internal", $params, "id_sk=:id_sk");
if($delete){
$cek = $this->model->selectprepare("surat_keluar_internal", $field=null, $params=null, $where=null);
if($cek->rowCount() <= 0){
$delete = $this->model->truncate("surat_keluar_internal");
}
echo "<script type=\"text/javascript\">alert('Data Berhasil di Hapus...!!');window.location.href=\"./index.php?op=sk_internal\";</script>";
}else{
die("<script>alert('Gagal menghapus data surat keluar, Silahkan Coba Kembali..!!');window.history.go(-1);</script>");
}
}
$params = array(':id_user' => $_SESSION['id_user'], ':id_sk' => $data_sk->id_sk, ':kode' => 'SKI');
$lihat_sk = $this->model->selectprepare("surat_read", $field=null, $params, "id_sk=:id_sk AND id_user=:id_user AND kode=:kode");
if($lihat_sk->rowCount() <= 0){
$field = array('id_user' => $_SESSION['id_user'], 'id_sk' => $data_sk->id_sk, 'kode' => 'SKI');
$insert2 = $this->model->insertprepare("surat_read", $field, $params);
}
$params = array(':id_user' => $_SESSION['id_user'], ':id_sk' => $data_sk->id_sk, ':kode' => 'SKI');
$lihat_sk = $this->model->selectprepare("surat_read", $field=null, $params, "id_sk=:id_sk AND id_user=:id_user AND kode=:kode");
if($lihat_sk->rowCount() <= 0){
$field = array('id_user' => $_SESSION['id_user'], 'id_sk' => $data_sk->id_sk, 'kode' => 'SKI');
$insert2 = $this->model->insertprepare("surat_read", $field, $params);
}
?>
<div class="widget-box">
<div class="message-header clearfix">
<div class="pull-left" style="padding:0 9px;">
<span class="blue bigger-125">
<?php echo $data_sk->perihal;?>
</span>
<div class="space-4"></div>
<img class="middle" alt="John's Avatar" src="assets/images/avatars/<?php echo $data_sk->picture;?>" width="32" />
<a href="#" class="sender"><?php echo $data_sk->nama;?></a>
<i class="ace-icon fa fa-clock-o bigger-110 orange middle"></i>
<span class="time grey"><?php echo tgl_indo($data_sk->tgl_agenda);?></span>
</div>
</div>
<div class="hr hr-double"></div>
<div class="message-body">
<p>
Tgl/No Agenda: <br/><b><?php echo tgl_indo($data_sk->tgl_agenda)." | ".$this->model->noref($data_sk->id_sk, "internal");?></b>
</p>
<p>
Perihal: <br/><b><?php echo $data_sk->perihal;?></b>
</p>
<p>
Pembuat: <br/><b><?php echo $data_sk->pembuat;?></b>
</p>
<p>
Penandatangan: <br/><b>
<?php
$field = array('nama_user, jabatan');
$userttd = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$data_sk->penandatangan."' ");
if ($userttd->rowCount() > 0){
$userttd = $userttd->fetch(PDO::FETCH_OBJ);
echo $userttd->nama_user;
}else{
echo $data_sk->penandatangan;
}
?></b>
</p>
<p>
Tujuan Surat: <br/><b>
<?php
if(is_array($tujuan)){
foreach($tujuan as $field => $value){
$field = array('nama_user', 'grup as unit_kerja');
$GetUserDis = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$value."' ")->fetch(PDO::FETCH_OBJ);
echo '- '.$GetUserDis->nama_user.' ('.$GetUserDis->unit_kerja.') <br/>';
}
}?>
</b>
</p>
<ul class="pager"><?php
if($data_sk->file != ''){?>
<li class="previous">
<a href="./berkas/<?php echo $data_sk->file;?>" target="_blank" class="btn btn-primary">Lihat Surat<i class="ace-icon fa fa-file-pdf-o align-top bigger-125 icon-on-right"></i></a>
</li><?php
}
if($HakAkses->sk == "W" AND $data_sk->status_draft=='0'){?>
<li class="next">
<a href="./index.php?op=add_sk_internal&skid=<?php echo $data_sk->id_sk;?>" class="btn btn-danger">Edit Surat<i class="ace-icon fa fa-pencil align-top bigger-125 icon-on-right"></i></a>
</li><?php
}?>
</ul>
</div>
</div><?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 Surat keluar tidak ditemukan. Terimakasih.
</p>
<p>
<a href="./index.php?op=sk"><button class="btn btn-minier btn-danger">Kembali</button></a>
</p>
</div><?php
}?>