PHP Show_Project_Usersの例

コード例 #1

ファイル: story_Preview.php プロジェクト: paul-lab/practical-agile

function ViewTasks($thisproject, $ThisStory)
{
    global $DBConn;
    $task_sql = 'SELECT * FROM task where task.Story_AID=' . $ThisStory . ' order by task.Rank';
    $task_Res = mysqli_query($DBConn, $task_sql);
    if ($task_Row = mysqli_fetch_array($task_Res)) {
        do {
            echo '<div class="taskRow">' . '<div class="taskCell"><input class="done" id="done_' . $task_Row['ID'] . '" ' . ($task_Row['Done'] == 1 ? 'checked' : '') . ' value="1" disabled="disabled" type="checkbox" name="Done"></div>' . '<div class="taskCell"><input size="80" id="desc_' . $task_Row['ID'] . '" type="text" disabled="disabled" value="' . $task_Row['Desc'] . '"/></div>' . '<div class="taskCell">' . Show_Project_Users($thisproject, $task_Row['User_ID'], "user_" . $task_Row['ID'], 1) . '</div>' . '<div class="taskCell"><input id="expected_' . $task_Row['ID'] . '" type="text" disabled="disabled" size="2" value="' . $task_Row['Expected_Hours'] . '"/></div>' . '<div class="taskCell"><input id="actual_' . $task_Row['ID'] . '" type="text" disabled="disabled" size="2" value="' . $task_Row['Actual_Hours'] . '"/></div>' . '</div>';
        } while ($task_Row = mysqli_fetch_array($task_Res));
    }
}

コード例 #2

ファイル: task_List.php プロジェクト: paul-lab/practical-agile

function GetTasks($ThisProject, $ThisStory)
{
    global $DBConn;
    // The task list must be wrapped inside a div in the host document as follows.
    //	echo '<div class="taskdialog" id="alltasks_'.$ThisStory.'">';
    echo '<ul id="sortabletask' . $ThisStory . '">';
    $task_sql = 'SELECT * FROM task where task.Story_AID=' . $ThisStory . ' order by Rank, ID';
    $task_Res = mysqli_query($DBConn, $task_sql);
    if ($task_Row = mysqli_fetch_array($task_Res)) {
        do {
            echo '<li class="divRow" id=task_' . $task_Row['ID'] . '>' . '<div class="divCell1 edittask" id="edittask_' . $task_Row['ID'] . '">' . '<img src="images/edit-small.png">' . '</div>' . '<div class="divCell1 savetask" id="savetask_' . $task_Row['ID'] . '">' . '<img src="images/tick-small.png">' . '</div>' . '<div class="divCell1"><input class="done indet' . $task_Row['Done'] . '" id="done_' . $task_Row['ID'] . '" ' . ($task_Row['Done'] == 2 ? 'checked' : '') . ' value="' . $task_Row['Done'] . '" type="checkbox" name="Done"></div>' . '<div class="divCell1"><input size="80" id="desc_' . $task_Row['ID'] . '" type="text" disabled="disabled" value="' . $task_Row['Desc'] . '"/></div>' . '<div class="divCell1">' . Show_Project_Users($ThisProject, $task_Row['User_ID'], "user_" . $task_Row['ID'], 1) . '</div>' . '<div class="divCell1"><input id="expected_' . $task_Row['ID'] . '" type="text" disabled="disabled" size="2" value="' . $task_Row['Expected_Hours'] . '"/></div>' . '<div class="divCell1"><input id="actual_' . $task_Row['ID'] . '" type="text" disabled="disabled" size="2" value="' . $task_Row['Actual_Hours'] . '"/></div>' . '<div class="divCell1 deletetask"><img src="images/delete-small.png"></div>' . '</li>';
        } while ($task_Row = mysqli_fetch_array($task_Res));
    }
    echo '</ul>';
    echo '<div class="micromenudiv-input" id="newrow_' . $ThisStory . '">' . '<img class="savenew" src="images/add-small.png"> ' . '<input id="ndesc_' . $ThisStory . '" title="Task Description" name = "Desc" value="" size="80">' . Show_Project_Users($ThisProject, "0", "taskuser_" . $ThisStory) . ' <input id="nexph_' . $ThisStory . '"  title="Expected hours" name = "Expected_Hours" value="" size="2">' . '<input id="nacth_' . $ThisStory . '"  title="Actual Hours" name = "Actual_Hours" value="" size="2">' . ' <input type="hidden" id="pid_' . $ThisStory . '" name = "pid" value="' . $_REQUEST['PID'] . '"/>';
    echo '</div>';
    //	echo '</div>';
}

コード例 #3

ファイル: story_Edit.php プロジェクト: paul-lab/practical-agile

        echo '</td></tr><tr><td>&nbsp;</td><td>';
        echo iterations_Dropdown($story_Row['Project_ID'], $story_Row['Iteration_ID']);
        echo '&nbsp;&nbsp;&nbsp;';
        echo print_Story_Status_Dropdown($story_Row['Status']);
    } else {
        echo $story_Row['Size'] . ' points &nbsp;&nbsp;&nbsp;';
        echo '</td></tr><tr><td>&nbsp;</td><td>';
        echo 'No Iteration';
        echo '&nbsp;&nbsp;&nbsp;';
        echo 'N/A';
        echo '	<input type="hidden" name="Iteration_ID" value="' . $story_Row['Iteration_ID'] . '">';
        echo '	<input type="hidden" name=""Status"" value="">';
    }
    echo '&nbsp;&nbsp;&nbsp;';
    echo print_Story_Type_Dropdown($story_Row['Type']) . '&nbsp;&nbsp;&nbsp;';
    echo Show_Project_Users($_REQUEST['PID'], $story_Row['Owner_ID'], "Owner_ID");
    echo '&nbsp;&nbsp;&nbsp;';
    ?>
			Blocked? <input <?php 
    echo $story_Row['Blocked'] == 1 ? 'checked' : '0';
    ?>
 value="1" type="checkbox" name="Blocked">&nbsp;&nbsp;&nbsp;
		</td>
	</tr>
	<tr>
		<td>Parent:</td>
		<td>
			<input type="text" title="Parent must be in the backlog and in a Todo Status to be used as a parent" name="manualParent" size=3 value="">&nbsp; &nbsp;
			<?php 
    echo print_Possible_Parent($_REQUEST['PID'], $story_Row['Parent_Story_ID']);
    ?>