Alle leerlingen die hier niet niet staan hebben al een account, of zijn, ten onrechte, niet in deze groep geplaatst.

".mysql_result($result, $i, 'naam').", Aanmaakcode: ". mysql_result($result, $i, 'code')."\nJe kunt je met deze code en je ". "leerlingnummer/afkorting aanmelden op $http_server$http_path (klik op ". "'Aanmaken', voer je leerlingnummer/afkorting, emailadres en deze ". "code in en lees je mail)

"); } gen_html_footer(); break; case 'Last login': $result = mysql_query_safe("SELECT IF(max_timestamp IS NULL, ". "'nog nooit ingelogd', max_timestamp) last_login_time, ". "CONCAT(KB_NAAM(naam0, naam1, naam2), ' (', ppl.login, ')') naam, ". "IF (`count` IS NULL, 0, `count`) aantal_logins ". "FROM ppl2grp ". "JOIN ppl USING (ppl_id) ". "JOIN grp2vak USING (grp_id) ". "JOIN doc2grp2vak USING (grp2vak_id) ". "LEFT JOIN ( ". "SELECT ppl.ppl_id, MAX(timestamp) max_timestamp, ". "COUNT(DISTINCT timestamp) `count` FROM ppl ". "JOIN ppl2grp USING (ppl_id) ". "JOIN log ON ppl.ppl_id = log.ppl_id ". "JOIN grp2vak USING (grp_id) ". "JOIN doc2grp2vak USING (grp2vak_id) ". "WHERE event = 'login_success' ". "AND grp_id = '%s' ". "AND doc2grp2vak.ppl_id = ${_SESSION['ppl_id']} ". "GROUP BY ppl.ppl_id ". ") AS login ON login.ppl_id = ppl.ppl_id ". "WHERE ppl.active IS NOT NULL ". "AND doc2grp2vak.ppl_id = ${_SESSION['ppl_id']} ". "AND grp_id = '%s' ". "GROUP BY ppl.ppl_id ORDER BY max_timestamp DESC", mysql_escape_safe($_GET['grp_id']), mysql_escape_safe($_GET['grp_id'])); gen_html_header(); echo(sprint_table($result)); gen_html_footer(); break; case 'Ouders': $result = mysql_query_safe(<< Hier volgen alle leerlingen uit de groep met ten minste één ouder.

