60*$_SESSION['timeout']) { include("include/login.php"); } else $_SESSION['last_load_time'] = $load_time; } // check if url variables are set, otherwise set reasonable defaults and reload $reload = 0; $http_get = ""; $week_options = gen_week_select($_GET['week'], 1, &$week); $http_get['week'] = "$week"; $grp2vak_select = sprint_grp2vak_select($_GET['grp2vak_id'], " onchange=\"document.select.doelgroep[1].checked = true; document.select.submit();\"", &$grp2vak_id, 0); if ($grp2vak_select) { if ($_GET['doelgroep'] == "lesgroep") { $doelgroep = "lesgroep"; } else if ($_GET['doelgroep'] == 'leerling') { $doelgroep = "leerling"; } else { $doelgroep = "zelf"; } if ($_SESSION['type'] == 'ouder') $lln_options = sprint_leerling_select($_GET['lln'], " onchange=\"document.select.submit();\"", &$lln_id, 0, $grp2vak_id); else $lln_options = sprint_leerling_select($_GET['lln'], " onchange=\"document.select.doelgroep[2].checked = true; document.select.submit();\"", &$lln_id, 0, $grp2vak_id); if ($lln_options) { $http_get['doelgroep'] = $doelgroep; $http_get['grp2vak_id'] = $grp2vak_id; $http_get['lln'] = $lln_id; } else { if ($doelgroep == 'leerling') { $reload = 1; } $doelgroep = 'lesgroep'; $http_get['grp2vak_id'] = $grp2vak_id; $http_get['doelgroep'] = 'lesgroep'; } } else { if ($_GET['doelgroep'] != 'zelf') { $reload = 1; } $doelgroep = 'zelf'; $http_get['doelgroep'] = 'zelf'; } if ($_SESSION['type'] == 'ouder' && $doelgroep != 'leerling' && $lln_options) { $doelgroep = 'leerling'; $http_get['doelgroep'] = 'leerling'; $reload = 1; } if ($reload == 1) { $send = "?"; foreach ($http_get as $key => $value) { $send .= "$key=$value&"; } $send = substr($send, 0, strlen($send) - 1); header("Location: index.php$send"); exit; } if ($_SESSION['type'] == 'ouder') { $doelgroep = 'leerling'; if (!$lln_options) { header('Location: ouder_auth_request.php'); exit; } } mysql_query_safe("SET SESSION group_concat_max_len = 65536"); $no_issues = sprint_singular(<<[', tag, '] sluiten') issue, notities.notitie_id FROM agenda JOIN ppl2agenda AS lln2agenda USING (agenda_id) JOIN ppl2agenda AS doc2agenda USING (agenda_id) JOIN notities USING (notitie_id) JOIN tags2notities USING (notitie_id) JOIN tags USING (tag_id) JOIN notities AS parent ON parent.notitie_id = notities.parent_id JOIN agenda AS p_agenda ON p_agenda.notitie_id = parent.notitie_id LEFT JOIN grp2vak2agenda ON grp2vak2agenda.agenda_id = p_agenda.agenda_id LEFT JOIN grp2vak USING (grp2vak_id) LEFT JOIN vak USING (vak_id) WHERE lln2agenda.ppl_id = '$lln_id' AND doc2agenda.ppl_id = {$_SESSION['ppl_id']} AND notities.text IS NULL EOQ ); while ($row = mysql_fetch_row($this_issues)) { $issues_friendly .= ''.$row[0].' '.$row[1].'
'; $issues_links[$row[0] - 1] = ' '.$row[0].''; } $lln_naam = sprint_singular("SELECT KB_NAAM(naam0, naam1, naam2) FROM ppl WHERE ppl_id = '$lln_id'"); } $plus_end = "$common\">+"; $grp_id = NULL; switch ($doelgroep) { case 'zelf'; $plus_start =<<(', cijfer, ')')) text, notities.notitie_id, NULL action_name, NULL action_id, NULL dont, tags2notities.tag_id, 1 grp, 0 edit FROM notities JOIN agenda USING (notitie_id) JOIN grp2vak2agenda USING (agenda_id) JOIN grp2vak USING (grp2vak_id) JOIN grp USING (grp_id) LEFT JOIN vak USING (vak_id) LEFT JOIN tags2notities USING (notitie_id) JOIN ppl2grp USING (grp_id) LEFT JOIN doc2grp2vak ON doc2grp2vak.grp2vak_id = grp2vak.grp2vak_id AND doc2grp2vak.ppl_id = {$_SESSION['ppl_id']} LEFT JOIN cijfers ON notities.notitie_id = cijfers.notitie_id AND cijfers.ppl_id = '{$_SESSION['ppl_id']}' WHERE ppl2grp.ppl_id = {$_SESSION['ppl_id']} AND agenda.week = '$week' AND agenda.schooljaar = '$schooljaar' AND doc2grp2vak.ppl_id IS NULL GROUP BY notitie_id, tag_id UNION SELECT bla0.dag, bla0.lesuur, target, bla0.text, bla0.notitie_id, action_name, action_id, GROUP_CONCAT(CONCAT(bla.agenda_id, '-', tags2children.tag_id)) dont, tags2notities.tag_id, 0 grp, edit FROM ( SELECT notitie_id, text, agenda.dag, agenda.lesuur, agenda.agenda_id, CONCAT(GROUP_CONCAT(IF(corro.type != 'leerling', corro.login, KB_NAAM(corro.naam0, corro.naam1, corro.naam2)) COLLATE utf8_unicode_ci), ': ') target, ppl2agenda.allow_edit edit FROM notities JOIN agenda USING (notitie_id) JOIN ppl2agenda USING (agenda_id) LEFT JOIN ppl2agenda AS corro2agenda ON corro2agenda.agenda_id = agenda.agenda_id LEFT JOIN ppl AS corro ON corro2agenda.ppl_id = corro.ppl_id AND corro.ppl_id != {$_SESSION['ppl_id']} WHERE ppl2agenda.ppl_id = {$_SESSION['ppl_id']} AND agenda.week = '$week' AND agenda.schooljaar = '$schooljaar' GROUP BY notitie_id ) AS bla0 LEFT JOIN tags2notities USING (notitie_id) LEFT JOIN tags2actions USING (tag_id) LEFT JOIN actions USING (action_id) LEFT JOIN ppl2agenda AS targets ON bla0.agenda_id = targets.agenda_id AND targets.allow_edit = 0 LEFT JOIN notities AS children ON bla0.notitie_id = children.parent_id LEFT JOIN agenda AS c_agenda ON children.notitie_id = c_agenda.notitie_id LEFT JOIN tags2notities AS tags2children ON children.notitie_id = tags2children.notitie_id AND actions.new_tag_id = tags2children.tag_id LEFT JOIN ppl2agenda AS bla ON c_agenda.agenda_id = bla.agenda_id AND bla.ppl_id = targets.ppl_id GROUP BY bla0.notitie_id, tags2notities.tag_id, action_id EOQ; break; case 'leerling'; $plus_start =<<(', cijfer, ')')) text, notities.notitie_id, action_name, action_id, GROUP_CONCAT(CONCAT(bla.agenda_id, '-', tags2children.tag_id)) dont, tags2notities.tag_id, 1 grp, IF(auth.ppl_id, 1, 0) edit FROM notities JOIN agenda USING (notitie_id) JOIN grp2vak2agenda USING (agenda_id) JOIN grp2vak USING (grp2vak_id) JOIN grp USING (grp_id) LEFT JOIN vak USING (vak_id) LEFT JOIN tags2notities USING (notitie_id) JOIN ppl2grp USING (grp_id) LEFT JOIN doc2grp2vak ON doc2grp2vak.grp2vak_id = grp2vak.grp2vak_id AND doc2grp2vak.ppl_id = '$lln_id' LEFT JOIN doc2grp2vak AS auth ON auth.grp2vak_id = grp2vak.grp2vak_id AND auth.ppl_id = {$_SESSION['ppl_id']} LEFT JOIN tags2actions USING (tag_id) LEFT JOIN actions USING (action_id) LEFT JOIN notities AS children ON notities.notitie_id = children.parent_id LEFT JOIN agenda AS c_agenda ON children.notitie_id = c_agenda.notitie_id LEFT JOIN tags2notities AS tags2children ON children.notitie_id = tags2children.notitie_id AND actions.new_tag_id = tags2children.tag_id LEFT JOIN ppl2agenda AS bla ON c_agenda.agenda_id = bla.agenda_id AND bla.ppl_id = '$lln_id' LEFT JOIN cijfers ON notities.notitie_id = cijfers.notitie_id AND cijfers.ppl_id = '$lln_id' WHERE ppl2grp.ppl_id = '$lln_id' AND agenda.week = '$week' AND agenda.schooljaar = '$schooljaar' AND doc2grp2vak.ppl_id IS NULL GROUP BY notitie_id, tag_id, action_id UNION SELECT bla0.dag, bla0.lesuur, target, bla0.text, bla0.notitie_id, action_name, action_id, GROUP_CONCAT(CONCAT(bla.agenda_id, '-', tags2children.tag_id)) dont, tags2notities.tag_id, 0 grp, edit FROM ( SELECT notitie_id, text, agenda.dag, agenda.lesuur, agenda.agenda_id, CONCAT(GROUP_CONCAT(IF(corro.type != 'leerling', corro.login, KB_NAAM(corro.naam0, corro.naam1, corro.naam2)) COLLATE utf8_unicode_ci), ': ') target, auth.allow_edit edit FROM notities JOIN agenda USING (notitie_id) JOIN ppl2agenda USING (agenda_id) LEFT JOIN ppl2agenda AS corro2agenda ON corro2agenda.agenda_id = agenda.agenda_id LEFT JOIN ppl AS corro ON corro2agenda.ppl_id = corro.ppl_id AND corro.ppl_id != '$lln_id' LEFT JOIN ppl2agenda AS auth ON agenda.agenda_id = auth.agenda_id AND auth.ppl_id = {$_SESSION['ppl_id']} WHERE ppl2agenda.ppl_id = '$lln_id' AND agenda.week = '$week' AND agenda.schooljaar = '$schooljaar' GROUP BY notitie_id ) AS bla0 LEFT JOIN tags2notities USING (notitie_id) LEFT JOIN tags2actions USING (tag_id) LEFT JOIN actions USING (action_id) LEFT JOIN ppl2agenda AS targets ON bla0.agenda_id = targets.agenda_id AND targets.allow_edit = 0 LEFT JOIN notities AS children ON bla0.notitie_id = children.parent_id LEFT JOIN agenda AS c_agenda ON children.notitie_id = c_agenda.notitie_id LEFT JOIN tags2notities AS tags2children ON children.notitie_id = tags2children.notitie_id AND actions.new_tag_id = tags2children.tag_id LEFT JOIN ppl2agenda AS bla ON c_agenda.agenda_id = bla.agenda_id AND bla.ppl_id = targets.ppl_id GROUP BY bla0.notitie_id, tags2notities.tag_id, action_id EOQ; break; case 'lesgroep'; $grp_id = sprint_singular("SELECT grp_id FROM grp2vak WHERE grp2vak_id = $grp2vak_id"); $plus_start =<<= 8 && $datumtt[0] != $year_firsthalf)) continue; $weekdag = date('w', mktime(0, 0, 0, $datumtt[1], $datumtt[2], $datumtt[0])); $ttinfo[$weekdag] .= strtolower($vakaf[1]).': '.$val['sa'].'
'; //echo($val['sd'].' '.strtolower($vakaf[1]).': '.$val['sa'].'
'); //print_r($val); echo("
\n"); } } } $testresult = mysql_query_safe(<<', IFNULL(target, ''), IFNULL(bla3.text, ''), IFNULL(GROUP_CONCAT(tags SEPARATOR ''), ''), IF(edit, CONCAT( '\n', KB_LINK( IF(grp, 'vvv.php', 'vvv_zelf.php'), notitie_id, dag, lesuur, '$common', 'V')), ''), '') text, notitie_id, 1 edit, grp FROM ( SELECT dag, lesuur, target, text, edit, IFNULL(CONCAT( '\n[', tag, IF(GROUP_CONCAT(dont) IS NOT NULL OR edit = 0 OR edit IS NULL, '', IFNULL(CONCAT( '\n', GROUP_CONCAT(KB_LINK( 'do_action.php', notitie_id, dag, lesuur, CONCAT( '&action_id=', action_id, '&isgrp=', grp, '$common'), action_name) SEPARATOR '/')), '') ), ']'), '') tags, notitie_id, grp FROM ( $inner_query ) bla2 LEFT JOIN tags USING (tag_id) GROUP BY notitie_id, tag_id ) AS bla3 GROUP BY notitie_id ) AS bla4 GROUP BY lesuur, dag EOT ); //if ($_SESSION['type'] == 'leerling' && $_SESSION['teletop_session']) { // $ch = curl_teletop_init(); // $data = curl_teletop_req($ch, '/tt/abvo/updates.nsf/a-SearchRosterRows?OpenAgent&rand='.rand(0,99999998), '&sw='.$week.'&sa=1&ug='.$row['naam'], // array('X-Requested-With: XMLHttpRequest')); //echo('test
'); //} function print_dag($dag) { switch ($dag) { case 0: return 'zo'; case 1: return 'ma'; case 2: return 'di'; case 3: return 'wo'; case 4: return 'do'; case 5: return 'vr'; case 6: return 'za'; } } function print_rev($time, $rev = 0) { return 'r'.$rev.' '.date('W', $time).print_dag(date('w', $time)).date('G:i', $time); } function print_diff($row) { $bla = array(); if ($row['f_dag'] != $row['s_dag'] || $row['f_uur'] != $row['s_uur']) $bla[] = print_dag($row['s_dag']).$row['s_uur']; if ($row['f_lesgroepen'] != $row['s_lesgroepen']) $bla[] = $row['s_lesgroepen']; if ($row['f_vakken'] != $row['s_vakken']) $bla[] = $row['s_vakken']; if ($row['f_docenten'] != $row['s_docenten']) $bla[] = $row['s_docenten']; if ($row['f_lokalen'] != $row['s_lokalen']) $bla[] = $row['s_lokalen']; return implode('/', $bla); } $wijz_id = sprint_singular("SELECT MAX(rooster_id) FROM roostertest.weken2roosters JOIN roostertest.weken USING (week_id) WHERE week = $week"); if ($wijz_id) { $basis_id = sprint_singular("SELECT MAX(rooster_id) FROM roostertest.weken2roosters JOIN roostertest.weken USING (week_id) WHERE wijz_id = 0 AND week = $week"); } else { $wijz_id = $basis_id = sprint_singular("SELECT MAX(rooster_id) FROM roostertest.weken2roosters WHERE week_id < ( SELECT week_id FROM roostertest.weken WHERE week = $week ) AND wijz_id = 0"); } if (!$basis_id) { $roosterstatus = 'GEEN'; goto out; // geen rooster } $result4 = mysql_query_safe("SELECT basis_id, wijz_id, timestamp FROM roostertest.weken2roosters JOIN roostertest.weken USING (week_id) WHERE rooster_id = $wijz_id"); $test = mysql_fetch_row($result4); $roosterstatus = print_rev($test[2], $test[0].','.$test[1]); if ($basis_id == $wijz_id) $wijz_id = 0; function rquery_inner($where, $id1, $id2, $wijz) { return <<

