$checkBalans = $db->select($queryCheckBalans);
if ($dbUserId == $sessionUserId) {
$totaalBedragInsert = $totaalBedrag[$sessionUserId];
}
if (count($checkBalans) > 0) {
$queryUpdateBalans = "UPDATE balans SET cost='{$cost[$dbUserId]}', debet='{$totaalBedragInsert}' WHERE user_id='{$dbUserId}' AND date='{$dbDate}'";
$db->update($queryUpdateBalans);
} else {
if ($cost[$dbUserId] != 0 || $totaalBedragInsert != 0) {
$queryInsertBalans = "INSERT INTO balans (user_id, cost, date, debet) VALUES ('{$dbUserId}', '{$cost[$dbUserId]}', '{$dbDate}' ,'{$totaalBedragInsert}')";
$db->insert($queryInsertBalans);
}
}
}
echo "<div class='alert alert-success' role='alert'><b>Afgerekend!</b></div>";
$index->redirect('index.php?page=bord');
} else {
$getId = $filter->getFilter('id');
$query = "SELECT * FROM user ORDER BY user.ancenniteit ASC";
$query2 = "SELECT * FROM balans WHERE id={$getId}";
$db->connect();
$results = $db->select($query);
$results2 = $db->select($query2);
foreach ($results2 as $result2) {
$date1 = strtotime($result2[date]);
$testDate = date('d M', $date1);
$totalDb = $result2['debet'];
}
?>
<div class='container'>
<form action='' method='post'>
function logOut()
{
session_destroy();
echo "<div class='alert alert-warning' role='alert'>Je bent nu uitgelogd.</div>";
$index = new Index();
$index->redirect('index.php');
}
$title = "Log in";
if ($filter->getFilter('action') == 'forgotpass') {
include 'template/login_forgotpass.php';
} else {
$user = $filter->postFilter('user');
$pass = $filter->postFilter('pass');
$submit = $filter->postFilter('submit');
if ($_SESSION['loggedin'] == 1) {
echo 'Al ingelogd';
} else {
if ($submit) {
$login = new Login();
$login->checklogIn($user, $pass);
$url = 'index.php?page=bord';
$index = new Index();
$index->redirect($url);
echo "</div>";
} else {
?>
<body class="login-bg">
<div class="login-card" >
<h1>Log-in</h1><br>
<form method='post' action=''>
<input type="text" required='required' name="user" placeholder="Username">
<input type="password" required='required' name="pass" placeholder="Password">
<input type="submit" name="submit" class='btn btn-default' value="Login">
</form>
<div class="login-help">
<a href="index.php?page=login&action=forgotpass">Forgot Password</a>
<div class='container-full'>
<?php
$db = new Database();
$index = new Index();
$filter = new Filter();
$dbDate = date('m/d/Y');
$dbTime = date("H:i:s");
$sessionUserId = $_SESSION[user_id];
if ($sessionUserId == "5" || $sessionUserId == "10" || $sessionUserId == "12" || $sessionUserId == "13" || $sessionUserId == "11") {
echo "<div class='alert alert-danger' role='alert'><b>Verboden toegang!</b><br>" . "Jij bent nog geen Prince mannetje!</div>";
$index->redirect('index.php?page=sjaars');
} else {
if (isset($_POST['submit'])) {
$punten = $_POST[punten] * -1;
//data in DB
$queryAddPunten = "INSERT INTO `sjaarspunt`" . "(`user_id`, `punten`, `date`, `time`, `comment`, `uitdeler_id`) " . "VALUES ('{$_POST['sjaars']}','{$punten}','{$dbDate}', '{$dbTime}','{$_POST['comment']}','{$sessionUserId}')";
$db->insert($queryAddPunten);
echo "<div class='alert alert-success' role='alert'><b>Minpunten toegerekend!</b><br>" . "Jij bent nog geen Prince, mannetje!</div>";
$index->redirect('index.php?page=sjaars');
} else {
$querySelectPuntJulius = "SELECT SUM(punten) as punten FROM sjaarspunt WHERE user_id = '12'";
$querySelectPuntCalvin = "SELECT SUM(punten) as punten FROM sjaarspunt WHERE user_id = '13'";
$selectJuliusResults = $db->select($querySelectPuntJulius);
$selectCalvinResults = $db->select($querySelectPuntCalvin);
foreach ($selectCalvinResults as $calvin) {
$calvinPunten = $calvin[punten];
}
foreach ($selectJuliusResults as $julius) {
$juliusPunten = $julius[punten];
}
function changeMailcheck($newMail1, $newMail2)
{
$index = new Index();
if ($newMail1 == $newMail2) {
$this->updateMail($newMail1);
$index->redirect('index.php?page=account');
} else {
echo "<div class='alert alert-warning' role='alert'>Het nieuwe emailadres komt niet overeen.</div>";
$index->redirect('index.php?page=account&action=changemail');
}
}
