194 lines
6.5 KiB
PHP
194 lines
6.5 KiB
PHP
<?php
|
|
session_start();
|
|
require('connect.php');
|
|
|
|
if($_SESSION['login']<1) {
|
|
echo false;
|
|
}
|
|
|
|
elseif(isset($_POST['docent']) && $_SESSION['login']>1){
|
|
|
|
$soort = 1;
|
|
$name = reset(explode(',', $_POST['docent']));
|
|
$query = "SELECT LNR.lesuurnr, LNR.lesuur, vak, lokaal, LES.groep
|
|
FROM `lessen` AS LES, `lesuurnr` AS LNR
|
|
WHERE LES.lesuur=LNR.lesuur AND LES.docent = '$name'
|
|
GROUP BY LNR.lesuur
|
|
ORDER BY LNR.lesuurnr";
|
|
}
|
|
|
|
elseif(isset($_POST['leerling']) && $_SESSION['login']>0){
|
|
|
|
$soort = 2;
|
|
if($_SESSION['login']==2){
|
|
$name = reset(explode(',', $_POST['leerling']));
|
|
}
|
|
elseif($_SESSION['login']==1){
|
|
$name = $_SESSION['name'];
|
|
}
|
|
$query = "SELECT LNR.lesuurnr, LNR.lesuur, vak, docent, lokaal
|
|
FROM `adminnr_groep` AS GR, `lessen` AS LES, `lesuurnr` AS LNR
|
|
WHERE GR.groep=LES.groep AND LES.lesuur=LNR.lesuur AND GR.adminnr = $name
|
|
GROUP BY LES.lesuur
|
|
ORDER BY LNR.lesuurnr";
|
|
}
|
|
|
|
elseif(isset($_POST['lokaal']) && $_SESSION['login']>0){
|
|
|
|
$soort = 3;
|
|
$name = reset(explode(',', $_POST['lokaal']));
|
|
$query = "SELECT LNR.lesuurnr, LNR.lesuur, vak, docent, LES.groep
|
|
FROM `lessen` AS LES, `lesuurnr` AS LNR
|
|
WHERE LES.lesuur=LNR.lesuur AND lokaal = '$name'
|
|
GROUP BY LES.lesuur
|
|
ORDER BY LNR.lesuurnr";
|
|
}
|
|
|
|
elseif(isset($_POST['groep']) && $_SESSION['login']>1){
|
|
|
|
$soort = 4;
|
|
$name = reset(explode(',', $_POST['groep']));
|
|
$query = "SELECT LNR.lesuurnr, LNR.lesuur, vak, docent, LES.lokaal
|
|
FROM `lessen` AS LES, `lesuurnr` AS LNR
|
|
WHERE LES.lesuur=LNR.lesuur AND groep = '$name'
|
|
GROUP BY LES.lesuur
|
|
ORDER BY LNR.lesuurnr";
|
|
}
|
|
|
|
elseif( ( isset($_POST['uur']) || isset($_POST['leeglokaal']) ) && $_SESSION['login']>0){
|
|
|
|
$soort = 5;
|
|
if(isset($_POST['uur'])){
|
|
$uur = reset(explode(',', $_POST['uur']));
|
|
$dag = reset(explode(',', $_POST['dag']));
|
|
$name = $dag . $uur;
|
|
}
|
|
else {
|
|
$dag = substr($_POST['leeglokaal'], 0, 2);
|
|
$uur = substr($_POST['leeglokaal'], 2, 1);
|
|
$name = $_POST['leeglokaal'];
|
|
}
|
|
|
|
$query = "SELECT DISTINCT (`lokaal`)
|
|
FROM `lessen` AS LES
|
|
WHERE LES.lesuur = '$name'";
|
|
|
|
$query2 = "SELECT DISTINCT (`lokaal`)
|
|
FROM `lessen`";
|
|
|
|
mysql_query("SET SQL_BIG_SELECTS=1", $connection) or die("An Error Occured 1");
|
|
$result_temp = mysql_query($query, $connection) or die("An Error Occured 2");
|
|
$result_temp2 = mysql_query($query2, $connection) or die("An Error Occured 3");
|
|
|
|
while($result2 = mysql_fetch_array($result_temp2)){
|
|
$lok_alle[] = $result2['lokaal'];
|
|
}
|
|
|
|
while($result = mysql_fetch_array($result_temp)){
|
|
$lok_vrij[] = $result['lokaal'];
|
|
}
|
|
|
|
$lokalen_temp = array_diff($lok_alle, $lok_vrij);
|
|
$lokalen = array_filter($lokalen_temp);
|
|
}
|
|
|
|
else {
|
|
echo false;
|
|
}
|
|
|
|
if( $soort>=1 && $soort <=4 ){
|
|
|
|
mysql_query("SET SQL_BIG_SELECTS=1", $connection) or die("Er is een fout opgetreden bij het ophalen van het rooster (q1)");
|
|
$result_temp = mysql_query($query, $connection) or die("Er is een fout opgetreden bij het ophalen van het rooster (q2)");
|
|
|
|
$uur = 1;
|
|
while($result = mysql_fetch_array($result_temp)){
|
|
while ($uur < $result['lesuurnr']){
|
|
$rooster[$uur] = '<td class="vrij content"> </td>';
|
|
$uur++;
|
|
}
|
|
|
|
if($soort==1){
|
|
$rooster[$uur] = '<td class="les content">' . $result['vak'] . '<br><a href="javascript:setPageValue(\'lokaal/' . $result['lokaal'] . '\')">' . $result['lokaal'] . '</a><br><a href="javascript:setPageValue(\'groep/' . $result['groep'] . '\')">' . $result['groep'] . '</a></td>';
|
|
}
|
|
|
|
if($soort==2){
|
|
$rooster[$uur] = '<td class="les content">' . $result['vak'] . '<br><a href="javascript:setPageValue(\'lokaal/' . $result['lokaal'] . '\')">' . $result['lokaal'] . '</a><br><a href="javascript:setPageValue(\'docent/' . $result['docent'] . '\')">' . $result['docent'] . '</a></td>';
|
|
}
|
|
|
|
if($soort==3){
|
|
$rooster[$uur] = '<td class="les content">' . $result['vak'] . '<br><a href="javascript:setPageValue(\'groep/' . $result['groep'] . '\')">' . $result['groep'] . '</a><br><a href="javascript:setPageValue(\'docent/' . $result['docent'] . '\')">' . $result['docent'] . '</a></td>';
|
|
}
|
|
|
|
if($soort==4){
|
|
$rooster[$uur] = '<td class="les content">' . $result['vak'] . '<br><a href="javascript:setPageValue(\'lokaal/' . $result['lokaal'] . '\')">' . $result['lokaal'] . '</a><br><a href="javascript:setPageValue(\'docent/' . $result['docent'] . '\')">' . $result['docent'] . '</a></td>';
|
|
}
|
|
|
|
$uur++;
|
|
}
|
|
while($uur <= 40){
|
|
$rooster[$uur] = '<td class="vrij content"> </td>';
|
|
$uur++;
|
|
}
|
|
|
|
if(($soort==1 || $soort==2) && $_SESSION['login']>1){
|
|
echo "Het rooster voor <a href='javascript: return false;' onclick=setPageValue('account/$name')>" . $name . "</a>";
|
|
}
|
|
else{
|
|
echo 'Het rooster voor ' . $name;
|
|
}
|
|
?>
|
|
|
|
<table class='rooster' cellspacing=0>
|
|
<tr>
|
|
<td class='corner header'></td><td class='dag header'>Maandag</td><td class='dag header'>Dinsdag</td><td class='dag header'>Woensdag</td><td class='dag header'>Donderdag</td><td class='dag header'>Vrijdag</td>
|
|
</tr><tr>
|
|
<td class='uur header'>1</td>
|
|
<?php echo $rooster[1] . $rooster[9] . $rooster[17] . $rooster[25] . $rooster[33]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>2</td>
|
|
<?php echo $rooster[2] . $rooster[10] . $rooster[18] . $rooster[26] . $rooster[34]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>3</td>
|
|
<?php echo $rooster[3] . $rooster[11] . $rooster[19] . $rooster[27] . $rooster[35]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>4</td>
|
|
<?php echo $rooster[4] . $rooster[12] . $rooster[20] . $rooster[28] . $rooster[36]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>5</td>
|
|
<?php echo $rooster[5] . $rooster[13] . $rooster[21] . $rooster[29] . $rooster[37]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>6</td>
|
|
<?php echo $rooster[6] . $rooster[14] . $rooster[22] . $rooster[30] . $rooster[38]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>7</td>
|
|
<?php echo $rooster[7] . $rooster[15] . $rooster[23] . $rooster[31] . $rooster[39]; ?>
|
|
</tr><tr>
|
|
<td class='uur header'>8</td>
|
|
<?php echo $rooster[8] . $rooster[16] . $rooster[24] . $rooster[32] . $rooster[40]; ?>
|
|
</tr>
|
|
</table>
|
|
|
|
<?php
|
|
}
|
|
elseif($soort == 5){ ?>
|
|
<h3>De volgende lokalen zijn op <?php echo $dag; ?> het <?php echo $uur; ?>e uur vrij:</h3><br>
|
|
|
|
<table width='600px'>
|
|
<tr>
|
|
|
|
<?php
|
|
$i = 1;
|
|
foreach ($lokalen as $key => $value) {
|
|
echo '<td><a href="javascript:setPageValue(\'lokaal/' . $value . '\')">' . $value . '</a></td>';
|
|
if($i%8==0){echo "</tr><tr>"; }
|
|
$i++;
|
|
} ?>
|
|
|
|
</tr></table>
|
|
<?php
|
|
}
|
|
else{
|
|
echo false;
|
|
}
|
|
?>
|