getModuleFile('report', 'generatePDF'); include_once $AppUI->getModuleClass('report'); $project_id = intval(dPgetParam($_REQUEST, "project_id", 0 )); $msg = ''; $objPr = new CProject(); // get ProjectPriority from sysvals $projectPriority = dPgetSysVal( 'ProjectPriority' ); $projectPriorityColor = dPgetSysVal( 'ProjectPriorityColor' ); $working_hours = $AppUI->user_day_hours; $user_id = $AppUI->user_id; // load the record data // GJB: Note that we have to special case duration type 24 and this refers to the hours in a day, NOT 24 hours $q = new DBQuery; $q->addTable('projects'); $q->addQuery("group_name, CONCAT_WS(' ',user_first_name,user_last_name) user_name, projects.*"); $q->addJoin('groups', 'g', 'group_id = project_group'); $q->addJoin('users', 'u', 'user_id = project_creator'); $q->addJoin('tasks', 't1', 'projects.project_id = t1.task_project'); $q->addWhere('project_id = '.$project_id); $q->addGroup('project_id'); $sql = $q->prepare(); $q->clear(); if (!db_loadObject( $sql, $obj )) { $AppUI->setMsg( 'Project' ); $AppUI->setMsg( "invalidID", UI_MSG_ERROR, true ); $AppUI->redirect(); } else { $AppUI->savePlace(); } // check permissions for this record $perms =& $AppUI->acl(); $canRead = $perms->checkModule($m, 'view','',intval($obj->project_group),1); $canEdit = $perms->checkModule($m, 'edit','',intval($obj->project_group),1) && $obj->project_current == '0'; if (!$canRead) { $AppUI->redirect( "m=public&a=access_denied" ); } // retrieve any state parameters if (isset( $_GET['tab'] )) { $AppUI->setState( 'ProjVwTab', $_GET['tab'] ); } $tab = $AppUI->getState( 'ProjVwTab' ) !== NULL ? $AppUI->getState( 'ProjVwTab' ) : 0; $canDelete = $perms->checkModule( $m, 'delete','',intval($obj->project_group), 1); // get the prefered date format $df = $AppUI->getPref('SHDATEFORMAT'); // create Date objects from the datetime fields $start_date = intval( $obj->project_start_date ) ? new CDate( $obj->project_start_date ) : null; $finish_date = intval( $obj->project_finish_date ) ? new CDate( $obj->project_finish_date ) : null; $task_start_date = $objPr->getStartDateFromTask($project_id); $task_start_date['task_start_date'] = intval( $task_start_date['task_start_date'] ) ? new CDate( $task_start_date['task_start_date'] ) : "-"; $task_finish_date = $objPr->getFinishDateFromTask($project_id); $task_finish_date['task_finish_date'] = intval( $task_finish_date['task_finish_date'] ) ? new CDate( $task_finish_date['task_finish_date'] ) : "-"; $actual_start_date = $objPr->getActualStartDate($project_id); $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 = $objPr->getActualFinishDate($project_id); $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->project_today ) ? new CDate( $obj->project_today ) : null; $style1 = (( $task_start_date['task_start_date'] < $start_date) && !empty($start_date)) ? 'style="color:red"' : ''; $style2 = (( $task_finish_date['task_finish_date'] > $finish_date) && !empty($finish_date)) ? 'style="color:red"' : ''; $style3 = (( $actual_start_date['task_log_start_date'] < $start_date) && !empty($start_date)) ? 'style="color:red"' : ''; $style4 = (( $actual_finish_date['task_log_finish_date'] > $finish_date) && !empty($finish_date)) ? 'style="color:red"' : ''; // setup the title block $titleBlock = new CTitleBlock( 'View Project', 'applet3-48.png', $m, "$m.$a"); //$titleBlock->addCrumb( "?m=projects", "Projects list" ); if ($canEdit) { $titleBlock->addCrumb( "?m=projects&a=addedit&project_id=$project_id", "Edit project" ); } if ($canDelete) $titleBlock->addCrumbDelete( 'Delete project', $canDelete, $msg ); if ($canEdit) $titleBlock->addCrumb( "?m=projects&a=saveas&project_id=$project_id", "Archive project" ); $titleBlock->addCrumb( "?m=projects&a=effort&project_id=$project_id", "Effort analysis" ); $titleBlock->addCrumb( "?m=report&a=view&project_id=$project_id", "Project Reports" ); if ($canEdit) $titleBlock->addCrumb("?m=tasks&a=addedit&task_project=$project_id", "New task"); CReport::initUserReport($project_id); if (dPgetBoolParam($_POST, 'add_prop_report') && getProjectState('Properties') && !getProjectState('PropertiesComputed') && !dPgetBoolParam($_POST, 'make_prop_pdf')) { $AppUI->setMsg($AppUI->_('Project Properties added to Reports!'), UI_MSG_OK); $properties = addslashes(getProjectState('Properties')); $summary = addslashes(getProjectState('PropertiesSummary')); CReport::addProjectReport($project_id, $properties, $summary); unsetProjectSubState('PDFReports', PMPDF_REPORT); } $titleBlock->show(); ?>
properties) && empty($_POST['properties']) && empty($_REQUEST['make_prop_pdf']) && db_loadResult("SELECT COUNT(*) FROM tasks WHERE task_project = $project_id")) $project_collapsed = true; echo ' '; echo '' . $obj->project_name .''; ?> _('Click here to toggle the project informations'); ?>
_('Base Information');?>
_('Group');?>: group_name, ENT_QUOTES) ;?> _('Effort');?>: project_effort; ?> ph
_('Start Date');?>: format( $df ) : '-';?> _('Target Budget');?>: project_target_budget." ".$dPconfig['currency_symbol'] ?>
_('Finish Date');?>: format( $df ) : '-';?> _('Hard Budget');?>: project_hard_budget." ".$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'] <>"-") { ?> ' : '';?> '.$task_start_date['task_start_date']->format( $df ).'' : '-';?> ' : '';?> _('First Log Date');?>: 0 && count($actual_start_date) > 0 && $actual_start_date['task_log_start_date'] <>"-") { ?> ' : '';?> '.$actual_start_date['task_log_start_date']->format( $df ).'' : '-';?> ' : '';?>
_('Finish Date from Tasks');?>: 0 && count($task_finish_date) > 0 && $task_finish_date['task_finish_date'] <>"-") { ?> ' : '';?> '.$task_finish_date['task_finish_date']->format( $df ).'' : '-';?> ' : '';?> _('Last Log Date');?>: 0 && count($actual_finish_date) > 0 && $actual_finish_date['task_log_finish_date'] <>"-") { ?> ' : '';?> '.$actual_finish_date['task_log_finish_date']->format( $df ).'' : '-';?> ' : '';?>
_('Effort from Tasks');?>: getEffortFromTask($project_id)." ph"; ?> _('Actual Effort');?>: getActualEffort($project_id); echo $ae." ph"; ?>
_('Budget from Tasks');?>: getBudgetFromTask($project_id)." ".$dPconfig['currency_symbol']; ?> _('Actual Cost');?>: getActualCost($project_id); echo $ac." ".$dPconfig['currency_symbol']; ?>
_('Progress');?>: getProgress($project_id,@$obj->project_effort);echo $pr;?>% _('Effort Performance Index');?>: getEffortPerformanceIndex($project_id,$ae,@$obj->project_effort,$pr); ?>
_('Time Performance Index');?>: getTimePerformanceIndex($project_id,null,$start_date,$finish_date,$actual_finish_date['task_log_finish_date'],$pr); ?> _('Cost Performance Index');?>: getCostPerformanceIndex($project_id,$ac,$obj->project_target_budget,$pr); ?>
_('Assigned to project');?>
clear(); $q->addTable('user_projects','up'); $q->addQuery('CONCAT_WS(", ",u.user_last_name,u.user_first_name) as nm, u.user_email as um, pr.proles_name as pn'); $q->addJoin('users','u','u.user_id=up.user_id'); $q->addJoin('project_roles','pr','pr.proles_id = up.proles_id'); $q->addWhere('up.proles_id > 0 && up.project_id = '.$project_id); $ar_ur = $q->loadList(); if (!is_null($ar_ur) && !empty($ar_ur)){ foreach ($ar_ur as $ur) $r["".$ur['nm'].""].=$ur['pn'].", "; foreach ($r as $u => $pr) { $pr{strlen($pr)-2}=")"; echo "
".$u." (".str_pad($pr,strlen($pr)-5,'T').""; } } ?>
_('Details');?>
_('Status');?>: _($pstatus[$obj->project_status]);?> _('Short Name');?>: project_short_name, ENT_QUOTES) ;?>
_('Type');?>: _($ptype[$obj->project_type]);?> _('Active');?>: project_active ? $AppUI->_('Yes') : $AppUI->_('No');?>
_('Priority');?>: _($projectPriority[$obj->project_priority]);?> _('Project Creator');?>: user_name; ?>
_('URL');?>: project_url;?>
_('Description');?>: ", $obj->project_description) ; ?> 
project_id, "view" ); $custom_fields->printHTML(); ?>
_('Properties');?>
/>
/>
/>
/>
 
properties as $prop) { if (strstr($prop, "Project isn't")) $summary .= $prop."|"; } setProjectState('PropertiesSummary', $summary); $properties = $AppUI->getProperties(); setProjectState('Properties', $properties); setProjectState('PropertiesComputed', false); } echo $properties; ?> 
PDF Report

