{
$insbody = array(2, 3, 4);
$db = Database::getInstance();
$cxn = $db->getConnection();
if ($this->toolid != '') {
$query = "SELECT tb.ToolBody_ID,CONCAT(Brand_Description,' Make ',Tool_Desc) as td FROM ToolBody_Insert as tbi\n\t\t\t\tINNER JOIN ToolBody as tb ON tb.ToolBody_ID=tbi.ToolBody_ID\n\t\t\t\tINNER JOIN Tool AS t ON t.Tool_ID=tbi.Tool_ID\n\t\t\t\tINNER JOIN Tool_Brand as tbr on tbr.Brand_ID=t.Brand_ID WHERE tbi.Tool_ID={$this->toolid}";
// print("$query<br>");
if (!($res = $cxn->query($query))) {
echo "error :", $cxn->error;
} else {
$rows = array();
while ($r = mysqli_fetch_assoc($res)) {
$rows[] = $r;
}
$this->toolbodyinsertlist = json_encode($rows);
}
}
}
//end creatOperatorList function
function getToolBodyInsertList()
{
return $this->toolbodyinsertlist;
}
}
//end of class Tool
if (isset($_GET['bid']) && $_GET['bid'] != '') {
$toolbody = new Toolbody();
$toolbody->setBrandID($_GET['bid']);
$toolbody->createToolBodyList();
$sel = new selectlist('ToolBody_ID', $toolbody->getToolBodyList(), 'Select Tool Body', 'ToolBody_ID', 'td', '', '');
}
$toolbody->setSdiameter($_POST['sdiameter']);
}
if (isset($_POST['flutelength'])) {
$toolbody->setFluteLength($_POST['flutelength']);
}
if (isset($_POST['reach'])) {
$toolbody->setReach($_POST['reach']);
}
if (isset($_POST['toolmaterial'])) {
$toolbody->setBodyMaterial($_POST['toolmaterial']);
}
if (isset($_POST['noofflutes'])) {
$toolbody->setNoOfFlutes($_POST['noofflutes']);
}
if (isset($_POST['Brand_ID'])) {
$toolbody->setBrandID($_POST['Brand_ID']);
} else {
if (isset($_POST['Brand_ID_E'])) {
$toolbody->setBrandID($_POST['Brand_ID_E']);
}
}
if (isset($_POST['minimumstock'])) {
$toolbody->setMinimumStock($_POST['minimumstock']);
}
if (isset($_POST['toolremarks'])) {
$toolbody->setToolRemarks($_POST['toolremarks']);
}
if (isset($_POST['tooloal'])) {
$toolbody->setToolOAL($_POST['tooloal']);
}
if (isset($_POST['tmax'])) {
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();
}
}
}
