WebCollab --------------------------------------- This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. Function: --------- Show a task */ //security check if(! defined('UID' ) ) { die('Direct file access not permitted' ); } //includes require_once(BASE.'includes/usergroup_security.php'); include_once(BASE.'includes/details.php' ); include_once(BASE.'tasks/task_common.php' ); include_once(BASE.'includes/time.php' ); //secure variables $content = ''; //is there an id ? if(! @safe_integer($_GET['taskid']) || $_GET['taskid'] == 0 ) { error('Task show', 'Not a valid value for taskid' ); } $taskid = $_GET['taskid']; //check usergroup security $taskid = usergroup_check($taskid ); $q = db_query('SELECT '.PRE.'tasks.created AS created, '.PRE.'tasks.finished_time AS finished, '.PRE.'tasks.completion_time AS completion, '.PRE.'users.fullname AS fullname, '.PRE.'taskgroups.name AS taskgroup_name, '.PRE.'usergroups.name AS usergroup_name, '.$epoch.' '.PRE.'seen.time) AS last_seen FROM '.PRE.'tasks LEFT JOIN '.PRE.'users ON ('.PRE.'users.id='.PRE.'tasks.owner) LEFT JOIN '.PRE.'taskgroups ON ('.PRE.'taskgroups.id='.PRE.'tasks.taskgroupid) LEFT JOIN '.PRE.'usergroups ON ('.PRE.'usergroups.id='.PRE.'tasks.usergroupid) LEFT JOIN '.PRE.'seen ON ('.PRE.'tasks.id='.PRE.'seen.taskid AND '.PRE.'seen.userid='.UID.') WHERE '.PRE.'tasks.id='.$taskid.' LIMIT 1' ); //get the data if( ! ($row = db_fetch_array($q, 0 ) ) ) { error('Task show', 'The requested item has either been deleted, or is now invalid.'); } //mark this as seen in seen ;) if($row['last_seen'] ) { db_query('UPDATE '.PRE.'seen SET time=now() WHERE taskid='.$taskid.' AND userid='.UID ); } else { db_query('INSERT INTO '.PRE.'seen(userid, taskid, time) VALUES ('.UID.', '.$taskid.', now() )' ); } //text link for 'printer friendly' page if(isset($_GET['action']) && $_GET['action'] === "show_print" ) { $content .= "

[".$lang['normal_version']."]

"; } else { //show print tag $content .= "
". "". "\"".$lang['icalendar']."\"   ". "". "\"".$lang['print_version']."\"
\n"; //show 'project jump' select box $content .= project_jump($taskid); } //start of header table $content .= "\n"; //percentage_completed gauge if this is a project if( $TASKID_ROW['parent'] == 0 ) { $content .= "\n"; $content .= "\n"; } //project/task name $content .= "\n"; //show text $content .= "
".sprintf( $lang['percent_project_sprt'], $TASKID_ROW['completed'] )."
".show_percent( $TASKID_ROW['completed'] )."
".$TASKID_ROW['name']."

