<?php
// Pagina voor inschrijven lesdata
include_once("config.php");
include_once("connect.php");
include_once("lang/lang_nl.php");
$pml_title = $site_name;
include("header.inc.php");
include("stats.php");
require("safe.php");
//in de ledengegevens de geregistreerde data ophalen
$data = mysql_query("SELECT * FROM userres WHERE id='".$_SESSION['user_id']."'") or die(mysql_error());
while($row1 = mysql_fetch_object($data)){
$reserveer = htmlspecialchars($row1->res);
$resnaam = htmlspecialchars($row1->naam);
$date1 = ($row1->les1);
$date2 = ($row1->les2);
$date3 = ($row1->les3);
$date4 = ($row1->les4);
$date5 = ($row1->les5);
}
$originalDate = "$date1";
$newDate1 = date("d-m-Y", strtotime($date1));
//in de admintabel de ingevoerde data ophalen (dus ook het maximale aantal deelnemers en het huidig aantal ingeschreven)
/*$sql = mysql_query("SELECT MAX(rev) FROM adminsres");
$row = mysql_fetch_object($sql);
$rev = ($row->rev);*/
$lesdata = mysql_query("SELECT * FROM adminsres WHERE rev = '1' ") or die(mysql_error());
$rij = mysql_fetch_object($lesdata);
$les1a = ($rij->date1a);
$les1b = ($rij->date1b);
$les2a = ($rij->date2a);
$les2b = ($rij->date2b);
$les3a = ($rij->date3a);
$les3b = ($rij->date3b);
$les4a = ($rij->date4a);
$les4b = ($rij->date4b);
$les5a = ($rij->date5a);
$les5b = ($rij->date5b);
$max = ($rij->maxi);
$aantal_1a = ($rij->aantal_1a);
$aantal_1b = ($rij->aantal_1b);
$aantal_2a = ($rij->aantal_2a);
$aantal_2b = ($rij->aantal_2b);
$aantal_3a = ($rij->aantal_3a);
$aantal_3b = ($rij->aantal_3b);
$aantal_4a = ($rij->aantal_4a);
$aantal_4b = ($rij->aantal_4b);
$aantal_5a = ($rij->aantal_5a);
$aantal_5b = ($rij->aantal_5b);
// datum omzetten
$newles1a = date("d-m-Y", strtotime($les1a));
$newles1b = date("d-m-Y", strtotime($les1b));
$newles2a = date("d-m-Y", strtotime($les2a));
$newles2b = date("d-m-Y", strtotime($les2b));
$newles3a = date("d-m-Y", strtotime($les3a));
$newles3b = date("d-m-Y", strtotime($les3b));
$newles4a = date("d-m-Y", strtotime($les4a));
$newles4b = date("d-m-Y", strtotime($les4b));
$newles5a = date("d-m-Y", strtotime($les5a));
$newles5b = date("d-m-Y", strtotime($les5b));
//als verzenden wordt geklikt:
if(isset($_POST['submit'])) {
include('getles.php'); //getles.php haalt de gegevens op die gemaakt zijn met de keuzerondjes
$sql = "UPDATE userres SET
les1 = '$keuze1',
les2 = '$keuze2',
les3 = '$keuze3',
les4 = '$keuze4',
les5 = '$keuze5',
res = '1'
WHERE id='".$_SESSION['user_id']."'";
$query = mysql_query($sql);
if($query == TRUE){
$update = "UPDATE adminsres SET
aantal_1a = '$aantal_1a',
aantal_1b = '$aantal_1b',
aantal_2a = '$aantal_2a',
aantal_2b = '$aantal_2b',
aantal_3a = '$aantal_3a',
aantal_3b = '$aantal_3b',
aantal_4a = '$aantal_4a',
aantal_4b = '$aantal_4b',
aantal_5a = '$aantal_5a',
aantal_5b = '$aantal_5b' WHERE rev = '1' ";
mysql_query($update) or die(mysql_error());
echo '<p>Uw voorkeuren zijn opgeslagen.</p>';
}else{
echo '<p>Er is een fout opgetreden. Neem contact op met de beheerder.</p>';
}
//als wijzigen wordt geklikt:
}elseif (isset($_POST['change'])){
include('getles.php'); //getles.php haalt de gegevens op die gemaakt zijn met de keuzerondjes
$gewijzigd = date("Y-m-d");
$sql = "UPDATE userres SET
les1 = '$keuze1',
les2 = '$keuze2',
les3 = '$keuze3',
les4 = '$keuze4',
les5 = '$keuze5',
res = res+1,
gewijzigd = '$gewijzigd'
WHERE id='".$_SESSION['user_id']."'";
$query = mysql_query($sql) or die(mysql_error());
if($query == TRUE){
$update = "UPDATE adminsres SET
aantal_1a = '$aantal_1a',
aantal_1b = '$aantal_1b',
aantal_2a = '$aantal_2a',
aantal_2b = '$aantal_2b',
aantal_3a = '$aantal_3a',
aantal_3b = '$aantal_3b',
aantal_4a = '$aantal_4a',
aantal_4b = '$aantal_4b',
aantal_5a = '$aantal_5a',
aantal_5b = '$aantal_5b' WHERE rev = '1' ";
mysql_query($update) or die(mysql_error());
header('Refresh: 1; URL= /lesres.php');
echo '<p>Uw keuze is gewijzigd.</p>';
}else{
echo '<p>Er is een fout opgetreden. Neem contact op met de beheerder.</p>';
}
}else{
// Form
?>
<h2>Reservering van herhalingslessen</h2>
<div> </div>
<form method="post" action="lesres.php">
<table>
<tr>
<?php
echo'<td><label>Les 1:</label></td><td><input value="1a" type="radio" name="les1" ';
if ($aantal_1a >= $max) {
echo 'disabled';
}
if ($les1a == $date1){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_1a < $max) {
echo $newles1a;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<?php
echo'<td><label> </label></td><td><input value="1b" type="radio" name="les1" ';
if ($aantal_1b >= $max) {
echo 'disabled';
}
if ($les1b == $date1){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_1b < $max) {
echo $newles1b;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<?php
echo'<td><label>Les 2:</label></td><td><input value="2a" type="radio" name="les2" ';
if ($aantal_2a >= $max) {
echo 'disabled';
}
if ($les2a == $date2){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_2a < $max) {
echo $newles2a;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<?php
echo'<td><label> </label></td><td><input value="2b" type="radio" name="les2" ';
if ($aantal_2b >= $max) {
echo 'disabled';
}
if ($les2b == $date2){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_2b < $max) {
echo $newles2b;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<?php
echo'<td><label>Les 3:</label></td><td><input value="3a" type="radio" name="les3" ';
if ($aantal_3a >= $max) {
echo 'disabled';
}
if ($les3a == $date3){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_3a < $max) {
echo $newles3a;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<?php
echo'<td><label> </label></td><td><input value="3b" type="radio" name="les3" ';
if ($aantal_3b >= $max) {
echo 'disabled';
}
if ($les3b == $date3){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_3b < $max) {
echo $newles3b;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<?php
echo'<td><label>Les 4:</label></td><td><input value="4a" type="radio" name="les4" ';
if ($aantal_4a >= $max) {
echo 'disabled';
}
if ($les4a == $date4){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_4a < $max) {
echo $newles4a;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<?php
echo'<td><label> </label></td><td><input value="4b" type="radio" name="les4" ';
if ($aantal_4b >= $max) {
echo 'disabled';
}
if ($les4b == $date4){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_4b < $max) {
echo $newles4b;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<?php
echo'<td><label>Les 5:</label></td><td><input value="5a" type="radio" name="les5" ';
if ($aantal_5a >= $max) {
echo 'disabled';
}
if ($les5a == $date5){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_5a < $max) {
echo $newles5a;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<?php
echo'<td><label> </label></td><td><input value="5b" type="radio" name="les5" ';
if ($aantal_5b >= $max) {
echo 'disabled';
}
if ($les5b == $date5){
echo ' checked />';
}else{
echo ' />';}
if ($aantal_5b < $max) {
echo $newles5b;
}else{
echo 'Vol';}
?>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<?php
echo '<input ';
if($reserveer > '0') {
echo 'type="submit" value="Wijzigen" id="change" name="change" />';
}else{
echo 'type="submit" value="Verzenden" id="submit" name="submit" />';
}
?>
</td>
<td>
<input type="reset" value="Annuleren" name="reset" />
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</form>
<?php
}
include('footer.inc.php');
?>