<?php
/* $Id$ $URL$ */
if (!defined('W2P_BASE_DIR')) {
die('You should not access this file directly.');
}
##
## Companies: View Projects sub-table
##
global $AppUI, $company_id, $pstatus, $w2Pconfig;
$sort = w2PgetParam($_GET, 'sort', 'project_name');
if ($sort == 'project_priority') {
$sort .= ' DESC';
}
$df = $AppUI->getPref('SHDATEFORMAT');
$projects = CCompany::getProjects($AppUI, $company_id, 1, $sort);
?>
<table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl"><?php
if (count($projects) > 0) {
?>
<tr>
<th><a href="index.php?m=companies&a=view&company_id=<?php
echo $company_id;
?>
&sort=project_priority"><?php
echo $AppUI->_('P');
?>
</a></th>
<th><a href="index.php?m=companies&a=view&company_id=<?php
echo $company_id;
?>
$q->addQuery('file_id,file_name');
$q->addOrder('file_name');
$resultList = $q->loadHashList();
break;
case 'forums':
$title = 'Forum';
$q->addQuery('forum_id,forum_name');
$q->addOrder('forum_name');
$resultList = $q->loadHashList();
break;
case 'projects':
$project_company = w2PgetParam($_GET, 'project_company', 0);
if ($user_id > 0) {
$projectList = CContact::getProjects($user_id);
} else {
$projectList = CCompany::getProjects($AppUI, $project_company);
}
foreach ($projectList as $project) {
$resultList[$project['project_id']] = $project['project_name'];
}
break;
case 'tasks':
$title = 'Task';
$task_project = (int) w2PgetParam($_GET, 'task_project', 0);
$myTask = new CTask();
$task_list = $myTask->getAllowedTaskList($AppUI, $task_project);
$level = 0;
$query_result = array();
$last_parent = 0;
foreach ($task_list as $task) {
if ($task['task_parent'] != $task['task_id']) {
<?php
/* $Id: vw_archived.php 321 2009-02-23 04:41:14Z caseydk $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/tags/version2.4/modules/companies/vw_archived.php $ */
if (!defined('W2P_BASE_DIR')) {
die('You should not access this file directly.');
}
##
## Companies: View Archived Projects sub-table
##
global $AppUI, $company_id;
$projects = CCompany::getProjects($AppUI, $company_id, 0);
?>
<table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl"><?php
if (count($projects) > 0) {
?>
<tr><th><?php
echo $AppUI->_('Name');
?>
</th><th><?php
echo $AppUI->_('Owner');
?>
</th></tr><?php
foreach ($projects as $project) {
?>
<tr>
<td>
<a href="?m=projects&a=view&project_id=<?php
echo $project['project_id'];
?>
"><?php
echo $project['project_name'];
echo $AppUI->_('Target Budget');
?>
</th>
<th width="10px" align="center"><?php
echo $AppUI->_('Actual Cost');
?>
</th>
<th width="10px" align="center"><?php
echo $AppUI->_('Difference');
?>
</th>
</tr>
<?php
//TODO: rotate the headers by 90 degrees?
$activeOnly = $active_projects ? true : false;
$projectList = CCompany::getProjects($AppUI, $company_id, $activeOnly);
$bcode = new CSystem_Bcode();
$project = new CProject();
if (count($projectList)) {
foreach ($projectList as $projectItem) {
$project->loadFull(null, $projectItem['project_id']);
$criticalTasks = $project->getCriticalTasks($projectItem['project_id']);
$costs = $bcode->calculateProjectCost($projectItem['project_id'], $start_date->format(FMT_DATETIME_MYSQL), $end_date->format(FMT_DATETIME_MYSQL));
$pstart = new w2p_Utilities_Date($project->project_start_date);
$pend = intval($criticalTasks[0]['task_end_date']) ? new w2p_Utilities_Date($criticalTasks[0]['task_end_date']) : new w2p_Utilities_Date();
$filterStart = $start_date;
$filterEnd = $end_date;
$workingDaysInSpans = $filterStart->findDaysInRangeOverlap($pstart, $pend, $filterStart, $filterEnd);
$workingDaysForProj = $pstart->workingDaysInSpan($pend);
$factor = $workingDaysInSpans / $workingDaysForProj;
$factor = $factor > 1 ? 1 : $factor;
/**
* Tests loading list of Projects for this company.
*/
public function testGetProjects()
{
global $AppUI;
$projects = CCompany::getProjects($AppUI, 1);
$this->assertEquals(1, count($projects));
$this->assertEquals(1, $projects[0]['project_id']);
$this->assertEquals('Test Project', $projects[0]['project_name']);
$this->assertEquals('', $projects[0]['project_start_date']);
$this->assertEquals(0, $projects[0]['project_status']);
$this->assertEquals('0.00', $projects[0]['project_target_budget']);
$this->assertEquals(-1, $projects[0]['project_priority']);
$this->assertEquals('Admin', $projects[0]['contact_first_name']);
$this->assertEquals('Person', $projects[0]['contact_last_name']);
}
