<?php
session_start();
include_once 'functions/fungsi.php';
include_once 'connection/koneksi.php';
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Cafe Bunga Toba</title>
<link rel="stylesheet" href="css/normalize.css">
<link rel="stylesheet" href="css/main.css" media="screen" type="text/css">
<link href='http://fonts.googleapis.com/css?family=Pacifico' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Playball' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/style-portfolio.css">
<link rel="stylesheet" href="css/picto-foundry-food.css" />
<link rel="stylesheet" href="css/jquery-ui.css">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="css/font-awesome.min.css" rel="stylesheet">
<link rel="icon" href="favicon-1.ico" type="image/x-icon">
</head>
<body>
<nav class="navbar navbar-default navbar-fixed-top" role="navigation">
<div class="container">
<div class="row">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<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="index.php">Cafe BUNGA TOBA</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav main-nav clear navbar-right ">
<li><a class="navactive color_animation" href="index.php">WELCOME</a></li>
<?php
if (isset($_SESSION['isLogin']) && (get_session('role') == "member")) {
echo('<li><a class="color_animation" href="profil.php">PROFIL</a></li>');
echo('<li><a class="color_animation" href="#menu">MENU</a></li>');
echo('<li><a class="color_animation" href="pesanan.php">PESANAN</a></li>');
echo('<li><a class="color_animation" href="upload_bukti.php">PEMBAYARAN</a></li>');
echo('<li><a class="color_animation" href="logout.php">LOGOUT (' . get_session('first_name') . ')</a></li>');
}
if (isset($_SESSION['isLogin']) && (get_session('role') == "karyawan" || get_session('role') == "admin")) {
echo('<li><a class="color_animation" href="tambah_menu.php">OLAH MENU</a></li>');
echo('<li><a class="color_animation" href="daftar_pesanan.php">DAFTAR PESANAN</a></li>');
echo('<li><a class="color_animation" href="list_komentar.php">DAFTAR KOMENTAR</a></li>');
echo('<li><a class="color_animation" href="logout.php">LOGOUT (' . get_session('first_name') . ')</a></li>');
}
if (!isset($_SESSION['isLogin'])) {
echo('<li><a class="color_animation" href="profil.php">PROFIL</a></li>');
echo('<li><a class="color_animation" href="#menu">MENU</a></li>');
echo('<li><a class="color_animation" href="login.php">LOGIN</a></li>');
echo('<li><a class="color_animation" href="signup.php">SIGN UP</a></li>');
}
?>
</ul>
</div><!-- /.navbar-collapse -->
</div>
</div><!-- /.container-fluid -->
</nav>
<!-- ============ Daftar Pesanan ============= -->
<section id="daftarpesanan" class="description_content">
<div class="text-content container">
<div class="inner contact row">
<div class="contact-form">
<!-- Form -->
<table class="table table-bordered">
<thead>
<tr>
<th>Pembeli</th>
<th>Total Biaya Pembayaran</th>
<th>Status Pembayaran</th>
</tr>
</thead>
<tbody>
<?php
// $query = "SELECT * FROM pembayaran ";
$query = "SELECT user.first_name as nama, pembayaran.total as total,pembayaran.status as status , pembayaran.gambar as gambar, pembayaran.id as id FROM pembayaran INNER JOIN user ON pembayaran.id_user = user.id ";
$result_set = $conn->query($query);
if ($result_set != NULL) {
while ($row = $result_set->fetch_array()) {
if ($row['status'] != NULL) {
?>
<tr>
<td><?= $row['nama'] ?></td>
<td><?= $row['total'] ?></td>
<?php
if ($row['status'] != "accepted" && $row['status'] != NULL) {
echo '<td>'
. '<a href="view_bukti.php?id=' . $row['gambar'] . '"><button class="btn btn-success">View</button></a> '
. '<a href="confirm.php?id=' . $row['id'] . '"><button class="btn btn-success">Confirm</button></td></a>';
} else {
echo ' <td>' . $row['status'] . '</td> ';
}
?>
</tr>
<?php
}
}
} else {
echo 'ada belum memesan pesan sekarang juga<br><a href="menu.php">Pesan</a>';
}
?>
</tbody>
</table>
</div><!-- End Contact Form Area -->
</div><!-- End Inner -->
</div>
</section>