$entity_info) { switch ($entity_info['entity_type']) { case 0: $where = '-- %q'."\n"; $where2 = '-- %q'."\n"; break; case 7: $where = "AND toets_afd = '%q'"; $where2 = "AND mondeling_afd = '%q'"; break; case 2: $error = "zoeken op surveillant is niet mogelijk"; goto start_html; break; case 3: $error = "zoeken op lokaal is niet mogelijk"; goto start_html; case 6: $error = "zoeken op vak is niet mogelijk"; goto start_html; case 1: $grps = mdb2_single_val($db, <<', entity_name, '') SEPARATOR ' ') FROM $roosterdb.grp2ppl JOIN $roosterdb.entities ON entities.entity_id = grp2ppl.lesgroep_id AND entity_type = 7 WHERE file_id_basis = $file_id AND ppl_id = %i EOQ , $entity_id); $links = mdb2_single_val($db, <<', entity_name, '') SEPARATOR ' ') FROM $roosterdb.grp2ppl JOIN $roosterdb.entities ON entities.entity_id = grp2ppl.lesgroep_id AND ( entity_type = 4 OR entity_type = 5 OR entity_type = 7 ) WHERE file_id_basis = $file_id AND ppl_id = %i EOQ , $entity_id); $where = '-- %q'."\n"; $where .= 'AND entity_id IN ('.$grps.')'; $where2 = 'AND mondeling_ll LIKE \'%q\''; break; case 4: case 5: $grps = mdb2_single_val($db, <<', entity_name, '') SEPARATOR ' ') FROM $roosterdb.grp2ppl JOIN $roosterdb.entities ON entities.entity_id = grp2ppl.ppl_id AND ( entity_type = 1 ) WHERE file_id_basis = $file_id AND lesgroep_id = %i EOQ , $entity_id); $where = '-- %q'."\n"; $where .= 'AND entity_id IN ('.$grps.')'; $where2 = 'AND mondeling_ll LIKE \'%q\''; break; default: error_system('impossible!'); } } } else { $error = htmlenc($_GET['q']).' niet uniek'; goto start_html; } $res = mdb2_query($db, << Rooster Toetsweek
Llnr/stamklas/lesgroep/categorie/surveillant

Toetsrooster van .

Gerelateerd: .TP versie . 4H 5H 4V 5V 6V