', url, '') link, CONCAT('',
CASE
WHEN deadline_weekday = 0 THEN 'zondag'
WHEN deadline_weekday = 1 THEN 'maandag'
WHEN deadline_weekday = 2 THEN 'dinsdag'
WHEN deadline_weekday = 3 THEN 'woensdag'
WHEN deadline_weekday = 4 THEN 'donderdag'
WHEN deadline_weekday = 5 THEN 'vrijdag'
WHEN deadline_weekday = 6 THEN 'zaterdag'
END, ' ',
deadline_monthday, ' ',
CASE
WHEN deadline_month = 1 THEN 'januari'
WHEN deadline_month = 2 THEN 'februari'
WHEN deadline_month = 3 THEN 'maart'
WHEN deadline_month = 4 THEN 'april'
WHEN deadline_month = 5 THEN 'mei'
WHEN deadline_month = 6 THEN 'juni'
WHEN deadline_month = 7 THEN 'juli'
WHEN deadline_month = 8 THEN 'augustus'
WHEN deadline_month = 9 THEN 'september'
WHEN deadline_month = 10 THEN 'oktober'
WHEN deadline_month = 11 THEN 'november'
WHEN deadline_month = 12 THEN 'december'
END, ' ', deadline_time, ''
) deadline, GROUP_CONCAT(CONCAT(afd_leerjr, UPPER(afd_target), ': ', groepen) ORDER BY afd_leerjr, CASE WHEN afd_target = 'm' THEN 1 WHEN afd_target = 'h' THEN 2 WHEN afd_target = 'ah' THEN 3 WHEN afd_target = 'a' THEN '4' WHEN afd_target = 'vp' THEN 5 WHEN afd_target = 'v' THEN 6 END SEPARATOR '
') afdelingen, period_enddesc afnamemoment FROM (
SELECT year_id, period_desc, period_deadline, period_enddesc,
FROM_UNIXTIME(period_deadline, '%%w') deadline_weekday,
FROM_UNIXTIME(period_deadline, '%%e') deadline_monthday,
FROM_UNIXTIME(period_deadline, '%%c') deadline_month,
FROM_UNIXTIME(period_deadline, '%%H:%%i') deadline_time,
CONCAT('https://her.ovc.nl/', config_target, '/') url, period_id, afd_id, GROUP_CONCAT(grp_name ORDER BY grp_name SEPARATOR ', ') groepen
FROM periods
JOIN (
SELECT config_target, config_value AS period_id
FROM config
WHERE config_key = 'PERIODE_ID'
AND config_target != 'test'
) AS cfg USING (period_id)
JOIN period2grp USING (period_id)
JOIN $kldv.grp USING (grp_id)
JOIN $kldv.year2afd2grp USING (year_id, grp_id)
GROUP BY period_id, afd_id
) AS groepen
JOIN $kldv.afds USING (afd_id)
WHERE year_id = $year_id AND period_id = %i
GROUP BY period_id
ORDER BY period_id
EOQ
, $_GET['period_id']);
if ($ret->numRows() == 0) {
header('Content-type: text/plain');
echo("illegal period_id");
exit;
}
$row = $ret->fetchrow(MDB2_FETCHMODE_ASSOC);
$maxflags = mdb2_query($db, <<'),
'geen toetsen gekoppeld') AS toetsen
FROM period2maxflags
LEFT JOIN (
SELECT period2maxflags_id, flags, max,
CONCAT(pta_leerjr, target, '.', sy, '/', CASE WHEN inhaalregime = 0 THEN 'TP' ELSE 'per' END,
pta_tp, ': ', GROUP_CONCAT(CONCAT(subj_abbrev, ' ', info)
ORDER BY subj_abbrev, info SEPARATOR ', ')) stuff
FROM period2maxflags
LEFT JOIN (
SELECT inhaalregime, pta_tp, subj_abbrev, CONCAT(stvt, shortdesc) info, pta_leerjr, pta_target target, flags sflags, CONCAT(SUBSTRING(year_long, 3, 2), SUBSTRING(year_long, 8, 2)) sy, pta_leerjr - ( SUBSTRING(year_long, 6, 4) - ( SELECT SUBSTRING(year_long, 6, 4) FROM kldv.years WHERE year_id = $year_id ) ) AS leerjr, year_id
FROM ptas
JOIN $kldv.subj USING (subj_id)
JOIN $kldv.years USING (year_id)
JOIN (
SELECT * FROM period2selectable WHERE period_id = %i
) AS tmp USING (pta_id)
) AS current USING (leerjr, target)
WHERE period_id = %i AND flags & sflags
GROUP BY pta_tp, inhaalregime, period2maxflags_id
) AS tmp2 USING (period2maxflags_id)
LEFT JOIN $kldv.targets USING (target)
WHERE period_id = %i
GROUP BY period2maxflags_id
ORDER BY leerjr, target_order, aantal
EOQ
, $_GET['period_id'], $_GET['period_id'], $_GET['period_id']);
$period_id = mdb2_single_val($db, "SELECT period_id FROM periods WHERE period_id = %i", $_GET['period_id']);
$deadline = mdb2_single_val($db, "SELECT period_deadline FROM periods WHERE period_id = $period_id");
?>
Informatie over herkansings- en/of inhaalmoment: .
Inschrijflink: .
Deadline: .
Afnamemoment: .
Deelnemende klassen per afdeling:
numRows() == 0) { ?>
In dit systeem kunnen de leerlingen zelf geen toetsen opgeven. Leerlingen kunnen wel inloggen om te kijken voor welke toetsen ze ingeschreven zijn.
Toetsen en bijbehorende aantallen die door leerlingen kunnen worden opgegeven per afdeling.