include("include/init.php");
check_login();
$week_options = gen_week_select($_GET['week'], 0, &$week);
$result = mysql_query_safe("SELECT grp2vak_id, grp.naam, notities.text, GROUP_CONCAT(tag_id) tag_ids, agenda.*, doc_id FROM notities ".
"LEFT JOIN tags2notities USING (notitie_id) ".
"JOIN agenda USING (notitie_id) ".
"JOIN grp2vak2agenda USING (agenda_id) ".
"JOIN grp2vak USING (grp2vak_id) ".
"JOIN doc2grp2vak USING (grp2vak_id) ".
"JOIN grp USING (grp_id) ".
"LEFT JOIN notities2teletop USING (notitie_id) ".
"WHERE notities.notitie_id = %s ".
"AND doc2grp2vak.ppl_id = ${_SESSION['ppl_id']} GROUP BY notitie_id",
mysql_escape_safe($_GET['notitie_id']));
$num = mysql_numrows($result);
if (!$num) {
header("Location: index.php");
exit;
}
if (mysql_result($result, 0, 'tag_ids')) $tag_ids = explode(',', mysql_result($result, 0, 'tag_ids'));
//print_r($tags);
$grp2vak_options =
sprint_grp2vak_select(mysql_result($result, 0, 'grp2vak_id'), 0, &$grp2vak_id, 0);
$dag_options = gen_dag_select(mysql_result($result, 0, "agenda.dag"), 0, &$dag, 0, 0);
$lesuur_options = gen_lesuur_select(mysql_result($result, 0, "agenda.lesuur"), 0, &$lesuur, 0);
$default0= '';
$default1= '';
$default2= '';
$default3= '';
if (is_array($tag_ids) && in_array(sprint_singular("SELECT tag_id FROM tags WHERE tag = 'per1'"), $tag_ids)) {
$default1 = ' selected';
} else if (is_array($tag_ids) && in_array(sprint_singular("SELECT tag_id FROM tags WHERE tag = 'per2'"), $tag_ids)) {
$default2 = ' selected';
} else if (is_array($tag_ids) && in_array(sprint_singular("SELECT tag_id FROM tags WHERE tag = 'per3'"), $tag_ids)) {
$default3 = ' selected';
} else {
$default0 = ' selected';
}
$tags .= 'voor cijfer: ';
$tags .= sprint_tag_checkbox('tags[]', 'repetitie', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'so', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'vt', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'st', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'inleveren', $tag_ids).' periode:
';
$tags .= 'huiswerk: ';
$tags .= sprint_tag_checkbox('tags[]', 'maken', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'nakijken', $tag_ids);
$tags .= ' '.sprint_tag_checkbox('tags[]', 'leren', $tag_ids).'
';
$tags .= 'planning: ';
$tags .= sprint_tag_checkbox('tags[]', 'in de les', $tag_ids).'
';
$result2 = mysql_query_safe("SELECT vaksite FROM grp2vak2vaksite JOIN vaksites USING (vaksite_id) WHERE grp2vak_id = '$grp2vak_id'");
if (mysql_numrows($result2)) $vaksite = mysql_result($result2, 0, 0);
gen_html_header("Veranderen/Verplaatsen/Verwijderen", '$("textarea:visible:first").focus();');
$dagen = array('ma', 'di', 'wo', 'do', 'vr');
?>