<?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"); }