$_SERVER['REQUEST_TIME']) error_user('Vragen staan nog open', 'Deadline voor het beantwoorden van vragen is nog niet verstreken'); $resultaten = mdb2_query($db, <<vraag01234' $concat_cont $group_concat_d(results $group_concat_d_sep '') $concat_cont '' $concat_end FROM ( SELECT lln_id, $concat_begin '' $concat_cont eff_question_text $concat_cont '' $concat_cont s0 $concat_cont '' $concat_cont s1 $concat_cont '' $concat_cont s2 $concat_cont '' $concat_cont s3 $concat_cont '' $concat_cont s4 $concat_cont '' $concat_end results, grps FROM ( SELECT lln_id, eff_question_id, grps, $ifnull($group_concat_d(CASE WHEN eff_responses_0.eff_response_id IS NOT NULL THEN ppl.ppl_login END $group_concat_d_sep ' '), '') s0, $ifnull($group_concat_d(CASE WHEN eff_responses_1.eff_response_id IS NOT NULL THEN ppl.ppl_login END $group_concat_d_sep ' '), '') s1, $ifnull($group_concat_d(CASE WHEN eff_responses_2.eff_response_id IS NOT NULL THEN ppl.ppl_login END $group_concat_d_sep ' '), '') s2, $ifnull($group_concat_d(CASE WHEN eff_responses_3.eff_response_id IS NOT NULL THEN ppl.ppl_login END $group_concat_d_sep ' '), '') s3, $ifnull($group_concat_d(CASE WHEN eff_responses_4.eff_response_id IS NOT NULL THEN ppl.ppl_login END $group_concat_d_sep ' '), '') s4 FROM ( SELECT DISTINCT bla.ppl_id lln_id, grps, ppl2grp2subj.ppl_id doc_id FROM ( SELECT ppl_id, $group_concat_d( $concat_begin grp_name $concat_cont '/' $concat_cont subjs $concat_end $group_concat_d_sep ';') grps FROM ( SELECT grp2subj.grp_id, $group_concat(subj_abbrev) subjs FROM ppl2grp2subj JOIN grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN subj ON subj.subj_id = grp2subj.subj_id WHERE ppl_id = {$_SESSION['ppl_id']} AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} GROUP BY grp_id, subj_abbrev ) AS subjs JOIN grp ON grp.grp_id = subjs.grp_id JOIN ppl2grp ON ppl2grp.grp_id = grp.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} GROUP BY ppl_id ) bla JOIN ppl2grp ON ppl2grp.ppl_id = bla.ppl_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit > {$_SERVER['REQUEST_TIME']} JOIN grp2subj ON grp2subj.grp_id = ppl2grp.grp_id JOIN ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp2subj.ppl_exit > {$_SERVER['REQUEST_TIME']} ) AS bla JOIN ppl ON ppl.ppl_id = doc_id JOIN eff_q2m2p ON eff_meeting_id = %i AND eff_q2m2p.ppl_id = lln_id LEFT JOIN eff_responses AS eff_responses_0 ON eff_responses_0.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses_0.ppl_id = doc_id AND eff_responses_0.eff_score = 0 LEFT JOIN eff_responses AS eff_responses_1 ON eff_responses_1.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses_1.ppl_id = doc_id AND eff_responses_1.eff_score = 1 LEFT JOIN eff_responses AS eff_responses_2 ON eff_responses_2.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses_2.ppl_id = doc_id AND eff_responses_2.eff_score = 2 LEFT JOIN eff_responses AS eff_responses_3 ON eff_responses_3.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses_3.ppl_id = doc_id AND eff_responses_3.eff_score = 3 LEFT JOIN eff_responses AS eff_responses_4 ON eff_responses_4.eff_q2m2p_id = eff_q2m2p.eff_q2m2p_id AND eff_responses_4.ppl_id = doc_id AND eff_responses_4.eff_score = 4 GROUP BY lln_id, eff_question_id, grps ) AS bla JOIN eff_questions ON eff_questions.eff_question_id = bla.eff_question_id ) AS bla JOIN ppl ON ppl.ppl_id = bla.lln_id GROUP BY lln_id, ppl_forename, ppl_prefix, ppl_surname, grps EOQ , $_GET['meeting_id']); if (!($row = $resultaten->fetchRow(MDB2_ASSOC))) error_user("Geen leerlingen", "Er zijn geen leerlingen van jou over wie informatie beschikbaar is."); html_start(); ?>terug{$row[0]}

{$row[1]}\n"); } while (($row = $resultaten->fetchRow(MDB2_ASSOC))); html_end(); ?>