getPref('SHDATEFORMAT');
$q = new DBQuery;
$q->addTable('projects');
$q->addQuery("projects.*, m.model_type, m.model_delivery_day");
$q->addWhere('project_id = '.$project_id);
$q->addJoin('models','m','model_association=1 && model_pt ='. $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 to archive projects. It is necessary add and edit permission
$perms =& $AppUI->acl();
$canRead = $perms->checkModule($m, 'view','',intval($obj->project_group),1);
if (!$canRead) {
$AppUI->redirect( "m=public&a=access_denied" );
}
$title = new CTitleBlock('Effort Analisys', 'graph.gif', $m, "$m.$a");
$title->addCrumb( "?m=projects&a=view&project_id=$project_id", "View project" );
$title->show();
// C'è da effettuare la query in base ad il livello
$q->clear();
$q->addQuery('task_id, task_parent, task_name, task_start_date, task_finish_date, m.model_type, m.model_delivery_day');
$q->addTable('tasks','t');
$q->addJoin('models','m','model_association=2 && model_pt = t.task_id');
$q->addWhere('task_project ='. $project_id);
$q->addOrder('task_wbs_index');
$tasks = $q->loadList();
/*echo"";
print_r($tasks);
echo"
";*/
function findTasksLevel($ar, $ar2) {
$l = array();//echo"
";print_r($ar);echo "
----".$tp2;
foreach ($ar2 as $t2) {
foreach ($ar as $t) {//echo"
".$tp;echo "-".$tp2;echo "-".$tid;
if ($t['task_parent'] == $t2['task_id'] && $t['task_id'] <> $t['task_parent'])
$l[] = $t;
}
}
return($l);
}
foreach ($tasks as $t) {
if ($t['task_id'] == $t['task_parent'])
$levels[0][] = $t;
}
$i=0;
while (count($levels[$i]) > 0) {
$levels[$i+1] = findTasksLevel($tasks,$levels[$i]);
$i++;
}
/*echo count($levels[$i]);
echo"";
print_r($levels);
echo"
";*/
$num_lev = count($levels);
$lev = array();
for($i=0; $i < $num_lev; $i++)
$lev[$i]=$i;
function findTaskNextLevel($tLevel,$tid) {
foreach ($tLevel as $t) {
if ($t['task_parent'] == $tid)
return true;
}
return false;
}
$l=0;
$add = array();
while ($l < $le-1) {
foreach ($levels[$l] as $t) {
if (!findTaskNextLevel($levels[$l+1],$t['task_id'])) {
$add[] = $t['task_id'];
}
}
$l++;
}
$sTasks ="0";
if ($le > 0) {
foreach ($levels[$le-1] as $t)
$sTasks .= ",".$t['task_id'];
foreach ($add as $t)
$sTasks .= ",".$t;
}
//echo $sTasks;
?>
";$q->clear();
$q->clear();
$q->addQuery('t.task_id, t.task_start_date, t.task_finish_date, SUM(ut.effort) as task_effort, m.model_type, m.model_delivery_day');
$q->addTable('tasks','t');
$q->addJoin('models','m','model_association = 2 && model_pt = t.task_id');
$q->addJoin('user_tasks','ut','t.task_id = ut.task_id');
$q->addWhere('t.task_project = '.$project_id.' && t.task_id IN ('. $sTasks.')');
$q->addGroup('t.task_id');
$tasks = $q->loadList();
$q->clear();
echo "";
print_r($tasks);
echo "
";
$sum = 0;
foreach ($tasks as $ta) {
$totalHours = 0;
$tobj = new CTask();
$childs = $tobj->getChild($ta['task_id'],$project_id);
$totalHours = $tobj->getActualEffort($ta['task_id'],$childs);
$startDate = intval($ta['task_start_date']) ? new CDate($ta['task_start_date']) : null;
$startDate = $startDate ? $startDate->format($df) : $AppUI->_('not defined');
$finishDate = intval($ta['task_finish_date']) ? new CDate($ta['task_finish_date']) : null;
$finishDate = $finishDate ? $finishDate->format($df) : $AppUI->_('not defined');
$t=0;
$t = $tobj->getActualFinishDate($ta['task_id'],$childs);
echo "
".$t['task_log_finish_date']."
";
$t = intval($t['task_log_finish_date']) ? new CDate($t['task_log_finish_date']) : null;
$t = $t ? $t->format($df) : $AppUI->_('not defined');
$ts = explode ('/', $startDate);
$ts = $ts[2]."-".$ts[1]."-".$ts[0];
$ts = strtotime($ts);
if ($ts > $beginProject)
$ba = round(($ts-$beginProject)/86400);
else
$ba = 0;
$ar_ba[] = $ba;
$te = explode ('/', $finishDate);
$te = $te[2]."-".$te[1]."-".$te[0];
$te = strtotime($te);//echo $finishDate."
";
$te = ($te-$ts)/86400;
$te = round($te);
$ar_te[] = $ba+$te;
$t = explode ('/', $t);
$t = $t[2]."-".$t[1]."-".$t[0];
$t = strtotime($t);
$t = ($t-$ts)/86400;
$t = round($t);
if ($t < 0)
$t = 0;
if ($ta['model_type'] == 2) {
$deliveryDate = intval($ta['model_delivery_day']) ? new CDate($ta['model_delivery_day']) : null;
$deliveryDate = $deliveryDate ? $deliveryDate->format($df) : $AppUI->_('not defined');
$td = explode ('/', $deliveryDate);
$td = $td[2]."-".$td[1]."-".$td[0];
$td = strtotime($td);//echo $today."
";
$td = ($td-$ts) / 86400;
$td = round($td);
if ($td == 0)
$td = 1;
$ar_td[] = $ba+$td;
} else {
$ef = $ta['task_effort'] / ($te+1);
$af = $totalHours / ($t+1);
}
for ($i=0; $i<=$te; $i++) {
$ii = $i + $ba;
if ($ii <= $n) {
if ($ta['model_type'] == 2) {
if ($i > 0) {
$temp=1-exp(-($t*$t)/(2*$td*$td));
if ($temp == 0)
$temp = 1;
$K = $totalHours/($temp);
$ydataf[$ii] += $K*($i/($td*$td))*exp(-($i*$i)/(2*$td*$td));
}
} else {
$sum += $af;//if ($af > 0)
$ydataf[$ii] += $af; // Uniform distribution
}
}
}
echo CTask::getWBS($ta['task_id'])." ".$totalHours." $t
";
}
echo $sum;*/
?>