0 AND datum > " . mktime(0,0,0,12,31,$year - 1) ." ORDER BY datum");
$urenverlof = 0;
$urenafwezig = 0;
$urenziek = 0;
echo "Close
" .$naam. "
" . "\n";
while ($row = mysql_fetch_array($result))
{
echo strftime("%A",$row['datum']) . " " . date("d/m/Y",$row['datum']) . ": " . $row['verlofuren'];
if ($row['V1A2Z3'] == 1)
{
echo " u. verlof
". "\n";
$urenverlof += $row['verlofuren'];
}
else if ($row['V1A2Z3'] == 2)
{
echo " u. afwezig
". "\n";
$urenafwezig += $row['verlofuren'];
}
else if ($row['V1A2Z3'] == 3)
{
echo " u. ziek
". "\n";
$urenziek += $row['verlofuren'];
}
}
echo "
". "\n";
echo "Totaal verlof: " . $urenverlof . " u.
" . "\n";
echo "Totaal afwezig: " . $urenafwezig . " u.
". "\n";
echo "Totaal ziek: " . $urenziek . " u.
". "\n";
echo "
". "\n";
}
echo "";
$starttime = mktime(0,0,0,1,1,$year);
$start = getdate($starttime);
if($start['wday'] == 0)
$offset = 6;
else
$offset = $start['wday'] - 1;
$date = 0;
while ($date < mktime(0,0,0,1,1,$year + 1))
{
echo "";
if($date == 0){
//namen
echo "";
echo "" . "\n";
echo "
";
echo "Edit
" . date("W",$date) . "";
echo "
". "\n";
foreach ($namen as $naam)
{
echo "
";
echo "". $naam ."";
echo "
". "\n";
}
echo "
" . "\n";
echo "
";
echo strftime("%A",$date);
echo "
";
echo date("d/m/Y",$date);
echo "
". "\n";
foreach ($namen as $naam)
{
echo "
";
echo " ";
echo "
". "\n";
}
echo "
" . "\n";
echo "
";
echo "Edit
" . date("W",$date) ."";
echo "
". "\n";
foreach ($namen as $naam)
{
echo "
";
echo "". $naam ."";
echo "
". "\n";
}
echo "
" . "\n";
if ($wday['wday'] != 0 && $wday['wday'] != 6) //geen weekends
echo "
";
else
echo "
";
echo strftime("%A",$date);
echo "
";
echo date("d/m/Y",$date);
echo "
". "\n";
foreach ($namen as $naam)
{
if ($wday['wday'] != 0 && $wday['wday'] != 6) //geen weekends
{
$result = mysql_query("SELECT * FROM planning WHERE naam = '". $naam ."' AND datum = '". $date ."'");
$row = mysql_fetch_array($result);
if ($row['V1A2Z3'] == 1)
echo "
";
else if ($row['V1A2Z3'] == 2)
echo "
";
else if ($row['V1A2Z3'] == 3)
echo "
";
else
echo "
";
echo nl2br($row["tekst"]);
}
else
echo "
";
echo "
". "\n";
}
echo "
" . "\n";
if ($wday['wday'] == 0)
{
$result = mysql_query("SELECT * FROM todo WHERE datum = '". $date ."' LIMIT 1");
$row = mysql_fetch_array($result);
echo "
" . "\n";
echo "
". nl2br($row['tekst']) ."
";
}
$date = strtotime(date("Y-m-d", $date) . " +1 day");
}
}
?>