-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpegawai.php
152 lines (141 loc) · 5.43 KB
/
pegawai.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
$judul = "Pegawai";
include "koneksi.php";
include "header.php";
include "sidebar.php";
include "topbar.php";
?>
<!-- SweetAlert2 -->
<div class="info-data" data-infodata="<?php if(isset($_SESSION['info'])){
echo $_SESSION['info'];
}
unset($_SESSION['info']); ?>">
</div>
<div class="container-fluid pt-3 pb-5 backGambar">
<div class="row">
<div class="col-xl-12">
<h3 class="text-center text-uppercase text-dark">Rekapitulasi Master Pegawai</h3>
<hr class="hr">
</div>
</div>
<div class="row">
<div class="col-xl-12 table-responsive">
<button type="button" class="btn btn-primary btn-sm p-1 mb-3" data-toggle="modal" data-target="#staticBackdrop">
<i class="fas fa-plus"></i> Tambah
</button>
<table class="table table-bordered table-hover" id="pegawai">
<thead>
<tr class="text-center">
<th>No.</th>
<th>Nama Pegawai</th>
<th>Photo</th>
<th>Jenis Kelamin</th>
<th>Alamat</th>
<th>Telp</th>
<th>Jabatan</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$sql = "SELECT * FROM tbl_pegawai";
$query = mysqli_query($koneksi, $sql);
while ($data = mysqli_fetch_array($query)) {
$id_pegawai = $data['id_pegawai'];
$photo = $data['photo'];
$jenis_Kelamin = $data['jenis_kelamin'];
if ($photo == "" && $jenis_Kelamin == "Laki-laki") {
$photo = "male.png";
} else if ($photo == "" && $jenis_Kelamin == "Perempuan") {
$photo = "female.png";
}?>
<tr>
<td align="center" width="5%"><?= $no++; ?>.</td>
<td><?= $data['nama_pegawai']; ?></td>
<td align="center"><img src="photo/<?= $photo; ?>" alt="photo" width="40" height="40"></td>
<td><?= $data['jenis_kelamin']; ?></td>
<td><?= $data['alamat']; ?></td>
<td><?= $data['telp']; ?></td>
<td><?= $data['jabatan']; ?></td>
<td align="center">
<a href="pegawai-edit.php?id_pegawai=<?= $id_pegawai ?>" class="badge badge-primary p-2" title="Edit"><i class="fas fa-edit"></i></a>
<?php
if($id_pegawai>2){?>
|
<a href="pegawai-delete.php?id_pegawai=<?= $data['id_pegawai']; ?>" class="badge badge-danger p-2 delete-data" title="Delete"><i class="fas fa-trash"></i></a>
<?php
}?>
</td>
</tr>
<?php
} ?>
</tbody>
</table>
</div>
</div>
</div>
<?php include "sticky-footer.php"; ?>
<?php include "footer.php"; ?>
<!-- Modal Tambah-->
<div class="modal fade" id="staticBackdrop" data-backdrop="static" data-keyboard="false" tabindex="-1" aria-labelledby="staticBackdropLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="staticBackdropLabel">
Input Master Pegawai
</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form action="pegawai-simpan.php" method="post" enctype="multipart/form-data">
<div class="input-group input-group-sm mb-1">
<span class="input-group-text lebar">Nama Pegawai</span>
<input type="text" name="nama_pegawai" required autocomplete="off" class="form-control" placeholder="Input Nama Pegawai">
</div>
<div class="input-group mb-1">
<span class="input-group-text lebar">Jenis Kelamin</span>
<select name="jenis_kelamin" class="form-control form-control-sm" required>
<option value="" selected>~ Pilih Jenis Kelamin ~</option>
<option value="Laki-laki">Laki-laki</option>
<option value="Perempuan">Perempuan</option>
</select>
</div>
<div class="input-group input-group-sm mb-1">
<span class="input-group-text lebar">Alamat</span>
<textarea name="alamat" id="" cols="30" rows="2" class="form-control"></textarea>
</div>
<div class="input-group input-group-sm mb-1">
<span class="input-group-text lebar">No Telp / HP</span>
<input type="text" name="telp" required autocomplete="off" class="form-control form-control-sm" placeholder="Input No Telp / HP">
</div>
<!-- Jabatan -->
<div class="input-group mb-1">
<span class="input-group-text lebar">Jabatan</span>
<select name="jabatan" class="form-control form-control-sm" required>
<option value="" selected>~ Pilih Jabatan ~</option>
<option value="Admin">Admin</option>
<option value="Kasir">Kasir</option>
<option value="Manajer">Manajer</option>
</select>
</div>
<!-- Photo -->
<div class="input-group mb-1">
<span class="input-group-text lebar">Photo</span>
<input type="file" name="photo" class="form-control form-control-sm" accept="image/*">
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-primary btn-sm"> <i class="fas fa-save"></i> Simpan </button>
</div>
</form>
</div>
</div>
</div>
</div>
<script>
$(document).ready(function() {
$('#pegawai').dataTable();
});
</script>