<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include 'config.php';
include 'custom_functions.php';
echo "Add a Milestone <br />";
startform("addmilestone", "POST", "handle_add_milestone.php");
tbox("Name", "mname", "");
tbox("Date", "date", "");
stopform("Add Milestone");
//删除电影信息
$queryd = mysql_query($sqld2, $connect) or die("Executing failed 4");
$sql = "delete from {$MVE} where movid='{$selname}'";
//状态符合要求，可以进行删除
$query1 = mysql_query($sql, $connect) or die("Executing failed 2");
if (!$query1 || !$queryd) {
mysql_query('ROLLBACK');
print "deleting error-->rollback 2";
} else {
mysql_query('COMMIT');
print "<br><p id=\"thr_table\"><th>Deletion {$selname} OK!</th></p><br>";
}
}
print "<form method=post action=manager.php> <center>";
//(int)$tempid='11100';
startform();
$proc = $_POST["procecure"];
$add = $_POST["add"];
$doadd = $_POST["doadd"];
$save = $_POST["save"];
$dosave = $_POST["dosave"];
$del = $_POST["del"];
$dodel = $_POST["dodel"];
$casadedel = $_POST["casadedel"];
$roll_back = $_POST["roll_back"];
//$del_specified=$_POST["del_specified"];
$mod = $_POST["mod"];
$showmod = $_POST["showmod"];
$domod = $_POST["domod"];
//$srch=$_POST["srch"];
//$dosrch=$_POST["dosrch"];
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
echo "Modify a Developer\t<br />";
startform("moddev", "POST", "handle_mod_dev.php");
$id = $_GET['i'];
$f = myq("select * from developers where id={$id}");
$dname = $f[0]['name'];
$email = $f[0]['email'];
tbox("Name", "dname", $dname);
tbox("Email", "email", $email);
hidden("id", $id);
stopform("Modifify Developer");
} else {
echo "Please Select a Developer to Modify: <br />";
foreach ($feat = myq("select * from developers order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='mod_dev.php?i={$id}'>{$name}</a><br />";
}
}
}
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
echo "Modify a Feature <br />";
startform("modfeat", "POST", "handle_mod_feature.php");
$id = $_GET['i'];
$f = myq("select * from features where id={$id}");
$fname = $f[0]['name'];
$desc = $f[0]['description'];
$details = $f[0]['details'];
tbox("Feature", "fname", $fname);
tbox("Description", "desc", $desc);
tbox("Details", "details", $details);
hidden("id", $id);
stopform("Modifify Feature");
} else {
echo "Please Select a Feature to Modify: <br />";
foreach ($feat = myq("select * from features order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='mod_feature.php?i={$id}'>{$name}</a><br />";
}
}
}
echo "<option value='PENDING' selected='selected'>PENDING</option>";
} else {
echo "<option value='PENDING'>PENDING</option>";
}
if ($status == "IN PROGRESS") {
echo "<option value='IN PROGRESS' selected='selected'>IN PROGRESS</option>";
} else {
echo "<option value='IN PROGRESS'>IN PROGRESS</option>";
}
if ($status == "COMPLETED") {
echo "<option value='COMPLETED' selected='selected'>COMPLETED</option>";
} else {
echo "<option value='COMPLETED'>COMPLETED</option>";
}
echo "</select>";
hidden("id", $id);
stopform("Modify Task");
startform("bo", "POST", "breakout.php");
hidden("i", $id);
stopform("Breakout Task");
startform("clone", "POST", "clone.php");
hidden("i", $id);
stopform("Clone Task");
} else {
echo "Please Select a Task to View/Modify: <br />";
foreach ($feat = myq("select * from tasks order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
echo " <a href='tasks.php?i={$id}'>{$name}</a><br />";
}
}
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
$id = $_GET['i'];
$f = myq("select * from developers where id={$id}");
$dname = $f[0]['name'];
echo "Are you sure you want to remove {$dname}\tas a Developer<br />";
startform("deldev", "POST", "handle_rem_dev.php");
hidden("id", $id);
stopform("Yes");
startform("nodel", "POST", "del_dev.php");
hidden("id", $id);
stopform("No");
} else {
echo "Please Select a Developer to Remove: <br />";
foreach ($feat = myq("select * from developers order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='del_dev.php?i={$id}'>{$name}</a><br />";
}
}
}
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include 'config.php';
include 'custom_functions.php';
echo "Add a Developer <br />";
startform("addfeat", "POST", "handle_add_dev.php");
tbox("Name", "dname", "");
tbox("Email", "email", "");
stopform("Add Developer");
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_POST["i"];
if (isset($t)) {
echo "Original Task<br />";
startform("modtask", "POST", "handle_breakout.php");
$id = $_POST['i'];
$f = myq("select * from tasks where id={$id}");
$fname = $f[0]['name'];
$desc = $f[0]['description'];
$details = $f[0]['details'];
$dev = $f[0]['developer'];
$feat = $f[0]['feature'];
$mile = $f[0]['milestone'];
$eet = $f[0]['eet'];
$status = $f[0]['status'];
//name
tbox("Task", "tname", $fname);
//developer
select("Developer", "dev", "SELECT * FROM developers order by name", "name", "id", $dev, 0);
//feature
select("Feature", "feat", "SELECT * FROM features order by name", "name", "id", $feat, 0);
//milestone
select("Milestone", "milestone", "SELECT * FROM milestones order by name", "name", "id", $mile, 0);
tbox("Description", "description", $desc);
tbox("Details", "details", $details);
tbox("Expected Elapsed Time", "eet", $eet);
echo "<select name='status'>";
if ($status == "PENDING") {
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
echo "Modify a Milestone\t<br />";
startform("modmile", "POST", "handle_mod_milestone.php");
$id = $_GET['i'];
$f = myq("select * from milestones where id={$id}");
$mname = $f[0]['name'];
$date = $f[0]['date'];
tbox("Name", "mname", $mname);
tbox("Date", "date", $date);
hidden("id", $id);
stopform("Modifify Milestone");
} else {
echo "Please Select a Milestone to Modify: <br />";
foreach ($feat = myq("select * from milestones order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='mod_milestone.php?i={$id}'>{$name}</a><br />";
}
}
}
echo "<tr><td><a href='tasks.php?i={$tid}'>{$tname}</a></td><td>{$dname}</td><td>{$desc}</td><td>{$fname}</td><td>{$mname}</td><td>{$status}</td></tr>";
}
echo "</table>";
} else {
echo "Developers: <br />";
foreach ($dev = myq("SELECT * FROM developers order by name") as $k => $v) {
$id = $dev[$k]['id'];
$name = $dev[$k]['name'];
$email = $dev[$k]['email'];
if ($id != 1) {
echo "<a href='dev.php?i={$id}'>{$name}</a> - ";
//print seperator and then $email
echo "{$email}<br />";
}
}
startform("filter", "POST", "index.php");
echo "Filter by: <br /><table><tr><td>Developer</td><td>Status</td><td>Feature</td><td>Milestone</td></tr><tr><td>";
select_no("", "dev", "SELECT * FROM developers order by name", "name", "id", "1", 1);
echo "</td><td>";
echo "<select multiple name='status[]'>";
echo "<option value='PENDING'>PENDING</option>";
echo "<option value='IN PROGRESS'>IN PROGRESS</option>";
echo "<option value='COMPLETED'>COMPLETED</option>";
echo "</select>";
echo "</td><td>";
select_no("", "feature", "SELECT * FROM features order by name", "name", "id", "", 1);
echo "</td><td>";
select_no("", "milestone", "SELECT * FROM milestones order by name", "name", "id", "", 1);
echo "</td></tr>";
echo "</table>";
echo "<br />";
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_POST["i"];
if (isset($t)) {
echo "Add a Task <br />";
startform("modtask", "POST", "handle_add_task.php");
$id = $_POST['i'];
$f = myq("select * from tasks where id={$id}");
$fname = $f[0]['name'];
$desc = $f[0]['description'];
$details = $f[0]['details'];
$dev = $f[0]['developer'];
$feat = $f[0]['feature'];
$mile = $f[0]['milestone'];
$eet = $f[0]['eet'];
$status = $f[0]['status'];
//name
tbox("Task", "tname", $fname);
//developer
select("Developer", "dev", "SELECT * FROM developers order by name", "name", "id", $dev, 0);
//feature
select("Feature", "feat", "SELECT * FROM features order by name", "name", "id", $feat, 0);
//milestone
select("Milestone", "milestone", "SELECT * FROM milestones order by name", "name", "id", $mile, 0);
tbox("Description", "description", $desc);
tbox("Details", "details", $details);
tbox("Expected Elapsed Time", "eet", $eet);
echo "<select name='status'>";
if ($status == "PENDING") {
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
$id = $_GET['i'];
$f = myq("select * from milestones where id={$id}");
$mname = $f[0]['name'];
echo "Are you sure you want to remove {$mname}\tMilestone<br />";
startform("delmile", "POST", "handle_rem_milestone.php");
hidden("id", $id);
stopform("Yes");
startform("nodel", "POST", "del_milestone.php");
hidden("id", $id);
stopform("No");
} else {
echo "Please Select a Milestone to Remove: <br />";
foreach ($feat = myq("select * from milestones order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='del_milestone.php?i={$id}'>{$name}</a><br />";
}
}
}
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
include 'config.php';
include 'custom_functions.php';
echo "Add a Feature <br />";
startform("addfeat", "POST", "handle_add_feature.php");
tbox("Feature", "fname", "");
tbox("Description", "desc", "");
tbox("Details", "details", "");
stopform("Add Feature");
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_GET["i"];
if (isset($t)) {
$id = $_GET['i'];
$f = myq("select * from features where id={$id}");
$dname = $f[0]['name'];
echo "Are you sure you want to remove {$dname}\tas a Feature<br />";
startform("delfeat", "POST", "handle_rem_feat.php");
hidden("id", $id);
stopform("Yes");
startform("nodel", "POST", "del_feature.php");
hidden("id", $id);
stopform("No");
} else {
echo "Please Select a Feature to Remove: <br />";
foreach ($feat = myq("select * from features order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
if ($id != 1) {
echo " <a href='del_feature.php?i={$id}'>{$name}</a><br />";
}
}
}
<?php
include 'config.php';
include 'custom_functions.php';
$t = $_POST['del'];
if (!empty($t)) {
echo "Are you sure you want to remove the following tasks: <br />";
for ($i = 0; $i < count($t); $i++) {
$k = $t[$i];
$f = myq("select * from tasks where id={$k}");
$mname = $f[0]['name'];
echo "{$mname}\t<br />";
}
startform("deltask", "POST", "handle_rem_task.php");
foreach ($t as $key => $value) {
echo "<input type=hidden name='my_array[]' value='{$value}' />";
}
stopform("Yes");
} else {
echo "Please Select a Task to Remove: <br />";
startform("deletetask", "POST", "del_task.php");
foreach ($feat = myq("select * from tasks order by name") as $k => $v) {
$id = $feat[$k]['id'];
$name = $feat[$k]['name'];
echo " <input type='checkbox' name='del[]' value='{$id}'/> {$name} <br />";
}
stopform("Delete Task");
}
