{ $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(); } } }