checkModule('tasks', 'view','',intval($obj->project_group),1); if ($canViewTask) { $tabBox->add( dPgetConfig('root_dir')."/modules/tasks/tasks", 'Tasks (Planned view)' ); $tabBox->add( dPgetConfig('root_dir')."/modules/tasks/tasks", 'Tasks (Actual view)'); //$tabBox->add( dPgetConfig('root_dir')."/modules/tasks/tasks", 'Tasks (Inactive)' ); //$tabBox->add( dPgetConfig('root_dir')."/modules/tasks/viewtodo", 'Tasks TODO' ); $tabBox->add( dPgetConfig('root_dir')."/modules/tasks/viewgantt", 'Gantt Chart' ); $tabBox->add( dPgetConfig('root_dir')."/modules/tasks/viewwbs", 'WBS Tree' ); $tabBox->add( dPgetConfig('root_dir')."/modules/tasks/viewtasknetwork", 'Tasks Network' ); $tabBox->add( dPgetConfig('root_dir')."/modules/projects/vw_logs", 'Task Logs' ); // if ($perms->checkModule('files', 'view')) // $tabBox->add( dPgetConfig('root_dir')."/modules/projects/vw_files", 'Files' ); } $tabBox->loadExtras($m); $f = 'all'; $min_view = true; $tabBox->show(null, false, true); ?>