-
Notifications
You must be signed in to change notification settings - Fork 0
/
peminjaman.php
117 lines (105 loc) · 5.01 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
111
112
113
114
115
116
117
<?php
session_start();
if(!isset($_SESSION['admin'])) {
header('location:login.php');
} else {
$username = $_SESSION['admin'];
}
?>
<?php
include "config/koneksi.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">
<meta name="description" content="">
<meta name="author" content="">
<title>Dashboard</title>
<!-- Bootstrap core CSS -->
<link href="bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<link href="bootstrap/dist/css/global.css" rel="stylesheet">
<!-- Custom Fonts -->
<link href="bootstrap/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Peminjaman Alat</a>
</div>
<div id="navbar" class="navbar-collapse collapse">
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a class="dropdown-toggle" data-toggle="dropdown">
<i class="fa fa-user fa-fw"></i>Admin <i class="fa fa-caret-down"></i>
</a>
<ul class="dropdown-menu dropdown-user">
<li><a href="logout.php"><i class="fa fa-sign-out"></i> Logout</a></li>
</ul>
</li>
</ul>
<form class="navbar-form navbar-right">
<input type="text" class="form-control" placeholder="Search...">
</form>
</div>
</div>
</nav>
<div class="container-fluid">
<div class="row">
<div class="col-sm-3 col-md-2 sidebar">
<ul class="nav nav-sidebar">
<li class=""><a href="dashboard.php"><i class="fa fa-dashboard"> Dashboard</i></a></li>
<li><a href="barang.php"><i class="fa fa-laptop"> Barang</i></a></li>
<li><a href="peminjam.php"><i class="fa fa-user"> Anggota</i></a></li>
<li><a href="peminjaman.php"><i class="fa fa-gear"> Peminjaman</i></a></li>
<li><a href="pengembalian.php"><i class="fa fa-book"> Pengembalian</i></a></li>
</ul>
</div>
<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
<h2 class="page-header">Peminjaman</h2>
<div class="row">
<a href="tambahpeminjaman.php" class="btn btn-danger pull-right"><i class="fa fa-plus"></i> Tambah</a>
</div>
<table id="tabelpeminjaman" class="table table-bordered table-striped table-hover">
<thead>
<tr>
<th>No</th>
<th>Nama Barang</th>
<th>Nama Peminjam</th>
<th>Tanggal Pinjam</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<?php
$sql = "SELECT peminjaman.id_peminjaman, peminjaman.status, peminjaman.id_anggota, peminjaman.tgl_pinjam, barang.nama_brg, anggota.nama FROM peminjaman JOIN barang ON peminjaman.id_brg=barang.id_brg JOIN anggota ON anggota.id_anggota=peminjaman.id_anggota ORDER BY peminjaman.id_peminjaman DESC";
$query = $mysqli->query($sql);
$no = 1;
while ($lihat=mysqli_fetch_array($query)){
?>
<tbody>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $lihat ['nama_brg']; ?></td>
<td><?php echo $lihat ['nama'];?></td>
<td><?php echo date('d-m-Y',strtotime($lihat['tgl_pinjam'])); ?></td>
<td><span class="btn btn-xs btn-<?php echo $lihat['status'] == 1 ? 'success' : 'danger' ?>"><?php echo $lihat['status'] == 1 ? 'sudah dikembalikan' : 'belum dikembalikan'; ?></span></td>
<td> <a href="editpeminjaman.php?id_peminjaman=<?php echo $lihat['id_peminjaman']; ?>" class="btn btn-danger">Edit</a>
<a href="hapuspeminjaman.php?id=<?php echo $lihat['id_peminjaman']; ?>" class="btn btn-danger">Hapus</a></td>
</tr>
<?php
} ?>
</tbody>
</table>
</div>
</div>
</div>
<?php require_once "templates/footer.php" ?>