week: som 0 && $_SESSION['type'] == 'personeel') echo(" Je hebt $no_issues openstaande issues."); ?>

leerling: klik hier om een broer(tje)/zus(je) toe te voegen

doelgroep: value="zelf" onclick="document.select.submit()">zelf value="lesgroep" onclick="document.select.submit()">groep value="leerling" onclick="document.select.submit()">leerling

Je hebt 1 openstaand issue openstaande issues met .

'); if (is_array($row) && $row[0] == $j && $row[1] == $i) { echo($row[2]); $row = mysql_fetch_row($testresult); } $dayanduur = $j.'&lesuur='.$i; echo($plus_start.$dayanduur.$plus_end); if (is_array($issues_links)) foreach ($issues_links as $value) echo(sprintf($value, $dayanduur)); while (is_array($rosterrow) && $rosterrow['f_dag'] == $j && $rosterrow['f_uur'] == $i) { $extra = ''; $text = ''; if ($rosterrow['s_zermelo_id'] && !$rosterrow['s_dag'] && $rosterrow['wijz']) $extra = ' uitval'; else if (!$rosterrow['s_zermelo_id'] && !$rosterrow['wijz']) $extra = ' extra'; else if ($rosterrow['f_dag'] == $rosterrow['s_dag'] && $rosterrow['f_uur'] == $rosterrow['s_uur'] && $rosterrow['vis']) { // les is niet in tijd verplaatst, maar wel gewijzigd, beide zijn zichtbaar if ($rosterrow['wijz']) { // dit is de oude les, skip $rosterrow = mysql_fetch_array($result4); continue; } else if ( $rosterrow['f_vakken'] != $rosterrow['s_vakken'] || $rosterrow['f_docenten'] != $rosterrow['s_docenten'] || $rosterrow['f_lokalen'] != $rosterrow['s_lokalen'] || $rosterrow['f_lesgroepen'] != $rosterrow['s_lesgroepen']) { $extra = ' gewijzigd'; $text = ' <- '.print_diff($rosterrow); } } else if ($rosterrow['wijz'] && $rosterrow['s_zermelo_id']) { $text = ' -> '.print_diff($rosterrow); $extra = ' verplaatstnaar'; } else if (!$rosterrow['wijz'] && $rosterrow['s_zermelo_id']) { $text = ' <- '.print_diff($rosterrow); $extra = ' verplaatstvan'; } $info = array(); if ($rostertype != 1) { $grp_naam = NULL; if ($rosterrow['f_grp_naam']) { if ($grp_id != $rosterrow['f_grp_id']) $grp_naam = $rosterrow['f_grp_naam']; //$info[] = $rosterrow['f_grp_naam'].'('.$rosterrow['f_grp_id'].')'; } else if ($rosterrow['f_lesgroepen']) $grp_naam = $rosterrow['f_lesgroepen']; if ($grp_naam) $info[] = $grp_naam; // check of het vak al in de naam van de lesgroep zit if (!$grp_naam || !preg_match("/{$rosterrow['f_vakken']}[0-9]?/i", $grp_naam)) $info[] = $rosterrow['f_vakken']; } else if ($rosterrow['f_vakken']) $info[] = $rosterrow['f_vakken']; if ($rostertype != 2) if ($rosterrow['f_docenten']) $info[] = $rosterrow['f_docenten']; if ($rosterrow['f_lokalen']) $info[] = $rosterrow['f_lokalen']; echo(' '.implode('/', $info).$text.''); //print_r($rosterrow); $rosterrow = mysql_fetch_array($result4); } } } if ($ttinfo) { ?>
maandag dinsdag woensdag donderdag vrijdag
'.$i.'' ?>
TT®'.$ttinfo[$j]); } ?>

Persoonlijke notities zijn blauw. Roosterupdate: .