0) $AppUI->redirect("m=public&a=access_denied"); $q = new DBQuery(); $q->addQuery('project_group, project_current'); $q->addTable('projects'); $q->addJoin('tasks','','task_project=project_id'); $q->addWhere('task_id ='.$task_id); $ar=$q->loadList(); $prg = $ar[0]['project_group']; $curPr = $ar[0]['project_current'] == '0'; $perms =& $AppUI->acl(); if (! $perms->checkModule('task_log', 'view', '', intval($prg),1)) { $AppUI->redirect("m=public&a=access_denied"); } $df1 = $AppUI->getPref('SHDATEFORMAT'); $df .= $df1. " " . $AppUI->getPref('TIMEFORMAT'); $problem = intval( dPgetParam( $_GET, 'problem', null ) ); // get sysvals $taskLogReference = dPgetSysVal( 'TaskLogReference' ); $taskLogReferenceImage = dPgetSysVal( 'TaskLogReferenceImage' ); $canDelete = $perms->checkModule('task_log', 'delete', '', intval($prg),1) && $curPr; ?> '0'" : '') . " ORDER BY task_log_creation_date "; $logs = db_loadList( $sql ); $s = ''; $canEd = $perms->checkModule('task_log', 'edit', '', intval($prg),1) && $curPr; foreach ($logs as $row) { $task_log_date = intval( $row['task_log_creation_date'] ) ? new CDate( $row['task_log_creation_date'] ) : null; $task_log_edit_date = intval( $row['task_log_edit_date'] ) ? new CDate( $row['task_log_edit_date'] ) : null; $task_log_start_date = intval( $row['task_log_start_date'] ) ? new CDate( $row['task_log_start_date'] ) : null; $task_log_finish_date = intval( $row['task_log_finish_date'] ) ? new CDate( $row['task_log_finish_date'] ) : null; $style = $row['task_log_problem'] ? 'background-color:#cc6666;color:#ffffff' :''; $style2 = ($task_log_date != $task_log_edit_date) ? $style2='background-color:#ffff00;' : ''; $s .= ''; $s .= "\n\t"; $date1 = ($task_log_date ? $task_log_date->format( $df ) : '-'); $date2 = ($task_log_edit_date ? $task_log_edit_date->format( $df ) : '-'); $date3 = ($task_log_start_date ? $task_log_start_date->format( $df ) : '-'); $date4 = ($task_log_finish_date ? $task_log_finish_date->format( $df ) : '-'); $date = $date1." (C)"; if ($date2 != $date1 && $date2 != '-') $date .="
".$date2." (E)"; if (($date3 != $date1 && $date3 != '-') || ($date4 != $date1 && $date4 != '-')) { $date .="
".$date3." (S)"; $date .="
".$date4." (F)"; } $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= ''; $s .= "\n\t"; $s .= ''; } echo $s; ?>

	_('Pr.');?>	_('Dates');?>	_('WBS');?>	_('Task Log Name');?>	_('Worker');?>	_('Role');?>	_('Effort');?>	_('Cost');?>	_('Comments');?>
"; if ($canEd && $AppUI->user_id == $row['task_log_creator']) { if ($tab == -1) { $s .= "\n\t\tgetState( 'TaskLogVwTab' ); } else { $s .= "\n\t\t" . "\n\t\t\t". dPshowImage( './images/icons/stock_edit-16.png', 16, 16, '' ) . "\n\t\t"; } $s .= "\n\t	'.$row['task_log_progress'] . '%	'.$date.'	'.CTask::getWBS($task_id).'	'.@$row["task_log_name"].'	'.$row["user_username"].'	'.$row["proles_name"].'	'.sprintf( "%.2f", $row["task_log_hours"] ) . ' ph	'.(float)($row["proles_hour_cost"]*$row["task_log_hours"])." ".$dPconfig['currency_symbol'].'	'.''; // dylan_cuthbert: auto-transation system in-progress, leave these lines $transbrk = "\n[translation]\n"; $descrip = str_replace( "\n", " ", htmlspecialchars($row['task_log_description']) ); $tranpos = strpos( $descrip, str_replace( "\n", " ", $transbrk ) ); if ( $tranpos === false) $s .= $descrip; else { $descrip = substr( $descrip, 0, $tranpos ); $tranpos = strpos( $row['task_log_description'], $transbrk ); $transla = substr( $row['task_log_description'], $tranpos + strlen( $transbrk ) ); $transla = trim( str_replace( "'", '"', $transla ) ); $s .= $descrip." [".$AppUI->_("translation")."] "; } // end auto-translation code $s .= '	"; if ($canDelete && ($AppUI->user_id == $row['task_log_creator'] || $perms->checkModule('tasks', 'delete', '', intval($prg),1)) && $curPr) { $s .= "\n\t\t_('delete log')."\">" . "\n\t\t\t". dPshowImage( './images/icons/stock_delete-16.png', 16, 16, '' ) . "\n\t\t"; } $s .= "\n\t

_('Key');?>:

=_('Normal Log');?>

=_('Problem Report');?>

=_('Modified');?>