root / docs / www / colonyscout / internal / assembly_edit.php @ f59acf11
History | View | Annotate | Download (1.85 KB)
1 |
<script type="text/javascript"> |
---|---|
2 |
function submitForm()
|
3 |
{
|
4 |
document.editForm.submit();
|
5 |
}
|
6 |
</script>
|
7 |
|
8 |
<?php
|
9 |
if(!isset($_GET['q'])) { |
10 |
echo "<h1 style=\"color:#FF6600;\">Please search for a part..</h1>"; |
11 |
|
12 |
} else {
|
13 |
|
14 |
//must already be logged in
|
15 |
$get_assembly_sql = "SELECT * FROM assemblyinstructions WHERE id='".$_GET['q']."' LIMIT 1"; |
16 |
$get_assembly_res = mysqli_query($GLOBALS['mysqli'], $get_assembly_sql) or die(mysqli_error($GLOBALS['mysqli'])); |
17 |
|
18 |
while ($r = mysqli_fetch_array($get_assembly_res)) { |
19 |
$assm["data"] = $r; |
20 |
} |
21 |
?>
|
22 |
|
23 |
<div style="overflow:hidden;"> |
24 |
<div class="box-row"> |
25 |
<h1>Edit:</h1> |
26 |
</div>
|
27 |
|
28 |
|
29 |
<form name="editForm" action="assembly_edit_steps.php" target="editframe" method="post" class="niceform"> |
30 |
<fieldset>
|
31 |
<legend>Assembly Instruction Set</legend> |
32 |
<dl>
|
33 |
<dt><label for="title">Title:</label></dt> |
34 |
<dd><input type="text" name="title" value="<?php echo $assm['data']['Name']; ?>" id="email" size="50" maxlength="128" /></dd> |
35 |
</dl>
|
36 |
</fieldset>
|
37 |
<fieldset>
|
38 |
<legend>Edit Steps</legend> |
39 |
<SELECT name="stepNo" size="5" onChange="submit()" style="width:150px;font-size:20px;float:left;height:230px;"> |
40 |
<?php
|
41 |
$get_assembly_sql = "SELECT ID, StepNo FROM assemblysteps WHERE AssemblyID=\"".$_GET['q']."\" ORDER BY StepNo ASC"; |
42 |
$get_assembly_res = mysqli_query($GLOBALS['mysqli'], $get_assembly_sql) or die(mysqli_error($GLOBALS['mysqli'])); |
43 |
|
44 |
if (mysqli_num_rows($get_assembly_res)>0) { |
45 |
while ($r = mysqli_fetch_array($get_assembly_res)) { |
46 |
echo "<OPTION value=\"".$r['ID']."\">Step ".$r['StepNo']."</OPTION>"; |
47 |
} |
48 |
} |
49 |
?>
|
50 |
</SELECT>
|
51 |
<iframe name="editframe" src="assembly_edit_steps.php" width="100%" height="300" frameborder="0" scrolling="no" style="display:block; float:left; width:740px; height:230px;"> |
52 |
<p>Your browser does not support iframes.</p> |
53 |
</iframe>
|
54 |
|
55 |
</fieldset>
|
56 |
</div>
|
57 |
</div>
|
58 |
</form>
|
59 |
|
60 |
<?php
|
61 |
} |
62 |
?>
|
63 |
|
64 |
</div>
|