';
}
// Iteration för ett antal veckor framöver
for ($i = 0; $i < $sizeOfWeeks; $i++) {
// Sätter start- och slutdatum för veckan som körs igenom
$arrayWeekDates = getDateInWeek($thisWeek, $thisYear);
// Listar efter passtiderna
if ($_GET["view"] != "teachers") {
echo '
"; if ($teacherName != "") echo '
| Veckodag | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Skidlärare | Tid | Gäst | M | Ti | O | To | F | L | S | Åker | Hyr | Övrigt | ||||||||||||
| '; if ($responsibleTeacherFound) echo 'Veckoansvarig: '; echo $teacherName; echo ' | '; $query2 = fmysql_query("SELECT tb.teacherBookingID FROM teachers_booking tb, pass_times p, pass_weeks pw WHERE p.passID=pw.passID AND pw.passWeekID=tb.passWeekID AND tb.teacherID='". $teacherID ."' ORDER BY p.fromTime ASC"); $sumOfBookings = 0; while (list ($teacherBookingID) = mysql_fetch_row($query2)) { $query3 = fmysql_query("SELECT CONCAT(p.fromTime,'-',p.tilTime) passTime, g.guestID, CONCAT(g.firstName,' ',g.lastName) fullName, g.info, gb.fromDate, gb.tilDate FROM pass_times p, pass_weeks pw, guests g, guests_booking gb WHERE gb.teacherBookingID='". $teacherBookingID ."' AND g.guestID=gb.guestID AND p.passID=pw.passID AND pw.passWeekID=gb.passWeekID AND pw.fromDate='". $arrayWeekDates[0] ."' AND pw.tilDate='". $arrayWeekDates[6] ."' ORDER BY gb.fromDate, gb.tilDate"); if (mysql_num_rows($query3) > 0) $sumOfBookings++; while (list ($passTime, $guestID, $guestName, $info, $fromDate, $tilDate) = mysql_fetch_row($query3)) { // Skriver ut pass-tiden om det är första gången den listas, annars visas bara en tom ruta echo '||||||||||||||||||||||||
| '. $passTime .' | '; else echo ''; echo ' | '. $guestName .' | '; // Veckodagarna for ($l = 0; $l < count($arrayWeekDates); $l++) { if (strtotime($arrayWeekDates[$l]) - strtotime($fromDate) >= 0 && strtotime($tilDate) - strtotime($arrayWeekDates[$l]) >= 0) { echo ' | ';
} else {
echo ''; } } // Åker echo ' | '; $query5 = fmysql_query("SELECT r.name FROM rides r, guests_rides gr WHERE r.rideID=gr.rideID AND gr.guestID='". $guestID ."'"); while (list ($rideName) = mysql_fetch_row($query5)) echo $rideName. ', '; echo ' | '. $info .' | '; // För kontroll av passtiden $prevPassTime = $passTime; } } //echo $sumOfBookings; if ($sumOfBookings == 0) for ($n = 0; $n < 12; $n++) echo ''; echo ' | |||||||||||||||||