include('phplib/phplib.php');
include('common.php');
$db = mdb2_open($dsn);
$herinfo = get_herinfo($db);
if ($herinfo['period_regime'] != 8) {
header('Content-type: text/plain;charset=UTF-8');
echo("period_regime is legacy, rules.php does not support legacy period regimes");
}
if (!isset($_GET['leerjaartarget'])) {
html_start('', 'Regels');
echo(mdb2_single_val($db, "SELECT GROUP_CONCAT(DISTINCT CONCAT('', CONCAT(leerjr, target), '') ORDER BY leerjr, target) FROM period2maxflags WHERE period_id = {$herinfo['period_id']}"));
html_end();
exit;
}
$rules = mdb2_all_assoc_rekey($db, "SELECT * FROM period2maxflags WHERE period_id = {$herinfo['period_id']} AND CONCAT(leerjr, target) = '%q'", $_GET['leerjaartarget']);
if (count($rules) == 0) {
html_start('', 'Regels');
html_start('', 'Regels'); ?>
Regels
echo('De afdeling '.htmlenc($_GET['leerjaartarget'].' is deze periode '.$herinfo['period_desc'].' ('.$herinfo['year_long'].') onbekend in het herkansingssysteem.'));
html_end();
exit;
}
/*
if (count($rules) == 1) {
html_start('', 'Regels');
?>Regels
foreach ($rules as $rule_id => $rule) {
echo('Leerlingen uit '.htmlenc($_GET['leerjaartarget']).' mogen maximaal '.$rule['max'].' toets(en) opgeven uit de onderstaande lijst: '.mdb2_single_val($db, <<
Regels
De opgave van leerlingen uit =htmlenc($_GET['leerjaartarget'])?> moet voldoen aan de onderstaande eis=(count($rules) == 1?'':'en')?>:
foreach ($rules as $rule_id => $rule) {
echo('Maximaal '.$rule['max'].' toets'.(($rule['max'] > 1)?'en':'').' uit:
'.mdb2_single_val($db, <<')
FROM period2selectable
JOIN ptas USING (pta_id)
JOIN $kldv.years USING (year_id)
WHERE period_id = {$herinfo['period_id']}
AND CONCAT(pta_leerjr + ( SELECT SUBSTRING(year_long, 6, 4) FROM kldv.years WHERE year_id = {$herinfo['year_id']} ) - SUBSTRING(year_long, 6, 4), pta_target) = '%q'
AND ll = 1
AND flags&%i
EOQ
, $_GET['leerjaartarget'], $rule['flags']));
}
html_end();