acl(); $q->addTable('tasks'); $q->leftJoin('users', 'u1', 'u1.user_id = task_creator'); $q->leftJoin('projects', 'p', 'p.project_id = task_project'); $q->leftJoin('task_log', 'tl', 'tl.task_log_task = task_id'); $q->addWhere('task_id = ' . $task_id); $q->addQuery('tasks.*'); $q->addQuery('project_name, project_color_identifier, project_group, project_current'); //$q->addQuery("CONCAT_WS(' ',user_first_name,user_last_name) username"); $q->addQuery('ROUND(SUM(task_log_hours),2) as log_hours_worked'); $q->addGroup('task_id'); // check if this record has dependencies to prevent deletion $msg = ''; $obj = new CTask(); //$obj = null; $sql = $q->prepare(); $q->clear(); if (!db_loadObject( $sql, $obj, true, false )) { $AppUI->setMsg( 'Task' ); $AppUI->setMsg( "invalidID", UI_MSG_ERROR, true ); $AppUI->redirect(); } else { $AppUI->savePlace(); } $canRead = $perms->checkModule('tasks','view','', intval($obj->project_group),1); if (!$canRead) { $AppUI->redirect( "m=public&a=access_denied" ); } $canEdit = ($perms->checkModule('tasks','edit','', intval($obj->project_group),1) && ($obj->project_current == '0')); $canAdd = ($perms->checkModule('tasks','add','', intval($obj->project_group),1) && ($obj->project_current == '0')); /*if (!$obj->canAccess( $AppUI->user_id )) { $AppUI->redirect( "m=public&a=access_denied" ); }*/ $canDelete = ($obj->canDelete( $msg, $task_id, null, intval($obj->project_group)) && ($obj->project_current == '0')); // retrieve any state parameters if (isset( $_GET['tab'] )) { $AppUI->setState( 'TaskLogVwTab', $_GET['tab'] ); } $tab = $AppUI->getState( 'TaskLogVwTab' ) !== NULL ? $AppUI->getState( 'TaskLogVwTab' ) : 0; // get the prefered date format $df = $AppUI->getPref('SHDATEFORMAT'); $df1 = $df; //Also view the time $df .= " " . $AppUI->getPref('TIMEFORMAT'); $childs = $obj->getChild(); $start_date = intval( $obj->task_start_date ) ? new CDate( $obj->task_start_date ) : null; $end_date = intval( $obj->task_finish_date ) ? new CDate( $obj->task_finish_date ) : null; $task_start_date = $obj->getStartDateFromTask($task_id, $childs); $task_start_date['task_start_date'] = intval( $task_start_date['task_start_date'] ) ? new CDate( $task_start_date['task_start_date'] ) : "-"; $task_finish_date = $obj->getFinishDateFromTask($task_id, $childs); $task_finish_date['task_finish_date'] = intval( $task_finish_date['task_finish_date'] ) ? new CDate( $task_finish_date['task_finish_date'] ) : "-"; $actual_start_date = $obj->getActualStartDate($task_id, $childs); $actual_start_date['task_log_start_date'] = intval( $actual_start_date['task_log_start_date'] ) ? new CDate( $actual_start_date['task_log_start_date'] ) : "-"; $actual_finish_date = $obj->getActualFinishDate($task_id, $childs); $actual_finish_date['task_log_finish_date'] = intval( $actual_finish_date['task_log_finish_date'] ) ? new CDate( $actual_finish_date['task_log_finish_date'] ) : "-"; $today = intval( $obj->task_today ) ? new CDate( $obj->task_today ) : null; //check permissions for the associated project $canReadProject = $perms->checkModule('projects','view','', intval($obj->project_group),1); // get the users on this task $q->addTable('users', 'u'); $q->addTable('user_tasks', 't'); $q->addQuery('u.user_id, u.user_username, user_email'); $q->addWhere('t.task_id = ' . $task_id); $q->addWhere('t.user_id = u.user_id'); $q->addOrder('u.user_username'); $sql = $q->prepare(); $q->clear(); $users = db_loadList( $sql ); $durnTypes = dPgetSysVal( 'TaskDurationType' ); // setup the title block $titleBlock = new CTitleBlock( 'View Task', 'applet-48.png', $m, "$m.$a"); $titleBlock->addCell( ); if ($canEdit) { if ($canAdd) { $titleBlock->addCrumb( "?m=tasks&a=addedit&task_project=$obj->task_project&task_parent=$task_id", "New task" ); } } //$titleBlock->addCrumb( "?m=tasks", "Tasks list" ); if ($canEdit) { $titleBlock->addCrumb( "?m=tasks&a=addedit&task_id=$task_id", "Edit task" ); } if ($canDelete) { $titleBlock->addCrumbDelete( 'Delete task', $canDelete, $msg ); } if ($canReadProject) { $titleBlock->addCrumb( "?m=projects&a=view&project_id=$obj->task_project", "View project" ); } $titleBlock->show(); $task_types = dPgetSysVal("TaskType"); ?> addQuery('td.dependencies_task_id, t.task_name'); $q->addTable('tasks', 't'); $q->addTable('task_dependencies', 'td'); $q->addWhere('td.dependencies_task_id = t.task_id'); $q->addWhere('td.dependencies_req_task_id = ' . $task_id); $dependingTasks = $q->loadHashList(); $q->clear(); ?> " : ''; foreach($dependingTasks as $key => $value) { $s .= ''; } echo '
_('Base Information');?> task_parent != $obj->task_id ) { $obj_parent = new CTask(); $obj_parent->load($obj->task_parent); ?>
_('Project');?>: project_name;?>
_('Task');?>: getWBS($task_id)." ".@$obj->task_name;?>
_('Task Parent');?>: task_id; ?>">task_name;?>
_('Start Date');?>: format( $df ) : '-';?> _('Effort');?>: getEffort($task_id); echo $te." ph"; ?>
_('Finish Date');?>: format( $df ) : '-';?> _('Budget');?>: getBudget($task_id); echo $tb." ".$dPconfig['currency_symbol']; ?>
_('Computed Information at');echo " ".(!is_null($today) ? " ".$today->format( $df ) : ' -');?>
_('Start Date from Tasks');?>: 0 && count($task_start_date) > 0 && $task_start_date['task_start_date'] <>"-") { ?> format( $df1 ) : '-';?> _('Actual Start Date');?>: 0 && count($actual_start_date) > 0 && $actual_start_date['task_log_start_date'] <>"-") { ?> format( $df1 ) : '-';?>
_('Finish Date from Tasks');?>: 0 && count($task_finish_date) > 0 && $task_finish_date['task_finish_date'] <>"-") { ?> format( $df1 ) : '-';?> _('Actual Finish Date');?>: 0 && count($actual_finish_date) > 0 && $actual_finish_date['task_log_finish_date'] <>"-") { ?> format( $df1 ) : '-';?>
_('Effort from Tasks');?>: getEffortFromTask($task_id,$childs)." ph"; ?> _('Actual Effort');?>: getActualEffort($task_id, $childs); echo $ae." ph"; ?>
_('Budget from Tasks');?>: getBudgetFromTask($task_id,$childs)." ".$dPconfig['currency_symbol']; ?> _('Actual Cost');?>: getActualCost($task_id, $childs); echo $ac." ".$dPconfig['currency_symbol']; ?>
_('Progress');?>: getProgress($task_id, $te);echo $pr;?>% _('Effort Performance Index');?>: getEffortPerformanceIndex($task_id,$ae,$te,$pr,$childs); ?>
_('Time Performance Index');?>: getTimePerformanceIndex($task_id,null,$start_date,$finish_date,$actual_finish_date['task_log_finish_date'],$pr,$childs); ?> _('Cost Performance Index');?>: getCostPerformanceIndex($task_id,$ac,$tb,$pr,$childs); ?>
_('Assigned to task');?>
clear(); $q->addTable('user_tasks','ut'); $q->addQuery('CONCAT_WS(", ",u.user_last_name,u.user_first_name) as nm, u.user_email as um, pr.proles_name as pn, ut.effort as ue'); $q->addJoin('users','u','u.user_id=ut.user_id'); $q->addJoin('project_roles','pr','pr.proles_id = ut.proles_id'); $q->addWhere('ut.proles_id > 0 && ut.task_id = '.$task_id); $ar_ur = $q->loadList(); if (!is_null($ar_ur)){ foreach ($ar_ur as $ur) { echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>
_('Person');?>: _('Role');?>: _('Effort');?>:
".$ur['nm']."".$ur['pn']."".$ur['ue']." ph
 addQuery('td.dependencies_req_task_id, t.task_name'); $q->addTable('tasks', 't'); $q->addTable('task_dependencies', 'td'); $q->addWhere('td.dependencies_req_task_id = t.task_id'); $q->addWhere('td.dependencies_task_id = ' . $task_id); $taskDep = $q->loadHashList(); $q->clear(); ?> " : ''; foreach($taskDep as $key => $value) { $s .= ''; } echo '
_('Dependencies');?> _('Tasks depending on this Task');?>
".$AppUI->_('none')."
'; $s .= ''.$value.''; $s .= '
'.$s.'
'; ?> 		".$AppUI->_('none')."
'; $s .= ''.$value.''; $s .= '
'.$s.'
'; ?> getSystemClass( 'CustomFields' ); $custom_fields = New CustomFields( $m, $a, $task_id, "view" ); $custom_fields->printHTML(); ?>
_('Details');?>
_('Status');?>: task_status){echo $AppUI->_("Inactive");}else{echo $AppUI->_("Active");}?> _('Milestone');?>: task_milestone){echo $AppUI->_("Yes");}else{echo $AppUI->_("No");}?>
_('Priority');?>: task_priority == 0) { echo $AppUI->_('normal'); } else if ($obj->task_priority < 0){ echo $AppUI->_('low'); } else { echo $AppUI->_('high'); } ?> _('Type');?>: task_type];?>
_('URL');?>: task_related_url;?>
_('Description');?>: ", $obj->task_description) ; ?> 
printHTML(); ?>
_('Properties');?>
getProperties(); ?> 
 

