$toolid = $_POST['Tool_ID'];
} else {
$toolid = '';
}
///get tool_id if we are editing an existing tool.
$tool->setToolDesc($_POST['tooldesc']);
$tool->setMfgPartNO($_POST['mfgpartno']);
if (isset($_POST['Tool_Type_ID'])) {
$tool->setTypeID($_POST['Tool_Type_ID']);
} else {
if (isset($_POST['Tool_Type_ID_E'])) {
$tool->setTypeID($_POST['Tool_Type_ID_E']);
}
}
if (isset($_POST['cdiameter'])) {
$tool->setCdiameter($_POST['cdiameter']);
}
if (isset($_POST['tbodyinsert'])) {
$tool->setToolBodyInsert($_POST['tbodyinsert']);
}
if (isset($_POST['ndiameter'])) {
$tool->setNdiameter($_POST['ndiameter']);
}
if (isset($_POST['sdiameter'])) {
$tool->setSdiameter($_POST['sdiameter']);
}
if (isset($_POST['flutelength'])) {
$tool->setFluteLength($_POST['flutelength']);
}
if (isset($_POST['cornerradius'])) {
$tool->setCornerRadius($_POST['cornerradius']);
$sel = new selectlist('Tool_Type_ID', $ttype->getTypeList(), 'Select Tool Type', 'Tool_Type_ID', 'Tool_Type', '', $sid);
break;
case 'tbodytype':
$tbodytype = new Tbodytype();
$tbodytype->createTypeList();
if (isset($_GET['tbodytypeid'])) {
$sid = $_GET['tbodytypeid'];
} else {
$sid = '';
}
$sel = new selectlist('ToolBody_Type_ID', $tbodytype->getBodyTypeList(), 'Select Tool Body Type', 'ToolBody_Type_ID', 'ToolBody_Desc', '', $sid);
break;
case 'tool':
$tool = new Tool();
if (isset($_GET['tdia'])) {
$tool->setCdiameter($_GET['tdia']);
}
if (isset($_GET['ttyid'])) {
$tool->setTypeID($_GET['ttyid']);
}
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = 'Tool_ID';
}
if (isset($_GET['label'])) {
$label = $_GET['label'];
} else {
$label = "Select Tool To Edit";
}
$tool->setTypeID($_GET['ttyid']);
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>";
}
}
}