$q->addWhere('task_id <> task_parent'); $row['children'] = $q->loadResult(); $row['style'] = taskstyle_pd($row); $i = count($projects[$row['task_project']]['tasks']) + 1; $row['task_number'] = $i; $row['node_id'] = 'node_' . $i . '-' . $row['task_id']; if (strpos($row['task_duration'], '.') && $row['task_duration_type'] == 1) { $row['task_duration'] = floor($row['task_duration']) . ':' . round(60 * ($row['task_duration'] - floor($row['task_duration']))); } //pull the final task row into array $projects[$row['task_project']]['tasks'][] = $row; } $showEditCheckbox = isset($canEditTasks) && $canEditTasks || $perms->checkModule('admin', 'view'); $durnTypes = w2PgetSysVal('TaskDurationType'); $tempoTask = new CTask(); $userAlloc = $tempoTask->getAllocation('user_id'); ?> <table width="100%" border="0" cellpadding="1" cellspacing="3" class="prjprint"> <tr class="prjprint"> <th width="50%"><?php echo $AppUI->_('Task Name'); ?> </th> <th width="50" nowrap="nowrap"><?php echo $AppUI->_('Work'); ?> </th> <th nowrap="nowrap"><?php echo $AppUI->_('Start'); ?> </th>
$cols--; } if ($showEditCheckbox) { echo '<th width="1"> </th>'; } else { $cols--; } ?> </tr> <?php reset($projects); if ($w2Pconfig['direct_edit_assignment']) { // get Users with all Allocation info (e.g. their freeCapacity) // but do it only when direct_edit_assignment is on and only once. $tempoTask = new CTask(); $userAlloc = $tempoTask->getAllocation('user_id', null, true); } foreach ($projects as $k => $p) { $tnums = isset($p['tasks']) ? count($p['tasks']) : 0; if ($tnums > 0 || $project_id == $p['project_id']) { //echo '<pre>'; print_r($p); echo '</pre>'; if (!$min_view) { // not minimal view $open_link = w2PtoolTip($m, 'Click to Expand/Collapse the Tasks for this Project.') . '<a href="javascript: void(0);"><img onclick="expand_collapse(\'project_' . $p['project_id'] . '_\', \'tblProjects\',\'collapse\',0,2);" id="project_' . $p['project_id'] . '__collapse" src="' . w2PfindImage('up22.png', $m) . '" border="0" width="22" height="22" align="center" ' . (!$expanded ? 'style="display:none"' : '') . ' alt="" /><img onclick="expand_collapse(\'project_' . $p['project_id'] . '_\', \'tblProjects\',\'expand\',0,2);" id="project_' . $p['project_id'] . '__expand" src="' . w2PfindImage('down22.png', $m) . '" border="0" width="22" height="22" align="center" ' . ($expanded ? 'style="display:none"' : '') . ' alt="" /></a>' . w2PendTip(); ?> <tr> <td> <form name="assFrm<?php echo $p['project_id']; ?> " action="index.php?m=<?php
</td> <td align="left" nowrap="nowrap"> <input class="button" type="submit" name="do_report" value="<?php echo $AppUI->_('submit'); ?> " /> </td> </tr> </table> </form> <?php echo $AppUI->_('P') . ' = ' . $AppUI->_('User specific Task Priority'); if ($do_report) { // get Users with all Allocation info (e.g. their freeCapacity) $tempoTask = new CTask(); $userAlloc = $tempoTask->getAllocation("user_id"); // Let's figure out which users we have $sql = new DBQuery(); $sql->addTable('users'); $sql->addQuery('user_id, user_username'); if ($log_userfilter != 0) { $sql->addWhere('user_id = ' . $log_userfilter); } $sql->addOrder('user_username'); $user_list = $sql->loadHashList('user_id'); $sql->clear(); $ss = $start_date->format(FMT_DATETIME_MYSQL); $se = $end_date->format(FMT_DATETIME_MYSQL); $sql->addTable('tasks', 't'); $sql->innerJoin('projects', 'p', 'p.project_id = t.task_project'); if ($log_userfilter != 0) {