/
peminjaman.php
110 lines (101 loc) · 4.88 KB
/
peminjaman.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
<?php
include("header.php");
require_once "dbconnect/dbconnect.php";
opendb();
//Menentukan batas, cek halaman dan posisi data
$batas= 7;//Jumlah tampilan record per halaman minimum
if(isset($_GET['halaman']))$halaman = $_GET['halaman'];
if (empty($halaman)){$posisi=0; $halaman=1;} else {$posisi=($halaman-1) * $batas;}
if(isset($_GET['booking']))$booking = $_GET['booking'];
if (empty($booking)) {
$qri = "SELECT * FROM peminjaman";
$hsl = querydb($qri);
} else {
$qri = "SELECT * FROM peminjaman WHERE status = '-'";
$hsl = querydb($qri);
}
$jml_data = numrows($hsl);
$jml_hal = ceil($jml_data/$batas);
if ($jml_hal>20) {$jml_hal=20 AND $batas=ceil($jml_data/$jml_hal);$posisi=($halaman-1) * $batas;}
$file="pagecontrol.php?open=peminjaman";
?>
<div class="row" id="tabelpeminjaman">
<div class="panel panel-primary">
<div class="panel-heading"><span class="glyphicon glyphicon-book"></span> DAFTAR PEMINJAMAN ALAT</div>
<div class="panel-body">
<p><a class="btn btn-info btn-sm" id="btnPeminjamanTambah" href="peminjaman_addpage.php">Pinjam Alat</a>
<a class="btn btn-default btn-sm" id="btnPeminjamanTambah" href="peminjaman.php?booking=1">Daftar Booking Alat</a></p>
<div class="table-responsive">
<table class="table table-striped table-bordered table-condensed table-hover">
<tr>
<th>No.</th>
<th>ID Peminjaman</th>
<th>ID Alat</th>
<th>Nama Alat</th>
<th>No. Identitas</th>
<th>Nama Peminjam</th>
<th>Kategori Peminjam</th>
<th>Kegiatan</th>
<th>Waktu Peminjaman</th>
<th>Durasi</th>
<th>Status</th>
<th colspan="2" align="center">Pilihan</th>
</tr>
<?php
$c=1;
if(isset($_GET['booking']))$booking = $_GET['booking'];
if (empty($booking)) {
$qri = "SELECT * FROM peminjaman ORDER BY id_peminjaman ASC LIMIT $posisi, $batas";
$hsl = querydb($qri);
} else {
$qri = "SELECT * FROM peminjaman WHERE status = '-' ORDER BY id_peminjaman ASC LIMIT $posisi, $batas";
$hsl = querydb($qri);
}
while($rek = arraydb($hsl)){
if($rek['status']=="Y"){$klsBaris="";$stat="<span class='label label-success'>Sudah Dikembalikan</span>";}else if($rek['status']=="T"){$klsBaris="danger";$stat="<span class='label label-danger'>Sedang Dipinjam</span>";} else {$klsBaris="warning";$stat="<span class='label label-warning'>Sudah Dibooking</span>";}
$qri2 = "SELECT * FROM alat WHERE id_alat = '$rek[id_alat]'";
$hsl2 = querydb($qri2);
while($rek2 = arraydb($hsl2)){
echo "<tr class=\"$klsBaris\">";
echo "<td align='center'>".$c."</td>";
echo "<td align='center'>".$rek['id_peminjaman']."</td>";
echo "<td align='center'>".$rek['id_alat']."</td>";
echo "<td align='center'>".$rek2['nama_alat']."</td>";
echo "<td align='center'>".$rek['no_identitas']."</td>";
echo "<td align='center'>".$rek['nama_peminjam']."</td>";
echo "<td align='center'>".$rek['kategori_peminjam']."</td>";
echo "<td align='center'>".$rek['kegiatan']."</td>";
echo "<td align='center'>".$rek['waktu_peminjaman']."</td>";
echo "<td align='center'>".$rek['durasi']."</td>";
echo "<td align='center'>".$stat."</td>";
echo "<td align='center'><a href='peminjaman_edit.php?idPeminjaman=$rek[id_peminjaman]' class=\"btn btn-warning btn-xs btnUbahPeminjaman\" data-val=\"$rek[id_peminjaman]\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Edit Data\"><span class=\"glyphicon glyphicon-pencil\"></span></a></td>";
echo "<td align='center'><button class=\"btn btn-danger btn-xs btnHapusPeminjaman\" data-val=\"$rek[id_peminjaman]\" data-toggle=\"tooltip\" data-placement=\"top\" title=\"Hapus Data\" ><span class=\"glyphicon glyphicon-remove\"></span></button></td>";
echo "<tr>";
$c++;
}
}
?>
</table>
</div><!-- /class responsive -->
<!-- pagination -->
<nav><ul class="pagination pagination-sm">
<?php
if($halaman >1){$prev=$halaman-1; echo "<li><a href=$file&halaman=1>«</a><a href=$file&halaman=$prev><</a></li>";}
else {echo "<li class='disabled'><a href='#'>«</a><a href='#'><</a></li>";}
for ($i=1; $i<=$jml_hal; $i++)
if ($i!=$halaman){echo "<li><a href=$file&halaman=$i>$i</a></li>";}
else {echo" <li class='active'><a href='#'>$i</a></li>";};
if($halaman < $jml_hal) {$next=$halaman+1; echo "<li><a href=$file&halaman=$next>></a> <a href=$file&halaman=$jml_hal>»</a></li>";}
else {echo "<li class='disabled'><a href='#'>></a> <a href='#'>»</a></li>";}
?>
</ul></nav>
<!-- /pagination -->
</div><!-- /panel body -->
</div><!-- /panel -->
</div><!-- /row -->
<script>
$('li:disabled').prop('disabled',true);
</script>
<?php
include("footer.php");
?>