\n"; $content .= nl2br(bbcode($TASKID_ROW['text'] ) ); $content .= "
\n"; //start of info table $content .= "\n"; //get owner information if( $TASKID_ROW['owner'] == 0 ) { $content .= "\n"; } else { $content .= "\n"; } //get creator information (null if creator has been deleted!) $creator = @db_result(db_query("SELECT fullname FROM ".PRE."users WHERE id=".$TASKID_ROW['creator'] ), 0, 0 ); $content .= "\n"; //get deadline $content .= "\n"; //get priority $content .= "\n"; //status info and task completion date switch($TASKID_ROW['parent'] ) { case 0: //project - show the finish date and status $title = $lang['project_details']; switch($TASKID_ROW['status'] ) { case 'cantcomplete': $content .= "\n"; $content .= "\n"; break; case 'notactive': $content .= "\n"; break; case 'nolimit': $content .= "\n"; break; case 'done': default: if($TASKID_ROW['completed'] == 100 ) { $content .= "\n"; } break; } break; default: //task $title = $lang['task_info']; $content .= "\n"; //is there a finished date ? switch($TASKID_ROW['status'] ) { case 'done': $content .= "\n"; break; case 'cantcomplete': $content .= "\n"; break; default: break; } break; } //task group if($TASKID_ROW['parent'] != 0 ) { switch($TASKID_ROW['taskgroupid'] ){ case 0: $content .= "\n"; break; default: $content .= "\n"; break; } } //show the usergroupid if( $TASKID_ROW['usergroupid'] != 0 ) { $content .= "\n"; break; case 'f': default: $content .= "".$lang[$TYPE."_not_accessible"]."\n"; break; } if($TASKID_ROW['groupaccess'] == 't' ) { $content .= "\n"; } } else { $content .= "\n"; } $content .= "
".$lang['owned_by'].":".$lang['nobody']."
".$lang['owned_by'].": ".$row['fullname']."
".$lang['created_on'].": "; if($creator == NULL ) { $content .= nicedate($TASKID_ROW['created']); } else { $content .= sprintf($lang['by_sprt'], nicedate($row['created']), "".$creator.""); } $content .= "
".$lang['deadline'].": ".nicedate($TASKID_ROW['deadline'])."
".$lang['priority'].": "; switch($TASKID_ROW['priority'] ) { case 0: $content .= $task_state['dontdo']; break; case 1: $content .= $task_state['low']; break; case 2: $content .= $task_state['normal']; break; case 3: $content .= "".$task_state['high'].""; break; case 4: $content .= "".$task_state['yesterday'].""; break; } $content .= "
".$lang['status'].": ".$lang['project_on_hold']."
".$lang['modified_on'].": ".nicedate($row['finished'])."
".$lang['status'].": ".$lang['project_planned']."
".$lang['status'].": ".$lang['project_no_deadline']."
".$lang['completed_on'].": ".nicedate($row['completion'] )."
".$lang['status'].": "; switch($TASKID_ROW['status'] ) { case 'created': $content .= $task_state['new']; break; case 'notactive': $content .= $task_state['planned']; break; case 'active': $content .= $task_state['active']; break; case 'cantcomplete': $content .= "".$task_state['cantcomplete'].""; break; case 'done': $content .= $task_state['done']; break; default: $content .= $TASKID_ROW['status']; break; } $content .= "
".$lang['completed_on'].": ".nicedate($row['finished'])."
".$lang['modified_on'].": ".nicedate($row['finished'])."
".$lang['taskgroup'].": ".$lang['none']."
".$lang['taskgroup'].": ".$row['taskgroup_name']."
".$lang['usergroup'].": ".$row['usergroup_name']." "; switch($TASKID_ROW['globalaccess'] ){ case 't': $content .= $lang[$TYPE."_accessible"]."
 ".$lang["usergroup_can_edit_".$TYPE]."
".$lang['usergroup'].": ".$lang[$TYPE."_not_in_usergroup"]."
\n"; //if this is an archived task, or you are a GUEST user, then no user functions are available if(($TASKID_ROW['archive'] == 0 ) && (! GUEST ) ) { $form1 = "
\n". "
\n". "\n". "\n". "
\n". "
\n"; $form2 = "
\n". "
\n". "\n". "\n". "
\n". "
\n"; $form3 = "
\n". "
\n". "\n". "\n". "
\n". "
\n"; $this_form = ''; $content .= "
\n"; //set add function switch($TYPE){ case 'project': $content .= "[".$lang['add_task']."] \n"; break; case 'task': $content .= "[".$lang['add_subtask']."] \n"; break; } //unowned task ==> [I'll take it!] button if($TASKID_ROW['owner'] == 0 ) { $content .= "[".sprintf($lang['i_take_it'] )."]\n"; $this_form .= $form1; } //check for owner or group access if((UID == $TASKID_ROW['owner'] ) || ($TASKID_ROW['groupaccess'] == "t") && (isset($GID[($TASKID_ROW['usergroupid'])] ) ) ) { $access = true; } else { $access = false; } //admin - owner - groupaccess ==> [edit] button if((ADMIN ) || ($access ) ) { $content .= "". "[".$lang['edit']."] \n". "\n"; } //(owner - groupaccess) & (uncompleted task) ==> [I finished it] button if(($access ) && ($TASKID_ROW['status'] != 'done' ) && ($TASKID_ROW['parent'] != 0 ) ) { $content .= "[".$lang['i_finished']."] \n"; $this_form .= $form2; } //(owner) & (uncompleted task)==> [I don't want it anymore] button if(UID == $TASKID_ROW['owner'] && ($TASKID_ROW['status'] != 'done' ) ) { $content .= "[".$lang['i_dont_want']."] \n"; $this_form .= $form3; } //(admin) & (not owner) & (has owner) & (uncompleted task) ==> [Take over task] button if((ADMIN ) && (UID != $TASKID_ROW['owner'] ) && ($TASKID_ROW['owner'] != 0 ) && ($TASKID_ROW['status'] != 'done' ) ) { $content .= "[".sprintf($lang["take_over_".$TYPE] )."]\n"; $this_form .= $form1; } $content .= "
\n".$this_form; } new_box( $title, $content, 'boxdata2' ); ?>