Van de onderstaande leerlingen is ". "nog geen emailadres bekend
$geenemail"; gen_html_footer(); break; case 'oude vakken/docenten': $result = mysql_query_safe( "SELECT CONCAT(KB_NAAM(lln_naam0, lln_naam1, lln_naam2), ". "' (', lln_login, ')') AS naam, ". "GROUP_CONCAT(DISTINCT IF(grp_stamklas, grp_naam, NULL)) ". "AS `vorige klas`, ". "GROUP_CONCAT(DISTINCT oldgrp_naam) ". "AS `huidige klas`, ". "GROUP_CONCAT(DISTINCT vak_docenten ORDER BY vak_afkorting ". "SEPARATOR ' ') AS `oude vakken/docenten` ". "FROM ( ". "SELECT lln.naam0 AS lln_naam0, ". "lln.naam1 AS lln_naam1, ". "lln.naam2 AS lln_naam2, ". "lln.login AS lln_login, ". "nwgrp.naam AS grp_naam, ". "nwgrp.stamklas AS grp_stamklas, ". "oldgrp.naam AS oldgrp_naam, ". "oldgrp.stamklas AS oldgrp_stamklas, ". "lln.ppl_id AS lln_id, ". "vak.afkorting AS vak_afkorting, ". "CONCAT(vak.afkorting, '/', ". "GROUP_CONCAT(DISTINCT doc.login ORDER BY doc.login)) ". "AS vak_docenten ". "FROM ppl AS lln ". "JOIN ppl2grp AS vorig_schooljaar USING (ppl_id) ". "JOIN ppl2grp AS dit_schooljaar USING (ppl_id) ". "JOIN ppl2grp AS oude_stamklas USING (ppl_id) ". "JOIN grp AS nwgrp ON dit_schooljaar.grp_id = nwgrp.grp_id ". "JOIN grp AS oldgrp ON oldgrp.grp_id = oude_stamklas.grp_id ". "JOIN grp2vak ". "ON dit_schooljaar.grp_id = grp2vak.grp_id ". "JOIN doc2grp2vak USING (grp2vak_id) ". "JOIN ppl AS doc ON doc.ppl_id = doc2grp2vak.ppl_id ". "RIGHT JOIN vak USING (vak_id) ". "JOIN grp2vak AS old_grp2vak ". "ON old_grp2vak.grp_id = vorig_schooljaar.grp_id ". "JOIN doc2grp2vak AS old_doc2grp2vak ". "ON old_grp2vak.grp2vak_id = old_doc2grp2vak.grp2vak_id ". "WHERE vorig_schooljaar.grp_id = '%s' ". "AND oldgrp.stamklas = 1 ". "AND oldgrp.schooljaar = '$schooljaar' ". "AND nwgrp.schooljaar = '$vorig_schooljaar' ". "AND old_doc2grp2vak.ppl_id = '${_SESSION['ppl_id']}' ". "GROUP BY lln.ppl_id, vak.vak_id ". ") AS bla WHERE 1 GROUP BY bla.lln_id ". "ORDER BY lln_naam0, lln_naam1, lln_naam2", mysql_escape_safe($_GET['grp_id'])); gen_html_header(); echo(sprint_table($result)); gen_html_footer(); break; case 'nieuwe vakken/docenten': $result = mysql_query_safe( "SELECT CONCAT(KB_NAAM(lln_naam0, lln_naam1, lln_naam2), ". "' (', lln_login, ')') AS naam, ". "GROUP_CONCAT(DISTINCT oldgrp_naam) ". "AS `vorige klas`, ". "GROUP_CONCAT(DISTINCT IF(grp_stamklas, grp_naam, NULL)) ". "AS `huidige klas`, ". "GROUP_CONCAT(DISTINCT vak_docenten ORDER BY vak_afkorting ". "SEPARATOR ' ') AS `nieuwe vakken/docenten` ". "FROM ( ". "SELECT lln.naam0 AS lln_naam0, ". "lln.naam1 AS lln_naam1, ". "lln.naam2 AS lln_naam2, ". "lln.login AS lln_login, ". "nwgrp.naam AS grp_naam, ". "nwgrp.stamklas AS grp_stamklas, ". "oldgrp.naam AS oldgrp_naam, ". "oldgrp.stamklas AS oldgrp_stamklas, ". "lln.ppl_id AS lln_id, ". "vak.afkorting AS vak_afkorting, ". "CONCAT(vak.afkorting, '/', ". "GROUP_CONCAT(DISTINCT doc.login ORDER BY doc.login)) ". "AS vak_docenten ". "FROM ppl AS lln ". "JOIN ppl2grp AS vorig_schooljaar USING (ppl_id) ". "JOIN ppl2grp AS dit_schooljaar USING (ppl_id) ". "JOIN ppl2grp AS oude_stamklas USING (ppl_id) ". "JOIN grp AS nwgrp ON dit_schooljaar.grp_id = nwgrp.grp_id ". "JOIN grp AS oldgrp ON oldgrp.grp_id = oude_stamklas.grp_id ". "JOIN grp2vak ". "ON dit_schooljaar.grp_id = grp2vak.grp_id ". "JOIN doc2grp2vak USING (grp2vak_id) ". "JOIN ppl AS doc ON doc.ppl_id = doc2grp2vak.ppl_id ". "RIGHT JOIN vak USING (vak_id) ". "JOIN grp2vak AS old_grp2vak ". "ON old_grp2vak.grp_id = vorig_schooljaar.grp_id ". "JOIN doc2grp2vak AS old_doc2grp2vak ". "ON old_grp2vak.grp2vak_id = old_doc2grp2vak.grp2vak_id ". "WHERE vorig_schooljaar.grp_id = '%s' ". "AND oldgrp.stamklas = 1 ". "AND oldgrp.schooljaar = '$vorig_schooljaar' ". "AND nwgrp.schooljaar = '$schooljaar' ". "AND old_doc2grp2vak.ppl_id = '${_SESSION['ppl_id']}' ". "GROUP BY lln.ppl_id, vak.vak_id ". ") AS bla WHERE 1 GROUP BY bla.lln_id ". "ORDER BY lln_naam0, lln_naam1, lln_naam2", mysql_escape_safe($_GET['grp_id'])); gen_html_header(); echo(sprint_table($result)); gen_html_footer(); break; case 'Login histogram': header("Location: graphics_logins_per_leerling.php?grp_id={$_GET['grp_id']}"); break; } ?>