<?php
require_once 'common.php';
check_roostermaker($_POST['secret']);
$res = mdb2_query("SELECT week_id, ma, di, wo, do, vr FROM weken");
function do_dag($week_id, $dag, $rd)
{
if (isset($_POST['id' . $week_id . $dag]) && !$rd) {
mdb2_exec("UPDATE weken SET {$dag} = 1 WHERE week_id = {$week_id}");
} else {
if (!isset($_POST['id' . $week_id . $dag]) && $rd) {
mdb2_exec("UPDATE weken SET {$dag} = 0 WHERE week_id = {$week_id}");
}
}
}
while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
$week_id = $row['week_id'];
do_dag($week_id, 'ma', $row['ma']);
do_dag($week_id, 'di', $row['di']);
do_dag($week_id, 'wo', $row['wo']);
do_dag($week_id, 'do', $row['do']);
do_dag($week_id, 'vr', $row['vr']);
}
header('Location: upload.php?secret=' . $_POST['secret']);
<?php
require_once 'common.php';
check_roostermaker($_POST['secret']);
header('Content-type: text/plain');
$entities = mdb2_query(<<<EOQ
SELECT entity_id, CASE WHEN entity_active = 1 THEN 1 ELSE 0 END
FROM entities WHERE entity_type != %i AND entity_type != %i AND entity_type != 0
EOQ
, LEERLING, LESGROEP);
$inverted = array();
foreach ($_POST['entity_ids'] as $entity_id) {
$inverted[$entity_id] = 1;
}
//print_r($inverted);
while ($row = $entities->fetchRow()) {
if ($row[1] == 1 && !isset($inverted[$row[0]])) {
mdb2_exec("UPDATE entities SET entity_active = NULL WHERE entity_id = %i", $row[0]);
//echo("wis {$row[0]}\n");
} else {
if ($row[1] == 0 && isset($inverted[$row[0]])) {
mdb2_exec("UPDATE entities SET entity_active = 1 WHERE entity_id = %i", $row[0]);
//echo("set {$row[0]}\n");
}
}
}
header('Location: upload.php?secret=' . $_POST['secret']);
<?php
require_once 'common.php';
check_roostermaker($_POST['secret']);
if (isset($_POST['hide_students'])) {
mdb2_query("UPDATE config SET config_value = '1' WHERE config_key = 'HIDE_STUDENTS'");
} else {
mdb2_query("UPDATE config SET config_value = '0' WHERE config_key = 'HIDE_STUDENTS'");
}
if (isset($_POST['hide_rooms'])) {
mdb2_query("UPDATE config SET config_value = '1' WHERE config_key = 'HIDE_ROOMS'");
} else {
mdb2_query("UPDATE config SET config_value = '0' WHERE config_key = 'HIDE_ROOMS'");
}
if (isset($_POST['enable_test_warning'])) {
mdb2_query("UPDATE config SET config_value = '1' WHERE config_key = 'ENABLE_TEST_WARNING'");
} else {
mdb2_query("UPDATE config SET config_value = '0' WHERE config_key = 'ENABLE_TEST_WARNING'");
}
header('Location: upload.php?secret=' . $_POST['secret']);
WHERE file_type = 1 AND file_status = 1
ORDER BY file_version DESC
LIMIT 1
EOQ
);
$res = mdb2_query(<<<EOQ
SELECT ll, name, stamklassen.entity_name klas, GROUP_CONCAT(CONCAT(doc, '/', bla) SEPARATOR ';') info FROM (
\tSELECT ppl_id, ll, doc, GROUP_CONCAT(vakken ORDER BY vakken) bla FROM (
\t\tSELECT DISTINCT ll.entity_id ppl_id, ll.entity_name ll, doc.entity_name doc, lessen.vakken
\t\tFROM grp2ppl
\t\tJOIN entities2lessen AS grp2les ON grp2les.entity_id = grp2ppl.lesgroep_id
\t\tJOIN files2lessen ON files2lessen.les_id = grp2les.les_id AND file_id = {$file_id}
\t\tJOIN lessen ON lessen.les_id = files2lessen.les_id
\t\tJOIN entities2lessen AS doc2les ON doc2les.les_id = grp2les.les_id AND file_id = {$file_id}
\t\tJOIN entities AS doc ON doc.entity_id = doc2les.entity_id AND doc.entity_type = %i
\t\tJOIN entities AS ll ON ll.entity_id = grp2ppl.ppl_id
\t\tWHERE file_id_basis = {$file_id}
\t) AS lijst
\tGROUP BY ppl_id, doc
) AS lijst
JOIN names ON names.entity_id = ppl_id
JOIN grp2ppl ON grp2ppl.ppl_id = lijst.ppl_id AND file_id_basis = {$file_id}
JOIN entities AS stamklassen ON stamklassen.entity_id = grp2ppl.lesgroep_id AND stamklassen.entity_type = %i
GROUP BY lijst.ppl_id
ORDER BY klas, surname, firstname, prefix
EOQ
, DOCENT, STAMKLAS);
$legenda = array();
$legenda_rev = array();
$legenda_rev[0] = 'llnr';
$legenda_rev[1] = 'naam';
$legenda_rev[2] = 'klas';
CONCAT('<input type="checkbox"', CASE WHEN wo = 1 THEN ' checked' ELSE '' END, ' name="id', week_id, 'wo">') wo,
CONCAT('<input type="checkbox"', CASE WHEN do = 1 THEN ' checked' ELSE '' END, ' name="id', week_id, 'do">') do,
CONCAT('<input type="checkbox"', CASE WHEN vr = 1 THEN ' checked' ELSE '' END, ' name="id', week_id, 'vr">') vr
FROM weken
ORDER BY week_id
EOQ
);
$res_geupload = mdb2_query(<<<EOQ
SELECT week, basis_id, wijz_id, {$sub0} file_name, FROM_UNIXTIME(timestamp) timestamp, IFNULL(file_version, '-') file_version FROM roosters
JOIN weken USING (week_id)
JOIN files USING (file_id)
ORDER BY rooster_id DESC
EOQ
);
$berichten = mdb2_query(<<<EOQ
SELECT bericht_id, bericht_title, bericht_visiblefrom, bericht_visibleuntil FROM berichten ORDER BY bericht_visibleuntil DESC
EOQ
);
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Upload en berichtenpagina voor de roostermakers</title>
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.10.4.custom.min.css">
<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.10.4.custom.min.js"></script>
<script type="text/javascript" src="js/jquery.iframe-post-form.js"></script>
<script type="text/javascript">
//<![CDATA[
$(function(){
var interval, randid, d, state;
WHERE f.lesgroepen IS NOT NULL AND f.dag != 0 AND f.uur != 0{$day}
ORDER BY f_uur, f_dag, wijz{$multiple_sort}, f_vakken, f_zid, s_dag DESC
EOQ
);
if (($entity_type == LESGROEP || $entity_type == STAMKLAS || $entity_type == CATEGORIE || $entity_type == LEERLING) && $safe_id) {
// berichten
$berichten = mdb2_query(<<<EOQ
SELECT bericht_body, bericht_title, IFNULL(bla.entities, 'Allen') bericht_entities FROM berichten
LEFT JOIN (
\tSELECT bericht_id, GROUP_CONCAT(entity_name ORDER BY entity_name) entities
\tFROM entities2berichten
\tJOIN entities ON entities.entity_id = entities2berichten.entity_id
\tGROUP BY bericht_id
) AS bla ON bla.bericht_id = berichten.bericht_id
JOIN (
\tSELECT DISTINCT berichten.bericht_id
\tFROM berichten
\tLEFT JOIN entities2berichten ON entities2berichten.bericht_id = berichten.bericht_id
\tWHERE entity_id IN ( {$safe_id} ) OR entity_id IS NULL
) AS bla2 ON bla2.bericht_id = berichten.bericht_id
WHERE bericht_visibleuntil > {$_SERVER['REQUEST_TIME']}
AND bericht_visiblefrom <= {$_SERVER['REQUEST_TIME']}
ORDER BY bericht_update DESC
EOQ
);
}
//mdb2_res_table($result);
cont:
function make_link2($target, $text = NULL)
{
global $link_tail;
$safe_week = (int) $_GET['wk'];
if ($safe_week != $_GET['wk']) {
echo '[]';
exit;
}
if (config('HIDE_STUDENTS')) {
echo '[]';
exit;
}
$week_id = mdb2_single_val("SELECT week_id FROM weken WHERE week = {$safe_week}");
if (!$week_id) {
echo '[]';
exit;
}
$file_id = mdb2_single_val("SELECT file_id FROM roosters WHERE week_id <= {$week_id} AND wijz_id = 0 ORDER BY rooster_id DESC LIMIT 1");
if (!$file_id) {
echo '[]';
exit;
}
$query = <<<EOT
SELECT entities.entity_name id, CONCAT(name, ' (', stamklassen.entity_name, '/', entities.entity_name, ')') value
FROM names
JOIN entities ON names.entity_id = entities.entity_id
JOIN grp2ppl ON ppl_id = names.entity_id
JOIN entities AS stamklassen ON stamklassen.entity_id = lesgroep_id
WHERE file_id_basis = {$file_id} AND stamklassen.entity_type = 5 AND name LIKE '%%%w%%' LIMIT 15
EOT;
$result = mdb2_query($query, $_GET['term']);
header("Content-Type: application/json; charset=UTF-8");
$array = $result->fetchAll(MDB2_FETCHMODE_ASSOC);
echo json_encode($array);
