-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathhistori_peminjaman.php
More file actions
173 lines (144 loc) · 7.09 KB
/
histori_peminjaman.php
File metadata and controls
173 lines (144 loc) · 7.09 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
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
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<?php
session_start();
if($_SESSION['status_login']!=true){
header('location: login.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<meta name="description" content="Responsive Admin & Dashboard Template based on Bootstrap 5">
<meta name="author" content="AdminKit">
<meta name="keywords" content="adminkit, bootstrap, bootstrap 5, admin, dashboard, template, responsive, css, sass, html, theme, front-end, ui kit, web">
<link rel="shortcut icon" href="img/icons/icon-48x48.png" />
<title>Histori Peminjaman Buku</title>
<link href="css/app.css" rel="stylesheet">
</head>
<body>
<div class="wrapper">
<nav id="sidebar" class="sidebar">
<div class="sidebar-content js-simplebar">
<a class="sidebar-brand" href="dashboard.php">
<span class="align-middle">Perpus Native</span>
</a>
<ul class="sidebar-nav">
<li class="sidebar-header">
Fitur
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="dashboard.php">
<i class="fas fa-fw fa-home"></i> <span class="align-middle">Dashboard</span>
</a>
</li>
<li class="sidebar-item active">
<a class="sidebar-link" href="histori_peminjaman.php">
<i class="fas fa-fw fa-history"></i> <span class="align-middle">Transaksi</span>
</a>
</li>
<li class="sidebar-header">
Data Perpus
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="siswa.php">
<i class="fas fa-fw fa-user-graduate"></i> <span class="align-middle">Siswa</span>
</a>
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="tambah_kelas.php">
<i class="fas fa-fw fa-school"></i> <span class="align-middle">Tambah Kelas</span>
</a>
<li class="sidebar-item">
<a class="sidebar-link" href="buku.php">
<i class="fas fa-fw fa-book"></i> <span class="align-middle">Buku</span>
</a>
</li>
<li class="sidebar-header">
Account Pages
</li>
<li class="sidebar-item">
<a class="sidebar-link" href="logout.php">
<i class="fas fa-sign-out-alt"></i> <span class="align-middle">Logout</span>
</a>
</li>
</ul>
</div>
</nav>
<div class="main">
<!--main konten-->
<main class="content">
<div class="container-fluid p-0">
<h1 class="h3 mb-3">Histori Peminjaman Buku</h1>
<div class="container-fluid py-4">
<div class="row">
<div class="col-12">
<div class="card mb-4">
<div class="card-header pb-0">
<div class="card-body px-0 pt-0 pb-2">
<div class="table-responsive p-0">
<table class="table table-bordered">
<thead>
<tr class="text-xs font-weight-bold opacity-6">
<th>No</th>
<th class="align-middle text-left">Tanggal Pinjam</th>
<th class="align-middle text-left">Tanggal Kembali</th>
<th class="align-middle text-left">Judul Buku</th>
<th class="align-middle text-left">Status</th>
<th class="align-middle text-left">Aksi</th>
</tr>
</thead>
<tbody>
<?php
include "koneksi.php";
$qry_histori=mysqli_query($conn,"select * from peminjaman_buku order by id_peminjaman_buku desc");
$no=0;
while($dt_histori=mysqli_fetch_array($qry_histori)){
$no++;
//menampilkan buku yang dipinjam
$buku_dipinjam="<ol>";
$qry_buku=mysqli_query($conn,"select * from detail_peminjaman_buku join buku on buku.id_buku = detail_peminjaman_buku.id_buku where id_peminjaman_buku = '".$dt_histori['id_peminjaman_buku']."'");
while($dt_buku=mysqli_fetch_array($qry_buku)){
$buku_dipinjam.="<li>".$dt_buku['nama_buku']."</li>";
}
$buku_dipinjam.="</ol>";
//menampilkan status sudah kembali atau belum
$qry_cek_kembali=mysqli_query($conn,"select * from pengembalian_buku where id_peminjaman_buku = '".$dt_histori['id_peminjaman_buku']."'");
if(mysqli_num_rows($qry_cek_kembali)>0){
$dt_kembali=mysqli_fetch_array($qry_cek_kembali);
$denda="denda Rp. ".$dt_kembali['denda'];
$status_kembali="<label class='alert alert-success'>Sudah kembali <br>".$denda."</label>";
$button_kembali="";
} else {
$status_kembali="<label class='alert alert-danger'>Belum kembali</label>";
$button_kembali="<a href='kembali.php?id=".$dt_histori['id_peminjaman_buku']."' class='btn btn-warning' onclick='return confirm(\"Apakah Anda yakin ingin mengembalikan buku?\")'>Kembalikan</a>";
}
?>
<tr>
<td><?=$no?></td><td><?=$dt_histori['tanggal_pinjam']?></td><td><?=$dt_histori['tanggal_kembali']?></td><td><?=$buku_dipinjam?></td><td><?=$status_kembali?></td><td><?=$button_kembali?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<script src="js/app.js"></script>
<script>
document.addEventListener("DOMContentLoaded", function() {
document.getElementById("datetimepicker-dashboard").flatpickr({
inline: true,
prevArrow: "<span class=\"fas fa-chevron-left\" title=\"Previous month\"></span>",
nextArrow: "<span class=\"fas fa-chevron-right\" title=\"Next month\"></span>",
});
});
</script>
</body>
</html>