übernehmen]'; addnav('','todolist.php?op=viewtask&act=taketask&id='.$_GET['id']); } else { if ($row['implementation']==$session['user']['acctid']) { $row['implementor'] .= ' [abgeben]'; addnav('','todolist.php?op=viewtask&act=droptask&id='.$_GET['id']); } else { $row['implementor'] .= ' [abnehmen '; addnav('','todolist.php?op=viewtask&act=droptask&id='.$_GET['id']); $row['implementor'] .= '| übernehmen]'; addnav('','todolist.php?op=viewtask&act=taketask&id='.$_GET['id']); } } if ($row['finished']<=0) $row['finished'] = '---'; output('

',true); addnav('','todolist.php?op=viewtask&id='.$_GET['id']); output('',true); $form = array( 'title'=>'Titel (max. 50 Zeichen)', 'task'=>'Beschreibung,textarea,60,10', 'postdate'=>'Erstellt,viewonly', 'poster'=>'Von,viewonly', 'implementor'=>'Umsetzung,viewonly', 'importance'=>'Dringlichkeit,enum,unwichtig,,nicht dringend,,normal,,dringend,,sehr dringend,', 'status'=>'Status,enum,offen,,angenommen,,abgelehnt,,umgesetzt,', 'userinfo'=>'Infos,enum,geheim,,publik,', 'finished'=>'Fertiggestellt,viewonly' ); showform($form,$row); output('

',true); output('

',true); addnav('','todolist.php?op=deltask&id='.$_GET['id']); output('',true); output('

',true); output("`n`@Kommentare:`n"); viewcommentary("todolist-{$_GET['id']}","Hinzufügen",200); } elseif ($_GET['op']=='newtask') { addnav('Zurück','todolist.php'); output('`c`bTodoliste - Aufgabe hinzufügen`b`c`n`n'); output('

',true); addnav('','todolist.php?op=inserttask'); $form = array( 'title'=>'Titel (max. 50 Zeichen)', 'task'=>'Beschreibung,textarea,60,10', 'importance'=>'Dringlichkeit,enum,unwichtig,,nicht dringend,,normal,,dringend,,sehr dringend,' ); $row = array('title'=>$_POST['title'],'task'=>$_POST['task'],'importance'=>$_POST['importance']); showform($form,$row); output('

',true); } else { addnav('Aktualisieren','todolist.php'); output('`c`bTodoliste - aktuelle Aufgaben`b`c`n`n'); output("",true); output("",true); $i = 0; $sql = 'SELECT t.*, a1.name AS poster, a2.name AS implementor, IF(c.section IS NULL,0,COUNT(*)) AS commentcount, MAX(c.postdate) AS lastcomment FROM todolist t LEFT JOIN accounts a1 USING(acctid) LEFT JOIN accounts a2 ON a2.acctid=t.implementation LEFT JOIN commentary c ON c.section=CONCAT("todolist-",t.taskid) GROUP BY t.taskid ORDER BY t.status ASC, t.importance DESC, lastcomment DESC, postdate DESC'; $result = db_query($sql); while ($row = db_fetch_assoc($result)) { output("',true); $i++; } output('

Aufgabe	Erstellt	Von	Umsetzung	Kommentare	Letzter Kommentar	Dringlichkeit	Status	Infos
",true); if (max($row['postdate'],$row['lastcomment'])>max($session['lastlogoff'],$session['todolist'][$row['taskid']])) { output('`4*`0'); } output('',true); addnav('','todolist.php?op=viewtask&id='.$row['taskid']); output($row['title']); output('',true); output('	',true); output($row['postdate']); output('	',true); output($row['poster']); output('	',true); if ($row['implementation']>0) output($row['implementor']); else output('---'); output('	',true); output($row['commentcount']); output('	',true); if ($row['lastcomment']>0) output($row['lastcomment']); else output('---'); output('	',true); output($row['importance']); output('	',true); output($row['status']); output('	',true); output($row['userinfo']); output('

',true); addnav('Aufgabe hinzufügen','todolist.php?op=newtask'); } page_footer(); ?>