-
Notifications
You must be signed in to change notification settings - Fork 37
/
hapus_surat_masuk.php
152 lines (141 loc) · 6.99 KB
/
hapus_surat_masuk.php
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
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
//cek session
if(empty($_SESSION['admin'])){
$_SESSION['err'] = '<center>Anda harus login terlebih dahulu!</center>';
header("Location: ./");
die();
} else {
if(isset($_SESSION['errQ'])){
$errQ = $_SESSION['errQ'];
echo '<div id="alert-message" class="row jarak-card">
<div class="col m12">
<div class="card red lighten-5">
<div class="card-content notif">
<span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errQ.'</span>
</div>
</div>
</div>
</div>';
unset($_SESSION['errQ']);
}
$id_surat = mysqli_real_escape_string($config, $_REQUEST['id_surat']);
$query = mysqli_query($config, "SELECT * FROM tbl_surat_masuk WHERE id_surat='$id_surat'");
if(mysqli_num_rows($query) > 0){
$no = 1;
while($row = mysqli_fetch_array($query)){
if($_SESSION['id_user'] != $row['id_user'] AND $_SESSION['id_user'] != 1){
echo '<script language="javascript">
window.alert("ERROR! Anda tidak memiliki hak akses untuk menghapus data ini");
window.location.href="./admin.php?page=tsm";
</script>';
} else {
echo '
<!-- Row form Start -->
<div class="row jarak-card">
<div class="col m12">
<div class="card">
<div class="card-content">
<table>
<thead class="red lighten-5 red-text">
<div class="confir red-text"><i class="material-icons md-36">error_outline</i>
Apakah Anda yakin akan menghapus data ini?</div>
</thead>
<tbody>
<tr>
<td width="13%">No. Agenda</td>
<td width="1%">:</td>
<td width="86%">'.$row['no_agenda'].'</td>
</tr>
<tr>
<td width="13%">Kode Klasifikasi</td>
<td width="1%">:</td>
<td width="86%">'.$row['kode'].'</td>
</tr>
<td width="13%">Indeks Berkas</td>
<td width="1%">:</td>
<td width="86%">'.$row['indeks'].'</td>
</tr>
<tr>
<td width="13%">No. Isi</td>
<td width="1%">:</td>
<td width="86%">'.$row['isi'].'</td>
</tr>
<tr>
<td width="13%">File</td>
<td width="1%">:</td>
<td width="86%">';
if(!empty($row['file'])){
echo ' <a class="blue-text" href="?page=gsm&act=fsm&id_surat='.$row['id_surat'].'">'.$row['file'].'</a>';
} else {
echo ' Tidak ada file yang diupload';
} echo '</td>
</tr>
<tr>
<td width="13%">Asal Surat</td>
<td width="1%">:</td>
<td width="86%">'.$row['asal_surat'].'</td>
</tr>
<tr>
<td width="13%">No. Surat</td>
<td width="1%">:</td>
<td width="86%">'.$row['no_surat'].'</td>
</tr>
<tr>
<td width="13%">Tanggal Surat</td>
<td width="1%">:</td>
<td width="86%">'.indoDate($row['tgl_surat']).'</td>
</tr>
<tr>
<td width="13%">Keterangan</td>
<td width="1%">:</td>
<td width="86%">'.$row['keterangan'].'</td>
</tr>
</tbody>
</table>
</div>
<div class="card-action">
<a href="?page=tsm&act=del&submit=yes&id_surat='.$row['id_surat'].'" class="btn-large deep-orange waves-effect waves-light white-text">HAPUS <i class="material-icons">delete</i></a>
<a href="?page=tsm" class="btn-large blue waves-effect waves-light white-text">BATAL <i class="material-icons">clear</i></a>
</div>
</div>
</div>
</div>
<!-- Row form END -->';
if(isset($_REQUEST['submit'])){
$id_surat = $_REQUEST['id_surat'];
//jika ada file akan mengekseskusi script dibawah ini
if(!empty($row['file'])){
unlink("upload/surat_masuk/".$row['file']);
$query = mysqli_query($config, "DELETE FROM tbl_surat_masuk WHERE id_surat='$id_surat'");
$query2 = mysqli_query($config, "DELETE FROM tbl_disposisi WHERE id_surat='$id_surat'");
if($query == true){
$_SESSION['succDel'] = 'SUKSES! Data berhasil dihapus<br/>';
header("Location: ./admin.php?page=tsm");
die();
} else {
$_SESSION['errQ'] = 'ERROR! Ada masalah dengan query';
echo '<script language="javascript">
window.location.href="./admin.php?page=tsm&act=del&id_surat='.$id_surat.'";
</script>';
}
} else {
//jika tidak ada file akan mengekseskusi script dibawah ini
$query = mysqli_query($config, "DELETE FROM tbl_surat_masuk WHERE id_surat='$id_surat'");
$query2 = mysqli_query($config, "DELETE FROM tbl_disposisi WHERE id_surat='$id_surat'");
if($query == true){
$_SESSION['succDel'] = 'SUKSES! Data berhasil dihapus<br/>';
header("Location: ./admin.php?page=tsm");
die();
} else {
$_SESSION['errQ'] = 'ERROR! Ada masalah dengan query';
echo '<script language="javascript">
window.location.href="./admin.php?page=tsm&act=del&id_surat='.$id_surat.'";
</script>';
}
}
}
}
}
}
}
?>