', 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,
period_enddesc afnamemoment,
CONCAT('details') details
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) 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
GROUP BY period_id
ORDER BY period_id
EOQ
);
?>
Actieve inhaal- en/of herkansingssystemen in schooljaar
numRows() == 0) { ?>
Er zijn geen actieve inhaal- en/of herkansingssystemen actief.