<?php require_once 'common.php'; check_roostermaker($_GET['secret']); $koppel_query = <<<EOQ SELECT CONCAT('<span style="display: inline-block"><input type="checkbox" name="entity_ids[]" value="', \tentities.entity_id, '"', CASE WHEN entity_active = 1 THEN ' checked' ELSE '' END, '>', \tentity_name, '</input></span>') FROM entities WHERE entity_type != %i AND entity_type != %i AND entity_type != 0 ORDER BY entity_type, entity_name EOQ; $entities = mdb2_col(0, $koppel_query, LEERLING, LESGROEP); header("Content-Type: text/html; charset=UTF-8"); ?> <!DOCTYPE HTML> <html> <head> <meta charset="UTF-8"> <title>Verberg entities in lijst</title> <link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.10.4.custom.min.css"> <style type="text/css"><!-- body { font-size: 10px; } #content { font-size: 13px; } --></style> <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">
$defaultuntil = ''; } $koppel_query = <<<EOQ SELECT CONCAT('<span style="display: inline-block"><input type="checkbox" name="entity_ids[]" value="', \tentities.entity_id, '"', CASE WHEN bericht_id IS NOT NULL THEN ' checked' ELSE '' END, '>', \tentity_name, '</input></span>') FROM entities LEFT JOIN entities2berichten ON entities2berichten.entity_id = entities.entity_id AND entities2berichten.bericht_id = %i WHERE (entity_active = 1 OR entities2berichten.entity_id IS NOT NULL) AND entity_type = %i ORDER BY entity_name EOQ; $koppel_count_query = <<<EOQ SELECT COUNT(*) FROM entities2berichten JOIN entities ON entities.entity_id = entities2berichten.entity_id WHERE bericht_id = %i AND entity_type = %i EOQ; $k_stamklassen = mdb2_col(0, $koppel_query, $bericht_id, STAMKLAS); $k_lesgroepen = mdb2_col(0, $koppel_query, $bericht_id, LESGROEP); $k_categorieen = mdb2_col(0, $koppel_query, $bericht_id, CATEGORIE); $count_stamklassen = mdb2_single_val($koppel_count_query, $bericht_id, STAMKLAS); $count_lesgroepen = mdb2_single_val($koppel_count_query, $bericht_id, LESGROEP); $count_categorieen = mdb2_single_val($koppel_count_query, $bericht_id, CATEGORIE); header("Content-Type: text/html; charset=UTF-8"); ?> <!DOCTYPE HTML> <html> <head> <meta charset="UTF-8"> <title>Bericht</title> <link rel="stylesheet" href="css/ui-lightness/jquery-ui-1.10.4.custom.min.css"> <style type="text/css"><!-- body { font-size: 10px; }