$supp->setValue('scopeidl', $_GET['scopeid']);
}
if (isset($_GET['onlyapproved'])) {
$supp->setValue('onlyapproved', $_GET['onlyapproved']);
}
if (isset($_GET['class'])) {
$class = 'class="required"';
} else {
$class = '';
}
$supp->createSupplierList();
$sel = new selectlist('Supplier_ID', $supp->getSupplierList(), 'Select Supplier', 'Supplier_ID', 'Supplier_Name', $class, '');
break;
case 'brand':
$brand = new Brand();
$brand->createBrandList();
$sel = new selectlist('Brand_ID', $brand->getBrandList(), 'Select Brand', 'Brand_ID', 'Brand_Description', '', '');
break;
case 'ttype':
$ttype = new TType();
$ttype->createTypeList();
if (isset($_GET['ttypeid'])) {
$sid = $_GET['ttypeid'];
} else {
$sid = '';
}
$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();
function showToolBodyUI()
{
if ($this->toolbodyid == '') {
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Body Details</legend>
\t\t\t\t<p>
\t\t\t\t<label>Tool Body Description</label>
\t\t\t\t<input id="tooldesc" name="tooldesc" 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\t<p>
\t\t\t <label>Cutting Dia/ Holding Dia Max (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>
\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"/>
\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"/>
\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"/>
\t\t\t </p>
\t\t\t <p>
\t\t\t <label>No Of Cutting Edges</label>
\t\t\t <input id="noofflutes" name="noofflutes" size="25" class="number"/>
\t\t\t </p>
_END;
if ($this->bodytypeid == 4) {
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 Body Material</label>
\t\t\t <input type="text" id="toolmaterial" name="toolmaterial" 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 ToolBody WHERE ToolBody_ID={$this->toolbodyid}";
if (!($res = $cxn->query($q))) {
echo "error :", $cxn->error;
} else {
$row = mysqli_fetch_assoc($res);
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Body Details</legend>
\t\t\t\t<p>
\t\t\t\t<label>Select Tool Body</label>
_END;
$brand = new Brand();
$brand->createBrandList();
$sel = new selectlist('Brand_ID_E', $brand->getBrandList(), 'Select Brand', 'Brand_ID', 'Brand_Description', '', $row['Brand_ID']);
echo <<<_END
\t\t\t\t<p>
\t\t\t\t<label>Tool Body 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><label>Tool Body ID</label>{$this->toolbodyid}</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\t<p>
\t\t\t <label>Cutting Dia / MAx Holding 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>
\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>
\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" value="{$row['Neck_Length']}"/>
\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" value="{$row['Tool_FL']}"/>
\t\t\t </p>
\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" value="{$row['Tool_OAL']}"/>
\t\t\t </p>
\t\t\t <p>
\t\t\t <label>No Of Cutting Edges</label>
\t\t\t <input id="noofflutes" name="noofflutes" size="25" class="number" value="{$row['No_Of_Edges']}"/>
\t\t\t </p>
_END;
if ($this->bodytypeid == 4) {
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>
\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();
}
}
}
