$sql = 'SELECT * FROM story where project_ID=' . $Rowp['relproj'] . ' and AID IN(' . $instr . ') order by story.project_ID, story.Epic_Rank';
$tree_Res = mysqli_query($DBConn, $sql);
echo ' <a href="#" class="btnCollapseAll" id="' . $Rowp['relproj'] . '">Collapse</a>/';
echo '<a href="#" class="btnExpandAll" id="' . $Rowp['relproj'] . '">Expand</a>';
echo '<div class="tree" id="tree' . $Rowp['relproj'] . '"><ul><li class="larger">' . Get_Project_Name($Rowp['relproj']) . '<ul>';
GetTree($tree_Res, 'nodnd');
echo '</li></ul></ul>';
echo '</div>';
}
} elseif ($_REQUEST['Root'] == 0) {
// Project Tree
echo '<table align="center" width=90%><tr><td align="center">';
print_summary($Project['Points_Object_ID'], True);
// with velocity
echo '</td></tr><tr><td align="center">';
print_Graphx($Project['Points_Object_ID'], False);
// Not Small
echo '</td></tr></table>';
$sql = 'SELECT * FROM story where story.Project_ID=' . $_REQUEST['PID'] . ' and Parent_Story_ID=0 order by story.Epic_Rank';
GetTreeRoot($sql);
} else {
GetTreeRoot($sql);
}
}
// start Scrum Board
if ($_REQUEST['Type'] == 'board') {
$colcount == 0;
echo '<br>';
echo '<span id="' . $_REQUEST['PID'] . '">';
$sql = 'SELECT * FROM story_status where story_status.Project_ID=' . $_REQUEST['PID'] . ' and LENGTH(story_status.Desc)>0 order by story_status.Order';
$status_Res = mysqli_query($DBConn, $sql);
} else {
echo '<td> </td>';
}
echo '<td>' . '<a href="story_List.php?PID=' . $_REQUEST['PID'] . '&IID=' . $iteration_Row['ID'] . '"' . ' title="' . $iteration_Row['Start_Date'] . ' -> ' . $iteration_Row['End_Date'] . '">' . substr($iteration_Row['Name'], 0, 32) . '</a>';
if ($iteration_Row['ID'] != $Project['Backlog_ID']) {
echo '<br><center>' . $iteration_Row['Start_Date'] . '<br>to<br> ' . $iteration_Row['End_Date'];
} else {
echo '<div class="evenlarger"><center><b>Velocity<br>' . $Project['Velocity'] . '</b></center></div>';
}
if ($iteration_Row['Locked'] == 1) {
echo '<p><b>Locked</b>';
}
echo '</center></td>' . '<td>' . substr($iteration_Row['Objective'], 0, 64) . '</td>' . '<td>' . '<table><tr><td>';
print_summary($iteration_Row['Points_Object_ID'], False);
// without velocity
echo '</td><td> ';
print_Graphx($iteration_Row['Points_Object_ID'], True);
// Not Small
echo '</td></tr></table></td>' . '<td>';
if ($iteration_Row['Name'] != 'Backlog') {
if ($isProjectAdmin and $iteration_Row['nums'] == 0) {
echo '<a href="iteration_Delete.php?IID=' . $iteration_Row['ID'] . '&PID=' . $_REQUEST['PID'] . '&OID=' . $iteration_Row['Object_ID'] . '"><img src="images/delete.png"></a>';
} else {
echo ' ';
}
}
echo ' </td>' . '</tr>';
} while ($iteration_Row = mysqli_fetch_assoc($iteration_Res));
}
echo '</table>';
include 'include/footer.inc.php';
$result = mysqli_fetch_assoc($queried);
return $result['Desc'];
}
$showForm = true;
if ($showForm) {
if (!empty($_REQUEST['PID'])) {
$project_Res = mysqli_query($DBConn, 'SELECT * FROM project WHERE ID = ' . $_REQUEST['PID']);
$project_Row = mysqli_fetch_assoc($project_Res);
} else {
$project_Row = $_REQUEST;
}
echo '<table align="center" width=90%><tr><td align="center">';
print_summary($project_Row['Points_Object_ID'], True);
// with velocity
echo '</td></tr><tr><td align="center">';
print_Graphx($project_Row['Points_Object_ID'], False);
// Not Small
echo '</td></tr></table>';
echo '<div class="hidden" id="phpnavicons" align="Left">' . '<a title="Add new story to backlog" href="story_Edit.php?PID=' . $_REQUEST['PID'] . '&IID=' . $project_Row['Backlog_ID'] . '"><img src="images/storyadd-large.png"></a> ' . ' <a title="Project Epic tree" href="story_List.php?Type=tree&Root=0&PID=' . $_REQUEST['PID'] . '&IID=' . $project_Row['Backlog_ID'] . '"><img src="images/tree-large.png"></a>' . ' <a title="Backlog List" href="story_List.php?PID=' . $_REQUEST['PID'] . '&IID=' . $project_Row['Backlog_ID'] . '"><img src="images/list-large.png"></a>' . '</div>';
echo '<table align="center" cellpadding="6" cellspacing="0" border="0">';
?>
<tr>
<td>
<br><?php
echo $project_Row['Category'];
?>
</td>
<td colspan=3>
<b><?php
