<?php
session_start();
require("mainconfig.php");
$msg_type = "nothing";

if (isset($_SESSION['user'])) {
	$sess_username = $_SESSION['user']['username'];
	$check_user = mysqli_query($db, "SELECT * FROM users WHERE username = '$sess_username'");
	$data_user = mysqli_fetch_assoc($check_user);
	if (mysqli_num_rows($check_user) == 0) {
		header("Location: ".$cfg_baseurl."logout.php");
	} else if ($data_user['status'] == "Suspended") {
		header("Location: ".$cfg_baseurl."logout.php");
	}

	$check_order = mysqli_query($db, "SELECT SUM(price) AS total FROM orders WHERE user = '$sess_username'");
	$data_order = mysqli_fetch_assoc($check_order);
	$count_users = mysqli_num_rows(mysqli_query($db, "SELECT * FROM users"));
} else {
	if (isset($_POST['login'])) {
		$post_username = mysqli_real_escape_string($db, trim($_POST['username']));
		$post_password = mysqli_real_escape_string($db, trim($_POST['password']));
		if (empty($post_username) || empty($post_password)) {
			$msg_type = "error";
			$msg_content = "<b>Gagal:</b> Mohon mengisi semua input.";
		} else {
			$check_user = mysqli_query($db, "SELECT * FROM users WHERE username = '$post_username'");
			if (mysqli_num_rows($check_user) == 0) {
				$msg_type = "error";
				$msg_content = "<b>Gagal:</b> Username atau password salah.";
			} else {
				$data_user = mysqli_fetch_assoc($check_user);
				if ($post_password <> $data_user['password']) {
					$msg_type = "error";
					$msg_content = "<b>Gagal:</b> Username atau password salah.";
				} else if ($data_user['status'] == "Suspended") {
					$msg_type = "error";
					$msg_content = "<b>Gagal:</b> Akun nonaktif.";
				} else {
					$_SESSION['user'] = $data_user;
					header("Location: ".$cfg_baseurl);
				}
			}
		}
	}
}

include("lib/header.php");
if (isset($_SESSION['user'])) {
?>
						<div class="row">
        <div class="col-md-12">
			<div class="alert alert-info">
<marquee>
<?php
$qslider = mysqli_query($db, "SELECT * FROM orders WHERE date = '$date' ORDER BY id DESC LIMIT 20");
while($slider = mysqli_fetch_assoc($qslider)) {
	$slider_userstr = "-".strlen($slider['user']);
	$slider_usersensor = substr($slider['user'],$slider_userstr,-3);
	echo "<span style='margin-right: 30px;'><b>".$slider_usersensor."***</b> telah melakukan pembelian ".$slider['quantity']." ".$slider['service']."</span>";
}
?>
</marquee>
								</div>
							</div>
							<div class="col-md-4">
								<div class="mini-stats-container mini-stats-pink">
									<div class="mini-stats-content">
										<h3 class="m-n fw-thk text-white">Rp <?php echo number_format($data_user['balance'],0,',','.'); ?></h3>
										<small class="text-uppercase text-white">Sisa Saldo Saya</small>
									</div>
									<div class="mini-stats-icon">
										<i class="fa fa-money fa-5x"></i>
									</div>
								</div>
							</div>
							<div class="col-md-4">
								<div class="mini-stats-container mini-stats-violet">
									<div class="mini-stats-content">
										<h3 class="m-n fw-thk text-white">Rp <?php echo number_format($data_order['total'],0,',','.'); ?></h3>
										<small class="text-uppercase text-white">Total Pembelian Saya</small>
									</div>
									<div class="mini-stats-icon">
										<i class="fa fa-shopping-cart fa-5x"></i>
									</div>
								</div>
							</div>
						<div class="row">
							<div class="col-md-12">
								<div class="panel panel-default">
									<div class="panel-heading">
										<h3 class="panel-title"><i class="fa fa-info-circle"></i> Berita</h3>
									</div>
									<div class="panel-body">
										<div class="table-responsive">
											<table class="table table-striped table-bordered table-hover m-0">
												<thead>
													<tr>
														<th>#</th>
														<th>Tanggal</th>
														<th>Isi</th>
													</tr>
												</thead>
												<tbody>
													<?php
													$check_news = mysqli_query($db, "SELECT * FROM news ORDER BY id DESC LIMIT 8");
													$no = 1;
													while ($data_news = mysqli_fetch_assoc($check_news)) {
													?>
													<tr>
														<th scope="row"><?php echo $no; ?></th>
														<td><?php echo $data_news['date']; ?></td>
														<td><?php echo $data_news['content']; ?></td>
													</tr>
													<?php
													$no++;
													}
													?>
												</tbody>
											</table>
										</div>
									</div>
								</div>
							</div>
						</div>
						<!--end row -->
<?php
} else {
?>
						<div class="row">
							<div class="col-md-offset-2 col-md-8">
								<div class="panel panel-default">
									<div class="panel-heading">
										<h3 class="panel-title"><i class="fa fa-user"></i> Masuk</h3>
									</div>
									<div class="panel-body">
										<?php
										if ($msg_type == "error") {
										?>
										<div class="alert alert-danger">
											<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
											<i class="fa fa-times-circle"></i>
											<?php echo $msg_content; ?>
										</div>
										<?php
										}
										?>
					<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h3>Yuk Masuk!</h3>
</body>
</html>
										<form class="form-horizontal" role="form" method="POST">
											<div class="form-group">
												<label class="col-md-2 control-label">Username</label>
												<div class="col-md-10">
													<input type="text" name="username" class="form-control" placeholder="Username">
												</div>
											</div>
											<div class="form-group">
												<label class="col-md-2 control-label">Password</label>
												<div class="col-md-10">
													<input type="password" name="password" class="form-control" placeholder="Password">
												</div>
											</div>
											<div class="form-group">
												<div class="col-md-offset-2 col-md-10">
													<button type="submit" class="btn btn-success btn-bordered waves-effect w-md waves-light" name="login">Masuk</button>
												</div>
											</div>
										</form>
									</div>
									<div class="panel-footer">
										Belum punya akun? <a class="btn btn-default btn-sm" href="<?php echo $cfg_registerurl; ?>">Daftar!</a>
									</div>
								</div>
							</div>
						</div>
						<!-- end row -->
<?php
}
include("lib/footer.php");
?>