<?php
ini_set('display_errors', 'on');
include_once 'login/login.inc.php';
include_once 'includes/menu.inc.php';
mysql_query("SET NAMES utf8");
$maanden= array("januari", "februari", "maart", "april", "mei", "juni", "juli", "augustus", "september", "oktober", "november", "december");
$opmerking = "";
if ($mysqli->connect_error) {
die('Connect Error: ' . $mysqli->connect_error);
}
if(isset($_POST['nieuwOpslaan'])){
$actie = "nieuwOpslaan";
}elseif(isset($_GET['id'])){
$actie = "edit";
}elseif(isset($_POST['editOpslaan'])){
$actie = "editOpslaan";
}elseif(isset($_GET['nieuw'])){
$actie = "nieuw";
}elseif(isset($_POST['deleteBtn'])){
$actie = "delete";
}else{
$actie="default";
}
switch($actie)
{
case "nieuw";
$output = "<h4>Nieuw item aanmaken</h4><form action='agenda.php' method='post' accept-charset='utf-8'><table>";
$output.= "<tr><td colspan='2' id='buttons'><input type='button' value='Annuleren' onclick=\"window.open('agenda.php', '_self');\"> <input type='submit' name='nieuwOpslaan' value='Opslaan'></td></tr>";
$output.= "<tr><td></td><td style='color:#bc0024'font-weight:'bold'>Géén ' of \" gebruiken!!</td></tr>";
$output.= "<tr><td>Naam:</td><td><input type='text' name='naam' value='' size='60'></td></tr>";
$output.= "<tr><td>Plaats:</td><td><input type='text' name='plaats' value='' size='60'></td></tr>";
$output.= "<tr><td>Datum:</td><td>".dag(date("j"))." ".maand(date("n"), $maanden)." ".jaar(date("Y"))."</td></tr>";
$output.= "<tr><td>Uur:</td><td>".startuur("00:00")."</td></tr>";
$output.= "<tr><td colspan='2'><textarea name='info'>".($row['info'])."</textarea></td></tr>";
$output.= "<tr><td colspan='2' id='buttons'><input type='button' value='Annuleren' onclick=\"window.open('agenda.php', '_self');\"> <input type='submit' name='nieuwOpslaan' value='Opslaan'></td></tr>";
$output.= "</table></form>";
break;
case "edit";
$id = $mysqli->real_escape_string($_GET['id']);
$query = "SELECT naam, plaats, info, date_format(datum, '%d')as dag, date_format(datum, '%m')as maand, date_format(datum, '%Y')as jaar, TIME(datum) as uur FROM agenda WHERE id='".$id."'";
if(!$result = $mysqli->query($query)){ printf("Errormessage: %s\n", $mysqli->error); }else
{
$row = $result->fetch_assoc();
$output = "<form action='agenda.php' method='post' accept-charset='utf-8'><input type='hidden' name='id' value='".$id."'><table>";
$output.= "<tr><td colspan='2' id='buttons'><input type='button' value='Annuleren' onclick=\"window.open('agenda.php', '_self');\"> <input type='submit' name='editOpslaan' value='Opslaan'></td></tr>";
$output.= "<tr><td>Naam:</td><td><input type='text' name='naam' value='".htmlentities($row['naam'], ENT_QUOTES)."' size='60'></td></tr>";
$output.= "<tr><td>Plaats:</td><td><input type='text' name='plaats' value='".htmlentities($row['plaats'], ENT_QUOTES)."' size='60'></td></tr>";
$output.= "<tr><td>Datum:</td><td>".dag($row['dag'])." ".maand($row['maand'], $maanden)." ".jaar($row['jaar'])."</td></tr>";
$output.= "<tr><td>Uur:</td><td>".startuur($row['uur'])."</td></tr>";
$output.= "<tr><td colspan='2'><textarea name='info'>".htmlentities($row['info'], ENT_QUOTES)."</textarea></td></tr>";
$output.= "<tr><td colspan='2' id='buttons'><input type='button' value='Annuleren' onclick=\"window.open('agenda.php', '_self');\"> <input type='submit' name='editOpslaan' value='Opslaan'></td></tr>";
$output.= "</table></form>";
}
break;
case "nieuwOpslaan";
$naam = $mysqli->real_escape_string($_POST['naam']);
$plaats = $mysqli->real_escape_string($_POST['plaats']);
$info = $mysqli->real_escape_string($_POST['info']);
$datum = $mysqli->real_escape_string($_POST['jaar'])."-".$mysqli->real_escape_string($_POST['maand'])."-".$mysqli->real_escape_string($_POST['dag'])." ".$mysqli->real_escape_string($_POST['uur']).":".$mysqli->real_escape_string($_POST['minuten']);
$query = "INSERT into agenda(naam, plaats, info, datum) VALUES ('".$naam."', '".$plaats."', '".$info."', '".$datum."')";
if(!$result = $mysqli->query($query)){ printf("Errormessage: %s\n", $mysqli->error); }else
{
$opmerking = "Nieuw item is toegevoegd";
}
$output = listItems($mysqli)."<div id='extraMenu'><a href='?nieuw' class='button'>nieuw</a></div>";
break;
case "editOpslaan";
$id = $mysqli->real_escape_string($_POST['id']);
$naam = $mysqli->real_escape_string($_POST['naam']);
$plaats = $mysqli->real_escape_string($_POST['plaats']);
$info = $mysqli->real_escape_string($_POST['info']);
$datum = $mysqli->real_escape_string($_POST['jaar'])."-". $mysqli->real_escape_string($_POST['maand'])."-".$mysqli->real_escape_string($_POST['dag'])." ".$mysqli->real_escape_string($_POST['uur']).":". $mysqli->real_escape_string($_POST['minuten']);
$query = "UPDATE agenda SET naam = '".$naam."', plaats = '".$plaats."', info = '".$info."', datum = '".$datum."' WHERE id='".$id."'";
if(!$result = $mysqli->query($query)){ printf("Errormessage: %s\n", $mysqli->error); }else
{
$Opmerking = "<span id='opmerkingGoed'>Nieuw item is toegevoegd</span>";
}
$output = listItems($mysqli)."<div id='extraMenu'><a href='?nieuw' class='button'>nieuw</a></div>";
break;
case "default";
$output = listItems($mysqli)."<div id='extraMenu'><a href='?nieuw' class='button'>nieuw</a></div>";
break;
// toegevoegd by PP
case "delete";
$id = $mysqli->real_escape_string($_POST['id']);
$query = "DELETE FROM agenda WHERE id=$id";
if(!$result = $mysqli->query($query)){ printf("Errormessage: %s\n", $mysqli->error); }else
{
$opmerking = "<span id='opmerkingGoed'>Item is verwijderd</span>";
}
$output = listItems($mysqli)."<div id='extraMenu'><a href='?nieuw' class='button'>nieuw</a></div>";
break;
case "default";
$output = listItems($mysqli)."<div id='extraMenu'><a href='?nieuw' class='button'>nieuw</a></div>";
break;
}
function listItems($mysqli)
{
$maanden= array("januari", "februari", "maart", "april", "mei", "juni", "juli", "augustus", "september", "oktober", "november", "december");
$output = "<div><a href='?nieuw' class='button'>nieuw</a></div><h2>Overzicht Agenda</h2><table id='agenda'>";
$query = "SELECT id, naam, plaats, info, date_format(datum, '%d')as dag, date_format(datum, '%c')as maand, date_format(datum, '%Y')as jaar, TIME(datum)as uur FROM agenda ORDER BY datum DESC";
if(!$result = $mysqli->query($query)){ printf("Errormessage: %s\n", $mysqli->error); }else
{
while($row = $result->fetch_assoc())
{
$output.= "<tr><td class='rowid'>Item ".$row['id']."</td><td class='padding'></td><td class='padding'></td><td class='padding'></td></tr>";
$output.= "<tr><td class='datum'>".$row['dag']." ".$maanden[$row['maand']-1]." ".$row['jaar']."</td><td class='naam'>".($row['naam'])."</td><td><a href='?id=".$row['id']."'class='button'>Bewerk</a></td><td class='delete' id='".$row['id']."'><a class='button'>Verwijder</a></td></tr>";
$output.= "<tr><td class='uur'>".$row['uur']."</td><td class='plaats'>".($row['plaats'])."</td><td></td><td></td></tr>";
$output.= "<tr><td class='uur'></td><td class='info'>".($row['info'])."</td><td></td><td></td></tr>";
}
}
$output.= "</table>";
return $output;
}
function maand($checked, $maanden )
{
$output = "<select name='maand'>";
foreach($maanden as $key => $maand)
{
$output.= ($key+1 == $checked) ? "<option value='".($key + 1)."' selected='selected'>".$maand."</option>" : "<option value='".($key + 1)."' >".$maand."</option>";
}
$output.= "</select>";
return $output;
}
function dag($checked)
{
echo $checked;
$output = "<select name='dag'>";
for($i=1; $i<=31; $i++)
{
$output.= ($i == $checked) ? "<option value='".$i."' selected='selected'>".$i."</option>" : "<option value='".$i."' >".$i."</option>";
}
$output.= "</select>";
return $output;
}
function jaar($checked)
{
$output = "<select name='jaar'>";
for($i=2014; $i<=2020; $i++)
{
$output.= ($i == $checked) ? "<option value='".$i."' selected='selected'>".$i."</option>" : "<option value='".$i."' >".$i."</option>";
}
$output.= "</select>";
return $output;
}
function startuur($startuur)
{
$uurArray = explode(":", $startuur);
$output = "<select name='uur'>";
for($i=0; $i<=24; $i++)
{
$output.= ($i == $uurArray[0]) ? "<option value='".$i."' selected='selected'>".$i."</option>" : "<option value='".$i."' >".$i."</option>";
}
$output.= "</select>";
$output.= "<select name='minuten'>";
for($i=0; $i<60; $i = $i+5)
{
$output.= ($i == $uurArray[1]) ? "<option value='".$i."' selected='selected'>".$i."</option>" : "<option value='".$i."' >".$i."</option>";
}
$output.= "</select>";
return $output;
}
?>