<?php
session_start();
include_once 'functions/fungsi.php';
include_once 'connection/koneksi.php';
$query = "SELECT menu.harga as harga, pesanan.jumlah as jumlah FROM pesanan INNER JOIN menu ON pesanan.id_menu = menu.id";
$result_set = $database->query($query);
?>
?>
<!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="index.php #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>
<body>
<div class="container">
<div class="row">
<div class="col-lg-8 col-md-6 col-xs-12">
<div class="row">
<div class="col-lg-8 col-md-6 col-xs-6">
</div>
</div>
</div>
</div>
</div>
<br>
<br>
<br>
<br>
<p>
<table border="1px"><br>
<tr>
<th>Total harga</th>
</tr>
<?php
$total = 0;
while ($row = $result_set->fetch_array()) {
$total = $total + ($row['harga'] * $row['jumlah']);
}
?>
<tr><td><?= $total ?></td></tr>
</table>
<a href="bayar_process.php?harga=<?= $total ?>">oke</a>
</p>
</div>
</div>
</div>
<div class="clear"></div>
</div>
</body>