Пример #1
0
     if (isset($_GET['ttyid'])) {
         $toolbody->setTypeID($_GET['ttyid']);
     }
     if (isset($_GET['tid'])) {
         $toolbody->setToolID($_GET['tid']);
     }
     if (isset($_GET['id'])) {
         $id = $_GET['id'];
     } else {
         $id = 'ToolBody_ID';
     }
     if (isset($_GET['filterinsert'])) {
         $toolbody->setFilterInsert();
     }
     $toolbody->createToolBodyList();
     $sel = new selectlist($id, $toolbody->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', '');
     break;
 case 'toolstock':
     $toolstock = new Toolstock();
     if (isset($_GET['tid'])) {
         $toolstock->setToolID($_GET['tid']);
     }
     if (isset($_GET['tsv'])) {
         $toolstock->setValue('tsv', $_GET['tsv']);
     }
     $toolstock->createToolStockList();
     if (isset($_GET['tsv'])) {
         $sel = new selectlist('ToolStock_ID', $toolstock->getToolStockList(), 'Select Tool', 'Stock_ID', 'Stock_ID', '', '');
     } else {
         $sel = new selectlist('ToolStock_ID', $toolstock->getToolStockList(), 'Select Tool', 'ToolStock_ID', 'tsid', '', '');
     }
Пример #2
0
    function showToolUI()
    {
        if ($this->toolid == '') {
            echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>

   \t\t\t\t<p>
     \t\t\t\t<label>Tool Description</label>
     \t\t\t\t<input id="tooldesc" name="tooldesc" size="25" required/>
     \t\t\t\t<input id="tbodyinsert" name="tbodyinsert" type="hidden">
   \t\t\t\t</p>

   \t\t\t\t<p>
     \t\t\t\t<label>Manufacturres's Part NO</label>
     \t\t\t\t<input id="mfgpartno" name="mfgpartno" size="25" required/>
   \t\t\t\t</p>
_END;
            if ($this->typeid != 18) {
                echo <<<_END
   \t\t\t\t<p>
\t\t\t     <label>Cutting Dia (Dc)</label>
\t\t\t     <input id="cdiameter" name="cdiameter" size="25" class="number"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Shank Diameter (Ds)</label>
\t\t\t     <input id="sdiameter" name="sdiameter" size="25" class="number"/>
\t\t\t   </p>
_END;
                if ($this->typeid != 3) {
                    echo <<<_END
\t\t   \t\t\t\t<p>
\t\t\t\t\t     <label>Neck Diameter (Dn)</label>
\t\t\t\t\t     <input id="ndiameter" name="ndiameter" size="25" class="number"/>
\t\t\t\t\t   </p>
_END;
                }
                echo <<<_END
\t\t  \t\t\t   <p>
\t\t\t\t\t     <label>Neck Length/Reach (NL)</label>
\t\t\t\t\t     <input id="reach" name="reach" size="25" class="number greaterThan" data-min="flutelength"/>
\t\t\t\t\t   </p>



\t\t\t   <p>
\t\t\t     <label>Flute Length (FL)</label>
\t\t\t     <input id="flutelength" name="flutelength" size="25"  class="required number"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Overall Length (OAL)</label>
\t\t\t     <input id="tooloal" name="tooloal" size="25" class="number greaterThan" data-min="flutelength" data-min="reach"/>
\t\t\t   </p>

_END;
                if ($this->typeid == 9) {
                    echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Max Radial Depth (Tmax)</label>
\t\t\t     <input id="tmax" name="tmax" size="25" class="number" class="required"/>
\t\t\t   </p>
_END;
                }
                echo <<<_END


\t\t\t   <p>
\t\t\t     <label>Tool Material</label>
\t\t\t     <input type="text" id="toolmaterial" name="toolmaterial" size="25"/>
\t\t\t   </p>

_END;
            }
            if ($this->typeid != 3) {
                echo <<<_END

\t\t\t\t\t   <p>
\t\t   \t\t\t     <label>Corner Radius (CRR)</label>
\t\t\t\t\t     <input id="cornerradius" name="cornerradius" size="25" class="number"/>
\t\t\t\t\t   </p>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Corner Chamfer (CHL)</label>
\t\t\t\t\t     <input id="cornerchamfer" name="cornerchamfer" size="25" class="number"/>
\t\t\t\t\t   </p>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Chamfer Angle (CHA)</label>
\t\t\t\t\t     <input id="chamferangle" name="chamferangle" size="25" class="number"/>
\t\t\t\t\t   </p>
_END;
            }
            echo <<<_END
\t\t\t   <p>
\t\t\t     <label>No Of Cutting Edges</label>
\t\t\t     <input id="noofflutes" name="noofflutes" size="25" class="required number"/>
\t\t\t   </p>

\t\t\t   <p>
\t\t\t     <label>Coating</label>
\t\t\t     <input type="text" id="coating" name="coating" size="25"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Tool Remarks</label>
\t\t\t     <input id="toolremarks" name="toolremarks" size="25"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Min Stock Qty</label>
\t\t\t     <input id="minimumstock" name="minimumstock" size="25" class="number"/>
\t\t\t   </p>
\t\t      <p>
\t\t\t    <label>Select Tool Preview Image/File</label>
\t\t\t\t<input name="preview[]" type="file" multiple="true"/>
   \t\t\t\t</p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>
_END;
        } else {
            $db = Database::getInstance();
            $cxn = $db->getConnection();
            $q = "SELECT * FROM Tool WHERE Tool_ID={$this->toolid}";
            if (!($res = $cxn->query($q))) {
                echo "error :", $cxn->error;
            } else {
                $row = mysqli_fetch_assoc($res);
                $ttype = new TType();
                $ttype->createTypeList();
                $toolbody = new Toolbody();
                $toolbody->setBrandID($row['Brand_ID']);
                $toolbody->createToolBodyList();
                echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>
   \t\t\t\t<p>
     \t\t\t\t<label>Tool Type</label>
_END;
                $sel = new selectlist('Tool_Type_ID_E', $ttype->getTypeList(), 'Select Tool Type', 'Tool_Type_ID', 'Tool_Type', '', $row['Tool_Type_ID']);
                if ($row['Tool_Type_ID'] == 18) {
                    print '<input id="tbodyinsert" name="tbodyinsert" type="hidden">';
                    print "<p><label>Tool Type</label>";
                    print "<table><tr><td>";
                    $sel = new selectlist('ToolBody_ID', $toolbody->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', '');
                    print "</td><td><input type=\"button\" id=\"tbadd\" value=\"Add\"></td></tr></table>";
                    self::listToolBodyforInsert();
                }
                echo <<<_END
   \t\t\t\t</p>
   \t\t\t\t<p>
   \t\t\t\t<label>Tool ID</label>{$this->toolid}
   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<label>Tool Description</label>
     \t\t\t\t<input id="tooldesc" name="tooldesc" size="25" required value="{$row['Tool_Desc']}"/>
   \t\t\t\t</p>

   \t\t\t\t<p>
     \t\t\t\t<label>Manufacturres's Part NO</label>
     \t\t\t\t<input id="mfgpartno" name="mfgpartno" size="25" required value="{$row['Mfg_Part_NO']}"/>
   \t\t\t\t</p>
_END;
                if ($this->typeid != 18) {
                    echo <<<_END
   \t\t\t\t<p>
\t\t\t     <label>Cutting Dia (Dc)</label>
\t\t\t     <input id="cdiameter" name="cdiameter" size="25" class="number" value="{$row['Cutting_Dia']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Shank Diameter (Ds)</label>
\t\t\t     <input id="sdiameter" name="sdiameter" size="25" class="number" value="{$row['Shank_Dia']}"/>
\t\t\t   </p>
_END;
                    if ($this->typeid != 3) {
                        echo <<<_END

   \t\t\t\t<p>
\t\t\t     <label>Neck Diameter (Dn)</label>
\t\t\t     <input id="ndiameter" name="ndiameter" size="25" class="number" value="{$row['Neck_Dia']}"/>
\t\t\t   </p>
_END;
                    }
                    echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Flute Length (FL)</label>
\t\t\t     <input id="flutelength" name="flutelength" size="25"  class="required number" value="{$row['Tool_FL']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Neck Length/Reach (NL)</label>
\t\t\t     <input id="reach" name="reach" size="25" class="number greaterThan" data-min="flutelength" value="{$row['Neck_Length']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Overall Length (OAL)</label>
\t\t\t     <input id="tooloal" name="tooloal" size="25" class="number greaterThan" data-min="flutelength" data-min="reach" value="{$row['Tool_OAL']}"/>
\t\t\t   </p>
_END;
                    if ($this->typeid == 9) {
                        echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Max Radial Depth (Tmax)</label>
\t\t\t     <input id="tmax" name="tmax" size="25" class="number" class="required" value="{$row['T_Max']}"/>
\t\t\t   </p>
_END;
                    }
                    echo <<<_END

\t\t\t   <p>
\t\t\t     <label>Tool Material</label>
\t\t\t     <input type="text" id="toolmaterial" name="toolmaterial" size="25" value="{$row['Material']}"/>
\t\t\t   </p>
_END;
                }
                if ($this->typeid != 3) {
                    echo <<<_END
\t\t\t   <p>
\t\t\t     <label>Corner Radius (CRR)</label>
\t\t\t     <input id="cornerradius" name="cornerradius" size="25" class="number" value="{$row['Corner_Rad']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Corner Chamfer (CHL)</label>
\t\t\t     <input id="cornerchamfer" name="cornerchamfer" size="25" class="number" value="{$row['Corner_Chamfer']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Chamfer Angle (CHA)</label>
\t\t\t     <input id="chamferangle" name="chamferangle" size="25" class="number" value="{$row['Chamfer_Angle']}"/>
\t\t\t   </p>
_END;
                }
                echo <<<_END
\t\t\t   <p>
\t\t\t     <label>No Of Cutting Edges</label>
\t\t\t     <input id="noofflutes" name="noofflutes" size="25" class="required number" value="{$row['No_Of_Edges']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Coating</label>
\t\t\t     <input type="text" id="coating" name="coating" size="25" value="{$row['Tool_Coating']}"/>
\t\t\t   </p>

\t\t\t   <p>
\t\t\t     <label>Tool Remarks</label>
\t\t\t     <input id="toolremarks" name="toolremarks" size="25" value="{$row['Tool_Remarks']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Min Stock Qty</label>
\t\t\t     <input id="minimumstock" name="minimumstock" size="25" class="number" value="{$row['Min_Stock_Qty']}"/>
\t\t\t   </p>
\t\t      <p>
\t\t\t    <label>Select Tool Preview Image/File</label>
\t\t\t\t<input name="preview[]" type="file" multiple="true"/>
   \t\t\t\t</p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
                self::listPreviewImage();
            }
        }
    }
Пример #3
0
    function showOpeToolUI()
    {
        $ttype = new TType();
        $ttype->createTypeList();
        $toolbody = new Toolbody();
        $toolbody->createToolBodyList();
        $holder = new Holder();
        $holder->createHolderList();
        if ($this->opedrawingid == '') {
            echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>
\t\t\t\t<fieldset><legend>Preferred Tool </legend>
   \t\t\t\t<p>
     \t\t\t\t<label>Select Tool Type</label>
_END;
            $sel = new selectlist('Tool_Type_ID_1', $ttype->getTypeList(), 'Select Tool Type', 'Tool_Type_ID', 'Tool_Type', '', '', '');
            echo <<<_END
   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<label>Tool Diameter</label>
     \t\t\t\t<input id="dia1" name="dia1" size="25" required/>
   \t\t\t\t</p>
   \t\t\t\t<p>
   \t\t\t\t<div id="tdia1"> </div>
   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<div id="tbody1"> </div>
\t\t\t\t\t   <p>
\t\t   \t\t\t     <label>Tool Holder</label>
_END;
            $sel = new selectlist('Holder_ID_1', $holder->getHolderList(), 'Select Holder', 'Holder_ID', 'Holder_Description', '', '', '');
            echo <<<_END
\t
\t\t\t\t\t   </p>
\t\t\t\t\t   </fieldset>
\t\t\t\t<fieldset><legend>Alternate Tool </legend>
   \t\t\t\t<p>
     \t\t\t\t<label>Select Tool Type</label>
_END;
            $sel = new selectlist('Tool_Type_ID_2', $ttype->getTypeList(), 'Select Tool Type', 'Tool_Type_ID', 'Tool_Type', '', '', '');
            echo <<<_END
   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<label>Tool Diameter</label>
     \t\t\t\t<input id="dia2" name="dia2" size="25"/>
   \t\t\t\t</p>
   \t\t\t\t<div id="tdia2"> </div>
   \t\t\t\t</p>

   \t\t\t\t<p>
     \t\t\t\t<div id="tbody2"> </div>
\t\t\t\t\t   <p>
\t\t   \t\t\t     <label>Tool Holder</label>
_END;
            $sel = new selectlist('Holder_ID_2', $holder->getHolderList(), 'Select Holder', 'Holder_ID', 'Holder_Description', '', '', '');
            echo <<<_END
\t
\t\t\t\t\t   </p>
\t\t\t\t\t   </fieldset>
\t\t\t\t\t   <fieldset><legend>Tool Working Details</legend>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Tool Projection from Holder</label>
\t\t\t\t\t     <input id="tooloh" name="tooloh" size="25" class="required number"/>
\t\t\t\t\t   </p>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Work Description</label>
\t\t\t\t\t     <input id="desc" name="desc" size="25" class="required"/>
\t\t\t\t\t   </p>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Tool Cutting Time in mins</label>
\t\t\t\t\t     <input id="cuttingmins" name="cuttingmins" size="25" class="number"/>
\t\t\t\t\t   </p>
\t\t\t\t\t   <p>
\t\t\t\t\t     <label>Tool Life</label>
\t\t\t\t\t     <input id="toollife" name="toollife" size="25" />
\t\t\t\t\t   </p>
\t\t\t\t\t</fieldset>
\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>

_END;
        } else {
            $db = Database::getInstance();
            $cxn = $db->getConnection();
            $q = "SELECT * FROM Ope_Tool WHERE Ope_Drawing_ID={$this->opedrawingid} AND Deleted=0";
            //				print($q);
            if (!($res = $cxn->query($q))) {
                exit("error : {$cxn->error}");
            }
            $i = 0;
            if ($res->num_rows > 0) {
                print "<p>Tools Aded To this Operation</p>";
                print "<table border=\"1\" cellspacing=\"1\" bgcolor=\"#7FFFD4\">";
                print "<tr><th>Delete</th><th>Preferred Tool</th><th>Preferred Holder</th><th>Alternate Tool</th><th>Alternate Holder</th>\n\t\t\t\t\t\t\t<th>Description</th><th>Tool OH</th><th>Cutting Time</th><th>Tool Life</th></tr>";
                while ($row = mysqli_fetch_assoc($res)) {
                    print "<tr><td>";
                    print "<input type=\"checkbox\" name=\"tdel[{$i}]\" value=\"{$row['Ope_Tool_ID']}\" >\n\t\t\t\t\t\t\t\t<input type=\"hidden\" name=\"otid[{$i}]\" value=\"{$row['Ope_Tool_ID']}\"></td><td>";
                    //preferred tool
                    $q1 = "SELECT * FROM Tool WHERE Tool_ID={$row['Tool_ID_1']}";
                    $res1 = $cxn->query($q1);
                    $row1 = mysqli_fetch_assoc($res1);
                    $tool = new Tool();
                    $tool->setCdiameter($row1['Cutting_Dia']);
                    $tool->setTypeID($row1['Tool_Type_ID']);
                    $tool->createToolList();
                    print "<table><tr><td>";
                    $sel = new selectlist('tid1[' . $i . ']', $tool->getToolList(), 'Select Tool', 'Tool_ID', 'td', '', $row['Tool_ID_1']);
                    print "</td></tr>";
                    $toolbody = new Toolbody();
                    $toolbody->setToolID($row['Tool_ID_1']);
                    $toolbody->createToolBodyList();
                    print "<tr><td><div id=\"bd1{$i}\">";
                    $sel = new selectlist('tbid1[' . $i . ']', $toolbody->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', $row['ToolBody_ID_1']);
                    print "</div></td></tr>";
                    print "</table></td><td>";
                    //preferred holder
                    $holder = new Holder();
                    $holder->createHolderList();
                    $sel = new selectlist('hid1[' . $i . ']', $holder->getHolderList(), 'Select Holder', 'Holder_ID', 'Holder_Description', '', $row['Holder_ID_1']);
                    print "</td><td>";
                    //alternate tool
                    if ($row['Tool_ID_2'] != 0) {
                        $q2 = "SELECT * FROM Tool WHERE Tool_ID={$row['Tool_ID_2']}";
                    } else {
                        $q2 = "SELECT * FROM Tool WHERE Tool_ID={$row['Tool_ID_1']}";
                    }
                    $res2 = $cxn->query($q2);
                    $row2 = mysqli_fetch_assoc($res2);
                    $tool->setCdiameter($row2['Cutting_Dia']);
                    $tool->setTypeID($row2['Tool_Type_ID']);
                    $tool->createToolList();
                    print "<table><tr><td>";
                    $sel = new selectlist('tid2[' . $i . ']', $tool->getToolList(), 'Select Tool', 'Tool_ID', 'td', '', $row['Tool_ID_2']);
                    print "</td></tr>";
                    $toolbody2 = new Toolbody();
                    $toolbody2->setToolID($row['Tool_ID_2']);
                    $toolbody2->createToolBodyList();
                    print "<tr><td><div id=\"bd2{$i}\">";
                    $sel = new selectlist('tbid2[' . $i . ']', $toolbody2->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', $row['ToolBody_ID_2']);
                    print "</div></td></tr>";
                    print "</table></td><td>";
                    //alternate holder
                    $sel = new selectlist('hid2[' . $i . ']', $holder->getHolderList(), 'Select Holder', 'Holder_ID', 'Holder_Description', '', $row['Holder_ID_2']);
                    print "</td><td>";
                    print "<input type=\"text\" name=\"desc[{$i}]\" value=\"{$row['Ope_Tool_Desc']}\"></td>";
                    print "<td><input type=\"text\" name=\"toh[{$i}]\" size=\"5\" value=\"{$row['Ope_Tool_OH']}\"></td>";
                    print "<td><input type=\"text\" name=\"ct[{$i}]\" size=\"5\" value=\"{$row['Cutting_MIns']}\"></td>";
                    print "<td><input type=\"text\" name=\"tl[{$i}]\" size=\"5\" value=\"{$row['Ope_Tool_Life']}\"></td>";
                    $i++;
                }
                print "</table>\n\t\t\t\t\t   <p>\n\t\t\t\t\t     <input class=\"submit\" type=\"submit\" value=\"Save\"/><input type=\"button\" Value=\"Approve\" id=\"abutton\"><input name=\"appremarks\" size=\"50\" id=\"appremarks\">\n\t\t\t\t\t   </p>";
            } else {
                print "<p>No Tools Added for This Operation!!</p>";
            }
        }
    }
Пример #4
0
    function showTmiscUI()
    {
        if ($this->tmiscid == '') {
            echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Accessory Details</legend>
   \t\t\t\t<p>
     \t\t\t\t<label>Accessory Type</label>
\t\t\t     <select id="type" name="type" class="required">
\t\t\t     \t<option value="">Select Accessory Type</option>
\t\t\t     \t<option value="Screw">Screw</option>
\t\t\t     \t<option value="Wrench">Wrench</option>
\t\t\t     </select>

   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<label>Description</label>
     \t\t\t\t<input id="desc" name="desc" size="25" required/>
   \t\t\t\t</p>

   \t\t\t\t<p>
     \t\t\t\t<label>Manufacturres's Part NO</label>
     \t\t\t\t<input id="mfgpartno" name="mfgpartno" size="25" required/>
   \t\t\t\t</p>
\t\t\t     <label>Remarks</label>
\t\t\t     <input id="remarks" name="remarks" size="25"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Price</label>
\t\t\t     <input id="price" name="price" size="25" class="number"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Min Stock Qty</label>
\t\t\t     <input id="minimumstock" name="minimumstock" size="25" class="number"/>
\t\t\t   </p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>
_END;
        } else {
            $db = Database::getInstance();
            $cxn = $db->getConnection();
            $q = "SELECT * FROM ToolMisc WHERE ToolMisc_ID={$this->tmiscid}";
            $tbody = new Toolbody();
            $tbody->createToolBodyList();
            if (!($res = $cxn->query($q))) {
                echo "error :", $cxn->error;
            } else {
                $row = mysqli_fetch_assoc($res);
                switch ($row['Type']) {
                    case 'Screw':
                        $opt = '<option value="">Select Accessory</option>
			     					<option value="Screw" selected="selected">Screw</option>
			     					<option value="Wrench">Wrench</option>';
                        break;
                    case 'Wrench':
                        $opt = '<option value="">Select Accessory</option>
			     					<option value="Screw" >Screw</option>
			     					<option value="Wrench" selected="selected">Wrench</option>';
                        break;
                    default:
                        $opt = '<option value=""  selected="selected">Select Accessory</option>
			     					<option value="Screw">Screw</option>
			     					<option value="Wrench">Wrench</option>';
                        break;
                }
                echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Accessory Details</legend>
\t\t\t\t<p>
\t\t\t\t<label>Select Tool Body</label>
_END;
                $sel = new selectlist('ToolBody_ID_E', $tbody->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', $row['ToolBody_ID']);
                echo <<<_END
\t\t\t\t</p>
\t\t\t\t<p>
     \t\t\t\t<label>Accessory Type</label>
\t\t\t     <select id="type" name="type" class="required">
\t\t\t\t\t{$opt};
\t\t\t     </select>

   \t\t\t\t</p>
   \t\t\t\t<p>
     \t\t\t\t<label>Description</label>
     \t\t\t\t<input id="desc" name="desc" size="25" required value="{$row['Misc_Desc']}"/>
   \t\t\t\t</p>

   \t\t\t\t<p>
     \t\t\t\t<label>Manufacturres's Part NO</label>
     \t\t\t\t<input id="mfgpartno" name="mfgpartno" size="25" required value="{$row['Mfg_Part_NO']}"/>
   \t\t\t\t</p>
\t\t\t     <label>Remarks</label>
\t\t\t     <input id="remarks" name="remarks" size="25" value="{$row['Remarks']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Price</label>
\t\t\t     <input id="price" name="price" size="25" class="number" value="{$row['Price']}"/>
\t\t\t   </p>
\t\t\t   <p>
\t\t\t     <label>Min Stock Qty</label>
\t\t\t     <input id="minimumstock" name="minimumstock" size="25" class="number" value="{$row['Min_Stock_Qty']}"/>
\t\t\t   </p>

\t\t\t\t</fieldset>
\t\t\t   <p>
\t\t\t     <input class="submit" type="submit" value="Save"/>
\t\t\t   </p>


_END;
            }
        }
    }