isLeaf() ) {// Solo nelle foglie si possono aggiungere i log!!!!! // tabbed information boxes if ($perms->checkModule('task_log','view','', intval($obj->project_group),1)) { $tabBox_show = 1; $prg = intval($obj->project_group); $tabBox->add( "{$dPconfig['root_dir']}/modules/tasks/vw_logs", 'Task Logs' ); // fixed bug that dP automatically jumped to access denied if user does not // have read-write permissions on task_id and this tab is opened by default (session_vars) // only if user has r-w perms on this task, new or edit log is beign showed $q->clear(); $q->addQuery('user_id'); $q->addTable('user_tasks'); $q->addWhere('proles_id > 0 && task_id ='.$task_id); $usLog = $q->loadColumn();//echo $obj->project_current; if ( in_array($AppUI->user_id,$usLog) && ($obj->project_current == '0'))//task_log_id==234significa edit task log id 234 if ($task_log_id == 0) { if ($perms->checkModule('task_log','add','', intval($obj->project_group),1)) $tabBox->add( "{$dPconfig['root_dir']}/modules/tasks/vw_log_update", 'New Log' ); } else { if ($perms->checkModule('task_log','edit','', intval($obj->project_group),1)) $tabBox->add( "{$dPconfig['root_dir']}/modules/tasks/vw_log_update", 'Edit Log' ); } $curPr = ($obj->project_current == '0'); } } if ( count($obj->getChildren()) > 0 ) { // Has children // settings for tasks $f = 'children'; $min_view = true; $tabBox_show = 1; // in the tasks file there is an if that checks // $_GET[task_status]; this patch is to be able to see // child tasks withing an inactive task $_GET["task_status"] = $obj->task_status; $tabBox->add( "{$dPconfig['root_dir']}/modules/tasks/tasks", 'Child Tasks' ); } if ($tabBox->loadExtras($m, $a)) $tabBox_show = 1; if ( $tabBox_show == 1) $tabBox->show(); ?>