acl(); // load the record data $obj = new CTask(); // check if we are in a subform if ($task_id > 0 && !$obj->load( $task_id )) { $AppUI->setMsg( 'Task' ); $AppUI->setMsg( "invalidID", UI_MSG_ERROR, true ); $AppUI->redirect(); } $task_parent = isset($_REQUEST['task_parent'])? $_REQUEST['task_parent'] : $obj->task_parent; // check for a valid project parent $task_project = intval( $obj->task_project ); if (!$task_project) { $task_project = dPgetParam( $_REQUEST, 'task_project', 0 ); if (!$task_project) { $AppUI->setMsg( "badTaskProject", UI_MSG_ERROR ); $AppUI->redirect(); } } $q = new DBQuery(); if ($task_project > 0) { $q->addQuery('project_group,project_current'); $q->addTable('projects'); $q->addWhere('project_id = '.$task_project); $ar=$q->loadList(); $prg = $ar[0]['project_group']; $curPr = $ar[0]['project_current'] == '0'; } else { $AppUI->setMsg( "badTaskProject", UI_MSG_ERROR ); $AppUI->redirect(); } $q->clear(); // check permissions if ( $task_id ) { // we are editing an existing task $canEdit = $perms->checkModule('tasks','edit','', intval($prg),1) && $curPr; if (!$canEdit) $AppUI->redirect( "m=public&a=access_denied&err=noedit" ); $canDelete = ($obj->canDelete( $msg, $task_id, null, intval($prg))) && $curPr; } else { $canAdd = $perms->checkModule('tasks','add','', intval($prg),1) && $curPr; $canDelete = false; if (!$canAdd) $AppUI->redirect( "m=public&a=access_denied&err=noedit" ); } //check permissions for the associated project $canReadProject = $perms->checkModule('projects','view','', intval($prg),1) && $curPr; $durnTypes = dPgetSysVal( 'TaskDurationType' ); // check the document access (public, participant, private) /*if (!$obj->canAccess( $AppUI->user_id )) { $AppUI->redirect( "m=public&a=access_denied&err=noaccess" ); }*/ // pull the related project $project = new CProject(); $project->load( $task_project ); $users = array(); $roles = array(); $meffort = array(); $dwh = array(); $parentTasks = array(); $effortTasks = array(); $q = new DBQuery(); $q->addQuery('ut.user_id, ut.proles_id, t.task_id, ut.effort, u.user_first_name, u.user_last_name, u.user_day_hours, pr.proles_name, t.task_parent'); $q->addTable('tasks','t'); $q->addJoin('user_tasks','ut','ut.task_id = t.task_id'); $q->addJoin('users','u','u.user_id = ut.user_id'); $q->addJoin('project_roles','pr','pr.proles_id = ut.proles_id'); $q->addWhere('t.task_project ='.$task_project); $ut_ar = $q->loadList(); foreach($ut_ar as $ar) { if (!is_null($ar['task_id'])) { $parentTasks[$ar['task_id']] = $ar['task_parent']; if (!is_null($ar['user_id']) && $ar['proles_id']) $effortTasks[$ar['task_id']][$ar['user_id'].",".$ar['proles_id']] = $ar['effort']; } } function sumLeafEffort($task_root, &$lEffort) { global $parentTasks, $effortTasks; //echo"$task_root inizio: ";print_r($lEffort);echo "
"; //echo"$task_root PRIMA: "."
"; if (!in_array($task_root, $parentTasks)) {//echo"$task_root FOGLIA: ";print_r($effortTasks[$task_root]);echo "
";// $task_root è una foglia $temp2 = $effortTasks[$task_root]; if (is_array($temp2)) foreach ($temp2 as $uipi => $ef) if (is_null($lEffort[$uipi])) $lEffort[$uipi] = $ef; else //{ $lEffort[$uipi] += $ef;//}//print_r($lEffort);echo "
";} } else { $temp = $parentTasks; foreach($temp as $tid => $pid) { if ($pid == $task_root && $tid != $task_root) {//echo $tid."
";//$tid è figlio di $task_root sumLeafEffort($tid, $lEffort);//splitto i valori*/ //print_r($lEffort);echo "
"; } //echo"$task_root DOPO: "."
";echo "tid ".$tid."tr ".$task_root."pid ".$pid."
"; } //echo"$task_root fine: ";print_r($lEffort);echo "
"; //return $lEffort; } } // La funzione restituisce il Max effort dato un task function findMaxEffort($task_root) { global $parentTasks, $effortTasks; $sum = array(); if ($parentTasks[$task_root] == $task_root) { //echo $task_root." -
";print_r($effortTasks[$task_root]);// è figlio di project return "-"; } foreach ($parentTasks as $tid => $pid) { if ($pid != $tid && $task_root != $tid && $pid == $parentTasks[$task_root]) {// $tid è fratello di task_root // fai la somma del valore delle foglie di tid // quindi faccio una funzione che dato tid mi calcola il valore delle sue foglie // mi restituisce un array(ui,pi => ef) $brotherEffort = array(); sumLeafEffort($tid, $brotherEffort); //print_r($brotherEffort);echo "$tid
"; if (count($brotherEffort) > 0) foreach ($brotherEffort as $uipi => $ef) if (is_null($sum[$uipi])) $sum[$uipi] = $ef; else $sum[$uipi] += $ef; } } //echo $effortTasks[$task_root]; if (count($sum)==0) return $effortTasks[$parentTasks[$task_root]]; foreach ($effortTasks[$parentTasks[$task_root]] as $uipi => $ef) { $sum[$uipi] = $ef - $sum[$uipi]; if ($sum[$uipi] < 0) $sum[$uipi] = 0; } foreach ($sum as $uipi => $ef) { if (!isset($effortTasks[$parentTasks[$task_root]][$uipi])) unset($sum[$uipi]); } return ($sum); } function findMaxEffortFromParent($parent, $originTask = 0) { global $parentTasks, $effortTasks; $sum = array(); foreach ($parentTasks as $tid => $pid) { if ($pid != $tid && $parent != $tid && $pid == $parent && $originTask != $tid) {// $tid è figlio di parent // fai la somma del valore delle foglie di tid // quindi faccio una funzione che dato tid mi calcola il valore delle sue foglie // mi restituisce un array(ui,pi => ef) $brotherEffort = array(); sumLeafEffort($tid, $brotherEffort); //print_r($brotherEffort);echo "$tid
"; if (count($brotherEffort) > 0) foreach ($brotherEffort as $uipi => $ef) if (is_null($sum[$uipi])) $sum[$uipi] = $ef; else $sum[$uipi] += $ef; } } //echo $effortTasks[$task_root]; if (count($sum)==0) return $effortTasks[$parent]; foreach ($effortTasks[$parent] as $uipi => $ef) { $sum[$uipi] = $ef - $sum[$uipi]; if ($sum[$uipi] < 0) $sum[$uipi] = 0; } foreach ($sum as $uipi => $ef) { if (!isset($effortTasks[$parent][$uipi])) unset($sum[$uipi]); } return ($sum); } //$sum = findMaxEffort(19); print_r($sum);echo "
";print_r($effortTasks[16]); $us = array(); $pr = array(); $us_hours_list="|"; $us_name_list="|"; $proles_list="|"; $q->clear(); $q->addQuery('u.user_id, user_first_name, user_last_name, user_day_hours, up.proles_id, proles_name'); $q->addTable('users','u'); $q->addJoin('user_projects','up','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 ='.$task_project); $q->addOrder('user_last_name, user_first_name'); $q->exec(); $task_list = "-^["; while ( $row = $q->fetchRow()) { if ($task_id == 0 && $task_parent < 1 || $task_parent==$task_id) if (!is_null($row['user_id'])) {//new task $users[$row['user_id'].",".$row['proles_id']] = $row['user_last_name'] . ", " . $row['user_first_name']; $roles[$row['user_id'].",".$row['proles_id']] = $row['proles_name']; $meffort[$row['user_id'].",".$row['proles_id']] = "-"; $dwh[$row['user_id'].",".$row['proles_id']] = $row['user_day_hours']." h"; } $task_list .= "(".$row['user_id'].",".$row['proles_id']."|-)"; $prUsers[$row['user_id'].",".$row['proles_id']] = $row['user_last_name'] . ", " . $row['user_first_name']; $prRoles[$row['user_id'].",".$row['proles_id']] = $row['proles_name']; $prDwh[$row['user_id'].",".$row['proles_id']] = $row['user_day_hours']." h"; if (!isset($us[$row['user_id']]) && !is_null($row['user_id'])) { $us[$row['user_id']] = 1; $us_hours_list .= $row['user_id']."=".$row['user_day_hours']."|"; $us_name_list .= $row['user_id']."=".$row['user_last_name'] . ", " . $row['user_first_name']."|"; } if (!isset($pr[$row['proles_id']]) && !is_null($row['proles_id'])) { $pr[$row['proles_id']] = 1; $proles_list .= $row['proles_id']."=".$row['proles_name']."|"; } } $task_list .= "]^-"; $q->clear(); if (!(($task_id == 0 && $task_parent < 1) || $task_parent==$task_id)) {//edit task $par = ($task_parent > 0) ? $task_parent : $parentTasks[$task_id]; } foreach($ut_ar as $ar) {//echo "
".print_r($ar)."
"; if (!($task_id == 0 && $task_parent < 1 || $task_parent==$task_id)) {//edit task if ($ar['task_id'] == $par && !is_null($ar['user_id'])) { $users[$ar['user_id'].",".$ar['proles_id']] = $ar['user_last_name'] . ", " . $ar['user_first_name']; $roles[$ar['user_id'].",".$ar['proles_id']] = $ar['proles_name']; $temp = ($task_id > 0) ? findMaxEffort($task_id) : findMaxEffortFromParent($par); $meffort[$ar['user_id'].",".$ar['proles_id']] = $temp[$ar['user_id'].",".$ar['proles_id']]." ph"; $dwh[$ar['user_id'].",".$ar['proles_id']] = $ar['user_day_hours']." h"; } } } $redUsers = array_diff_assoc($prUsers, $users); $redRoles = array_diff_assoc($prRoles, $roles); $redDwh = array_diff_assoc($prDwh, $dwh); //print_r($redUsers);print_r($redRoles); /*echo $us_hours_list."
"; echo $us_name_list."
"; echo $proles_list."
";*/ foreach ($effortTasks as $tid => $uipi_ar) { $task_list .= $tid."["; foreach ($uipi_ar as $uipi => $ef) { //correggere max effort $temp = findMaxEffortFromParent($tid, $task_id); $task_list .= "(".$uipi."|".$temp[$uipi].")"; } $task_list .= "]".$tid."-"; }/* print_r( $task_list);*/ $twi = $obj->task_wbs_index;//echo $task_parent; if ($task_parent > 0) if ($task_id == $task_parent) $wbs_list="|^=,".$twi."|"; else $wbs_list="|^=,".CTask::getWBSIndexFromParent("^",$task_project)."|"; else $wbs_list="|^=,".CTask::getWBSIndexFromParent("^",$task_project)."|"; function getSpaces($amount) { if($amount == 0) return ""; return str_repeat(" ", $amount); } function constructTaskTree($task_data, $depth = 0, $wbs = "") { global $all_tasks, $parents, $task_parent_options, $task_parent, $task_id, $wbs_list, $twi; $selected = $task_data['task_id'] == $task_parent ? "selected='selected'" : ""; /*$task_data['task_name'] = strlen($task_data[1]) > 40 ? substr($task_data['task_name'], 0, 40)."..." : $task_data['task_name'];*/ $iwbs = CTask::getWBSIndexFromParent($task_data['task_id']); $wbs .= $task_data['task_wbs_index'];// da cambiare questa""""""""""""""""""""""""""""""""""!! $wbs2 = $wbs; if ($task_data['task_id'] == $task_parent && $task_id > 0 && $task_parent > 0) $wbs_list .= $task_data['task_id']."=".$wbs.",".$twi."|"; else {// NON c'è bisogno di parentTask è in task_data ->'task_parent' USARE task_wbs_index if (isset($task_data['task_parent']) && $task_id > 0) // si gestisono i fratelli if ($task_data['task_parent'] == $task_parent) { // per i task non figli di project if ($wbs > CTask::getWBS($task_id)) $wbs2{strlen($wbs)-1} = ($wbs2{strlen($wbs)-1} == 0) ? 9 : $wbs{strlen($wbs)-1} - 1; } else // per i figli di project if ($task_data['task_parent'] == $task_data['task_id'] && $task_parent == $task_id) { if ($wbs > CTask::getWBS($task_id)) $wbs2{strlen($wbs)-1} = ($wbs2{strlen($wbs)-1} == 0) ? 9 : $wbs{strlen($wbs)-1} - 1; } if ($wbs2 != $wbs) $wbs_list .= $task_data['task_id']."=".$wbs2.",".$iwbs."|"; else $wbs_list .= $task_data['task_id']."=".$wbs.",".$iwbs."|"; } $twbs = CTask::getWBS($task_data['task_id']); $outOpt = $twbs." ".dPFormSafe($task_data['task_name']); $outOptFormatted = (strlen($outOpt)+$depth*2) > 46 ? getSpaces($depth*2)." ".substr($outOpt, 0, 46)."..." : getSpaces($depth*2)." ".$outOpt; $task_parent_options .= ""; if (isset($parents[$task_data['task_id']])) { foreach ($parents[$task_data['task_id']] as $child_task) { if ($child_task != $task_id) constructTaskTree($all_tasks[$child_task], ($depth+1), $wbs2."."); } } } // let's get root tasks $sql = "select task_id, task_name, task_finish_date, task_start_date, task_milestone, task_parent, task_wbs_index from tasks where task_project = '$task_project' and task_id = task_parent order by task_wbs_index"; $root_tasks = db_loadHashList($sql, 'task_id'); $task_parent_options = ""; // Now lets get non-root tasks, grouped by the task parent $sql = "select task_id, task_name, task_finish_date, task_start_date, task_milestone, task_parent, task_wbs_index from tasks where task_project = '$task_project' and task_id != task_parent order by task_wbs_index"; $parents = array(); $all_tasks = array(); $sub_tasks = db_exec($sql); if ($sub_tasks) { while ($sub_task = db_fetch_assoc($sub_tasks)) { // Build parent/child task list $parents[$sub_task['task_parent']][] = $sub_task['task_id']; $all_tasks[$sub_task['task_id']] = $sub_task; $all_tasks[$sub_task['task_wbs_index']] = $sub_task; } } // let's iterate root tasks foreach ($root_tasks as $root_task) { if ($root_task['task_id'] != $task_id) constructTaskTree($root_task); } // setup the title block $ttl = $task_id > 0 ? "Edit Task" : "Add Task"; $titleBlock = new CTitleBlock( $ttl, 'applet-48.png', $m, "$m.$a"); //$titleBlock->addCrumb( "?m=tasks", "Tasks list" ); if ($task_id > 0) $titleBlock->addCrumb( "?m=tasks&a=view&task_id=$obj->task_id", "View task" ); if ($canDelete) { $titleBlock->addCrumbDelete( 'Delete task', $canDelete, $msg ); } if ( $canReadProject ) { $titleBlock->addCrumb( "?m=projects&a=view&project_id=$task_project", "View project" ); } $titleBlock->show(); $group_id = $project->project_group; //get list of projects, for task move drop down list. //require_once $AppUI->getModuleClass('projects'); //$project =& new CProject; $pq = new DBQuery; $pq->addQuery('project_id, project_name'); $pq->addTable('projects'); $pq->addWhere("project_group = '$group_id'"); $pq->addWhere('project_active = 1'); $pq->addOrder('project_name'); //$project->setAllowedSQL($AppUI->user_id, $pq); $projects = $pq->loadHashList(); $childs = @$obj->getChild(); $df = $AppUI->getPref('SHDATEFORMAT'); $today = new CDate( $obj->task_today ); $start_date = intval( $obj->task_start_date ) ? new CDate( $obj->task_start_date ) : new CDate(); $finish_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'] ) : "-"; // convert the numeric calendar_working_days config array value to a human readable output format $cwd = explode(',', $dPconfig['cal_working_days']); $cwd_conv = array_map( 'cal_work_day_conv', $cwd ); $cwd_hr = implode(', ', $cwd_conv); function cal_work_day_conv($val) { GLOBAL $locale_char_set; $wk = Date_Calc::getCalendarWeek( null, null, null, "%a", LOCALE_FIRST_DAY ); return htmlentities($wk[$val], ENT_COMPAT, $locale_char_set); } //Time arrays for selects $start = intval(dPgetConfig('cal_day_start')); $end = intval(dPgetConfig('cal_day_end')); $inc = intval(dPgetConfig('cal_day_increment')); if ($start === null ) $start = 8; if ($end === null ) $end = 17; if ($inc === null) $inc = 15; $hours = array(); for ( $current = $start; $current < $end + 1; $current++ ) { if ( $current < 10 ) { $current_key = "0" . $current; } else { $current_key = $current; } if ( stristr($AppUI->getPref('TIMEFORMAT'), "%p") ){ //User time format in 12hr $hours[$current_key] = ( $current > 12 ? $current-12 : $current ); } else { //User time format in 24hr $hours[$current_key] = $current; } } $minutes = array(); $minutes["00"] = "00"; for ( $current = 0 + $inc; $current < 60; $current += $inc ) { $minutes[$current] = $current; } $q->clear(); $q->addQuery('model_type,model_delivery_day'); $q->addTable('models'); $q->addWhere('model_association = 2 && model_pt ='.$task_id); $mod = $q->loadList(); ?>
_('Project');?>: project_name;?>
_('Base information');?>
_( 'Task' ).":";?> 0) $wbs_val = CTask::getWBSIndexFromParent($task_parent); else if ($task_id == 0) $wbs_val = CTask::getWBSIndexFromParent("^",$task_project); else $wbs_val = $obj->task_wbs_index;?> 0) $wbs_val2 = CTask::getWBS($task_parent); else if ($task_id > 0 && $task_id != $obj->task_parent) $wbs_val2 = CTask::getWBS($obj->task_parent); ?> " class="text" disabled/>
_( 'Start Date' ).":";?> " /> " class="text" disabled="disabled" /> <?php echo $AppUI->_('Calendar');?> getHour() : $start ) . " : "; echo arraySelect($minutes, "start_minute",'size="1" class="text"', $start_date ? $start_date->getMinute() : "0" ); if ( stristr($AppUI->getPref('TIMEFORMAT'), "%p") ) { echo ''; } ?>
_( 'Finish Date' ).":";?> <?php echo $AppUI->_('Calendar');?> getHour() : $end ) ." : "; echo arraySelect($minutes, "end_minute",'size="1" class="text"', $finish_date ? $finish_date->getMinute() : "00" ); if ( stristr($AppUI->getPref('TIMEFORMAT'), "%p") ) { echo ''; } ?>
_( 'Task Parent' ).":";?> _( 'Ef. Model' ).":";?>
_('Computed Information');?>
_('Today').":";?> format( $df );?> _('Progress').":";?> 0) echo @$obj->getProgress($obj->project_id,$obj->project_effort)."%"; else echo "-"?>
_('Start Date from Tasks').":";?> 0 && count($task_start_date) > 0 && $task_start_date['task_start_date'] <>"-") echo $task_start_date ? $task_start_date['task_start_date']->format( $df ) : '-'; else echo "-"?> _('Actual Start Date').":";?> 0 && count($actual_start_date) > 0 && $actual_start_date['task_log_start_date'] <>"-") echo $actual_start_date ? $actual_start_date['task_log_start_date']->format( $df ) : '-'; else echo "-"?>
_('Finish Date from Tasks').":";?> 0 && count($task_finish_date) > 0 && $task_finish_date['task_finish_date'] <>"-") echo $task_finish_date ? $task_finish_date['task_finish_date']->format( $df ) : '-'; else echo "-"?> _('Actual Finish Date').":";?> 0 && count($actual_finish_date) > 0 && $actual_finish_date['task_log_finish_date'] <>"-") echo $actual_finish_date ? $actual_finish_date['task_log_finish_date']->format( $df ) : '-'; else echo "-"?>
_('Effort from Tasks').":";?> 0) echo @$obj->getEffortFromTask($task_id,$childs)." ph"; else echo "-"?> _('Actual Effort').":";?> 0) echo @$obj->getActualEffort($task_id,$childs)." ph"; else echo "-"?>
_('Budget from Tasks').":";?> 0) echo @$obj->getBudgetFromTask($task_id,$childs)." ".$dPconfig['currency_symbol']; else echo "-"?> _('Actual Cost').":";?> 0) echo @$obj->getActualCost($task_id,$childs)." ".$dPconfig['currency_symbol']; else echo "-"?>

setState('TaskAeTabIdx', dPgetParam($_GET, 'tab', 0)); $tab = $AppUI->getState('TaskAeTabIdx', 0); $tabBox =& new CTabBox("?m=tasks&a=addedit&task_id=$task_id", "", $tab); $tabBox->add("{$dPconfig['root_dir']}/modules/tasks/ae_resource", "Resources"); $tabBox->add("{$dPconfig['root_dir']}/modules/tasks/ae_depend", "Dependencies"); $tabBox->add("{$dPconfig['root_dir']}/modules/tasks/ae_desc", "Details"); //$tabBox->add("{$dPconfig['root_dir']}/modules/tasks/ae_dates", "Dates"); $tabBox->loadExtras('tasks', 'addedit'); $tabBox->show('', true); ?>