function showOpeToolBatchUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$q = "SELECT * From Ope_Tool_Batch WHERE Batch_ID={$this->batchid} AND Ope_Drawing_ID={$this->operevid}";
if (!($res = $cxn->query($q))) {
exit("error (showOpeToolBatchUI) {$q} : {$cxn->error}");
}
$r = $res->num_rows;
print '<table>';
if ($r == 0) {
print '<thead><tr><th class="v">Ope Tool ID</th><th class="v">Tool Description</th><th>Tool Used</th><th class="v">Tool Body Description</th><th>Tool Body Used</th><th class="v">Holder Description</th><th width:"25">Holder Used</th></tr></thead><tbody>';
$qs = "SELECT * FROM Ope_Tool WHERE Ope_Drawing_ID={$this->operevid} AND Deleted!=1";
if (!($ress = $cxn->query($qs))) {
echo "error :", $cxn->error;
}
$i = 0;
while ($row = mysqli_fetch_assoc($ress)) {
$id = $row['Ope_Tool_ID'];
$qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
if (!($rest = $cxn->query($qt))) {
echo "error :", $cxn->error;
}
$t = mysqli_fetch_assoc($rest);
$qh = "SELECT Holder_Description From Holder WHERE Holder_ID={$row['Holder_ID_1']}";
if (!($resh = $cxn->query($qh))) {
echo "error :", $cxn->error;
}
$h = mysqli_fetch_assoc($resh);
$qb = "SELECT Tool_Desc,Brand_Description,Mfg_Part_NO From ToolBody as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE ToolBody_ID={$row['ToolBody_ID_1']}";
if (!($resb = $cxn->query($qb))) {
echo "error :", $cxn->error;
}
$tb = mysqli_fetch_assoc($resb);
$optid = new Form(array('type' => 'hidden', 'id' => 'opetoolid[' . $i . ']', 'name' => 'opetoolid[' . $i . ']', 'value' => $row['Ope_Tool_ID']));
$tsid = new Form(array('id' => 'toolstockid[' . $i . ']', 'name' => 'toolstockid[' . $i . ']', 'class' => 'required', 'unique' => 'toolstockid'));
$tbsid = new Form(array('id' => 'toolbodystockid[' . $i . ']', 'name' => 'toolbodystockid[' . $i . ']'));
$hsid = new Form(array('id' => 'holderstockid[' . $i . ']', 'name' => 'holderstockid[' . $i . ']', 'class' => 'required number'));
echo <<<_END
\t\t\t\t\t\t\t<tr><th class="v">{$optid->ip} {$row['Ope_Tool_ID']}</th>
\t\t\t\t\t\t\t\t<th class="v">{$t['Brand_Description']} Make {$t['Tool_Desc']}</th><td>{$tsid->ip}</td>
\t\t\t\t\t\t\t\t<th class="v">{$tb['Brand_Description']} Make {$tb['Tool_Desc']}</th><td>{$tbsid->ip}</td>
\t\t\t\t\t\t\t\t<th class="v">{$h['Holder_Description']}</th><td>{$hsid->ip}</td></tr>
_END;
$i++;
}
} else {
///we are either changing a tool to returning back all tools
print '<thead><tr><th class="v">Ope Tool ID</th><th class="v">Tool Description</th><th>Tool Used</th><th>No Of Jobs</th><th>Storage Location</th>
<th class="v">Tool Body Description</th><th>Tool Body Used</th><th>Body Storage Location</th>
<th class="v">Holder Description</th><th width:"25">Holder Used</th><th>Holder Storage Location</th><th>Remarks</th></tr></thead><tbody>';
$qs = "SELECT * FROM Ope_Tool WHERE Ope_Drawing_ID={$this->operevid} AND Deleted!=1";
if (!($ress = $cxn->query($qs))) {
exit("error (showOpeToolBatchUI 2) {$qs} : {$cxn->error}");
}
$any = new Anylist();
$i = 0;
while ($row = mysqli_fetch_assoc($ress)) {
$qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
if (!($rest = $cxn->query($qt))) {
echo "error :", $cxn->error;
}
$t = mysqli_fetch_assoc($rest);
$qtt = "SELECT * FROM Ope_Tool_Batch WHERE Ope_Tool_ID={$row['Ope_Tool_ID']} AND Cutting_Mins=0 AND Qty=0";
if (!($restt = $cxn->query($qtt))) {
echo "error :", $cxn->error;
}
$tt = mysqli_fetch_assoc($restt);
$qt = "SELECT Tool_Desc,Brand_Description From Tool as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE Tool_ID={$row['Tool_ID_1']}";
if (!($rest = $cxn->query($qt))) {
echo "error :", $cxn->error;
}
$t = mysqli_fetch_assoc($rest);
$qh = "SELECT Holder_Description From Holder WHERE Holder_ID={$row['Holder_ID_1']}";
if (!($resh = $cxn->query($qh))) {
echo "error :", $cxn->error;
}
$h = mysqli_fetch_assoc($resh);
$qb = "SELECT Tool_Desc,Brand_Description,Mfg_Part_NO From ToolBody as t inner join Tool_Brand as tb on tb.Brand_ID=t.Brand_ID WHERE ToolBody_ID={$row['ToolBody_ID_1']}";
if (!($resb = $cxn->query($qb))) {
echo "error :", $cxn->error;
}
$tb = mysqli_fetch_assoc($resb);
if ($tt['Ope_Tool_Batch_ID'] != '') {
$optbid = new Form(array('type' => 'hidden', 'id' => 'opetoolbatchid[' . $i . ']', 'name' => 'opetoolbatchid[' . $i . ']', 'value' => $tt['Ope_Tool_Batch_ID']));
} else {
//if there in no tool associated with entry in tool list
$optbid = new Form(array('type' => 'hidden', 'id' => 'opetoolid[' . $i . ']', 'name' => 'opetoolid[' . $i . ']', 'value' => $row['Ope_Tool_ID']));
}
$tsid = new Form(array('id' => 'toolstockid[' . $i . ']', 'name' => 'toolstockid[' . $i . ']', 'class' => 'required', 'value' => $tt['Tool_Stock_ID'], 'unique' => 'toolstockid', 'size' => "10"));
$tbsid = new Form(array('id' => 'toolbodystockid[' . $i . ']', 'name' => 'toolbodystockid[' . $i . ']', 'value' => $tt['Tool_Body_Stock_ID'], 'size' => "10"));
$hsid = new Form(array('id' => 'holderstockid[' . $i . ']', 'name' => 'holderstockid[' . $i . ']', 'class' => 'required number', 'value' => $tt['Holder_Stock_ID'], 'unique' => 'holderstockid', 'size' => "10"));
$tqty = new Form(array('id' => 'jobqty[' . $i . ']', 'name' => 'jobqty[' . $i . ']', 'class' => 'number', 'value' => '0', 'size' => "10"));
$trem = new Form(array('id' => 'remarks[' . $i . ']', 'name' => 'remarks[' . $i . ']'));
echo <<<_END
\t\t\t\t\t\t\t<tr><th class="v" style="width:30px">{$optbid->ip} {$row['Ope_Tool_ID']}</th>
\t\t\t\t\t\t\t\t<th class="v" style="width:100px">{$t['Brand_Description']} Make {$t['Tool_Desc']}</th><td>{$tsid->ip}</td><td>{$tqty->ip}</td>
\t\t\t\t\t\t\t\t<td>
_END;
$any->createList('Tool_Storage');
$sel = new selectlist('Tool_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
echo <<<_END
\t\t\t\t\t\t\t\t</td><th class="v">{$tb['Brand_Description']} Make {$tb['Tool_Desc']}</th><td>{$tbsid->ip}</td><td>
_END;
$any->createList('Tool_Storage');
$sel = new selectlist('ToolBody_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
echo <<<_END
\t\t\t\t\t\t\t\t</td><th class="v" style="width:50px">{$h['Holder_Description']}</th><td>{$hsid->ip}</td><td>
_END;
$any->createList('Tool_Storage');
$sel = new selectlist('Holder_Storage_ID[' . $i . ']', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', 2, null);
echo <<<_END
\t\t\t\t\t\t\t\t</td><td>{$trem->ip}</td></tr>
_END;
$i++;
}
}
$bt = new Form(array('id' => 'save', 'name' => 'save', 'type' => 'button', 'value' => 'Save', 'class' => 'submit'));
echo '<tr><td colspan="4" style="text-align:center;">' . $bt->ip . '</td></tr>';
echo '</tbody></table>';
}
function showToolBodyStockUI()
{
if ($this->toolbodystockid == '') {
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>
\t\t\t\t<p>
\t\t\t <label>New Tool Body Quantity</label>
\t\t\t <input id="qty" name="qty" size="25" class="number"/>
\t\t\t </p>
\t\t\t\t<p>
\t\t\t <label>Price of Each New Tool</label>
\t\t\t <input id="price" name="price" size="25" class="number"/>
\t\t\t </p>
\t\t\t\t<p>
\t\t\t <label>Storage Bin ID</label>
\t\t\t <input id="binid" name="binid" size="25" />
\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_Stock WHERE ToolBody_Stock_ID={$this->toolbodystockid}";
if (!($res = $cxn->query($q))) {
echo "error :", $cxn->error;
} else {
$row = mysqli_fetch_assoc($res);
$any = new Anylist();
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Details</legend>
_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>
\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>
_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>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 <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 <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\t<p>
\t\t\t <label>Storage Bin ID</label>
\t\t\t <input id="binid" name="binid" size="25" value="{$row['Bin_ID']}"/>
\t\t\t </p>
\t\t\t <p>
\t\t\t <label>Current Location</label>
_END;
$any->createList('Tool_Storage');
$sel = new selectlist('Tool_Storage_ID', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', $row['Cur_Location'], null);
echo <<<_END
\t\t\t </p>
\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\t</fieldset>
\t\t\t <p>
\t\t\t <input class="submit" type="submit" value="Save"/>
\t\t\t </p>
_END;
}
}
}
break;
case 'meeting':
//machine list
$meet = new Meeting();
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = 'Meeting_ID';
}
$meet->createMeetingList();
$sel = new selectlist($id, $meet->getMeetingList(), 'Select Meeting to Edit', 'Meeting_ID', 'meetagenda', '', '', '1');
break;
case 'nclogtype':
//machine list
$any = new Anylist();
$any->createList('NC_Type');
$sel = new selectlist('NC_Type_ID', $any->anylist, 'Select NC Type', 'NC_Type_ID', 'NC_Type', '', '', '1');
break;
case 'leave':
//machine list
$l = new Operator();
$l->createLEaveList();
$sel = new selectlist('Leave_ID', $l->getLeaveList(), 'Select Leave to Approve', 'Leave_ID', 'leavedesc', '', '', '1');
break;
case 'qmsactivity':
//machine list
$l = new QMS();
if (isset($_GET['id'])) {
$id = $_GET['id'];
} else {
$id = '';
} else {
$message = $upload->show_errors();
print "{$message}";
}
}
}
} else {
if (isset($_GET['ui'])) {
$nc->showNCUI();
}
if (isset($_GET['newtmrow'])) {
$id = $_GET['id'];
$ope = new Operator();
$ope->createOperatorList();
$any = new Anylist();
$any->createList('Department');
echo '<tr><td>';
$sel = new selectlist("teammember[" . $id . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
echo '</td><td>';
$sel = new selectlist("department[" . $id . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', '', '');
echo '</td><td><input id="work[' . $id . ']" name="work[' . $id . ']" class="required"></td>';
echo '<td><input id="tdate[' . $id . ']" name="tdate[' . $id . ']" class="required"></td><td><input id="memberremarks[' . $id . ']" name="memberremarks[' . $id . ']"></td>';
echo '<input type="hidden" id="tdatedb[' . $id . ']" name="tdatedb[' . $id . ']"></tr>';
}
if (isset($_GET['nclid'])) {
$nc->setValue('nonconformanceid', $_GET['nclid']);
$nc->showNCUI();
}
if (isset($_GET['sgid'])) {
$au = new Approval();
$au->setValue('skillgroup', $_GET['sgid']);
function showNCUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$ncd = $ncddb = $stage = $quantity = $pd = $ef = $ca = $tm = $fd = $tddb = $fddb = $nctypeid = $ncno = $cont = '';
if ($this->nonconformanceid != '') {
$q = "SELECT *,DATE_FORMAT(NC_Date,'%d-%m-%Y') as nd,DATE_FORMAT(Finished_Date,'%d-%m-%Y') as fd FROM NonConformance \n\t\tWHERE NonConformance_ID={$this->nonconformanceid}";
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
$row = mysqli_fetch_assoc($res);
$stage = $row['Stage'];
$quantity = $row['NC_Qty'];
$ncddb = $row['NC_Date'];
$ncd = $row['nd'];
$pd = $row['Problem_Description'];
$ef = $row['Effectiveness'];
$ca = $row['Corr_Action'];
$fd = $row['fd'];
$fddb = $row['Finished_Date'];
$nctypeid = $row['NC_Type_ID'];
$ncno = $row['NC_NO'];
$cont = $row['Containment'];
$corr = $row['Correction'];
$qwhy = "SELECT * FROM NC_Root_Cause WHERE NonConformance_ID={$this->nonconformanceid} ORDER BY NC_Root_Cause_ID ASC";
if (!($resw = $cxn->query($qwhy))) {
exit("error : {$cxn->error}");
}
$i = 0;
while ($r = mysqli_fetch_assoc($resw)) {
$why[$i] = $r['Why'];
$reason[$i] = $r['Reason'];
$ncrcid[$i] = $r['NC_Root_Cause_ID'];
$i++;
}
$qop = "SELECT *,DATE_FORMAT(Target_Date,'%d-%m-%Y') as td FROM NC_Team_Members WHERE NonConformance_ID={$this->nonconformanceid}";
if (!($resqop = $cxn->query($qop))) {
exit("error : {$cxn->error}");
}
$tm = $resqop->num_rows;
}
$anynct = new Anylist();
$anynct->createList('NC_Type');
echo <<<_END
<fieldset><legend>Non Conformance Details</legend>
<p><label>NC Date</label><input id="ncd" name="ncd" class="required" value="{$ncd}"><input type="hidden" id="ncddb" name="ncddb" value="{$ncddb}"></p>
<p><label>NC Number</label><input id="ncnumber" name="ncnumber" class="required" value="{$ncno}"></p>
<p><label>NC Stage</label><input id="stage" name="stage" class="required" value="{$stage}"></p>
<p><label>NC Qty</label><input id="quantity" name="quantity" class="required number" value="{$quantity}"></p>
_END;
$sel = new selectlist('NC_Type_ID', $anynct->anylist, 'Select NC Type', 'NC_Type_ID', 'NC_Type', 'class="required"', $nctypeid, '1');
echo <<<_END
<p><label>Problem Description</label><textarea id="problemdescription" name="problemdescription" class="required" rows="5" cols="40">{$pd}</textarea></p>
<p><label>Containment Action</label><textarea id="containment" name="containment" class="required" rows="5" cols="40">{$cont}</textarea></p>
<p><label>Correction</label><textarea id="correction" name="correction" class="required" rows="5" cols="40">{$corr}</textarea></p>
<p><label>Root Cause Analysis</label><input type="button" id="rcbutton" value="Add Row"></p>
<table id="rootcause" width="100%" class="u"><tr><th align="center">Why</th><th align="center">Reason</th></tr>
_END;
if (isset($why)) {
$i = 0;
$j = count($why);
while ($i < $j) {
echo '<tr><td><input type="hidden" id="ncrcid[' . $i . ']" name="ncrcid[' . $i . ']" value="' . $ncrcid[$i] . '"><textarea rows="3" cols="35" id="why[' . $i . ']" name="why[' . $i . ']" class="required">' . $why[$i] . '</textarea></td>
<td><textarea rows="3" cols="35" id="reason[' . $i . ']" name="reason[' . $i . ']" class="required">' . $reason[$i] . '</textarea></td></tr>';
$i++;
}
} else {
echo <<<_END
<tr><td><textarea id="why[0]" name="why[0]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[0]" rows="3" cols="35" name="reason[0]" class="required"></textarea></td></tr>
<tr><td><textarea id="why[1]" name="why[1]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[1]" rows="3" cols="35" name="reason[1]" class="required"></textarea></td></tr>
<tr><td><textarea id="why[2]" name="why[2]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[2]" rows="3" cols="35" name="reason[2]" class="required"></textarea></td></tr>
_END;
}
echo <<<_END
</table>
<p><label>Corrective Action</label><textarea id="correctiveaction" name="correctiveaction" class="required" rows="5" cols="40">{$ca}</textarea></p>
<p><label>Preventive Action Team Members</label><input type="button" id="addmember" value="Add Team Member"></p>
<table id="tm" width="100%" class="u"><tr><th align="center">Name</th><th align="center">Department</th><th align="center">Work Desc.</th><th align="center">Target Date</th><th align="center">Remarks</th></tr>
_END;
$ope = new Operator();
$ope->createOperatorList();
$any = new Anylist();
$any->createList('Department');
if ($tm > 0) {
$i = 0;
while ($rop = mysqli_fetch_assoc($resqop)) {
echo '<tr><td><input type="hidden" id="nctmid[' . $i . ']" name="nctmid[' . $i . ']" value="' . $rop['NC_Team_Member_ID'] . '">';
$sel = new selectlist("teammember[" . $i . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rop['Team_Member_ID'], '');
echo '</td><td>';
$sel = new selectlist("department[" . $i . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', $rop['Department'], '');
// <input id="department['.$i.']" name="department['.$i.']" class="required" value="'.$rop['Department'].'">
echo '</td><td><input id="work[' . $i . ']" name="work[' . $i . ']" class="required" value="' . $rop['Work'] . '" size="75"></td>';
echo '<td><input id="tdate[' . $i . ']" name="tdate[' . $i . ']" class="required" value="' . $rop['td'] . '"></td><td><input id="memberremarks[' . $i . ']" name="memberremarks[' . $i . ']" value="' . $rop['Remarks'] . '"></td>';
echo '<input type="hidden" id="tdatedb[' . $i . ']" name="tdatedb[' . $i . ']" value="' . $rop['Target_Date'] . '"></tr>';
$i++;
}
} else {
echo '<tr><td>';
$sel = new selectlist("teammember[0]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
echo '</td><td>';
$sel = new selectlist("department[0]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', '', '');
// <input id="department[0]" name="department[0]" class="required">
echo '</td><td><input id="work[0]" name="work[0]" class="required" size="75"></td>';
echo '<td><input id="tdate[0]" name="tdate[0]" class="required"></td><td><input id="memberremarks[0]" name="memberremarks[0]"></td>';
echo '<input type="hidden" id="tdatedb[0]" name="tdatedb[0]"></tr>';
}
echo <<<_END
</table>
<p><label>Effectiveness of CA/PA</label><textarea id="effectiveness" name="effectiveness" class="required" rows="5" cols="40">{$ef}</textarea></p>
_END;
if ($this->nonconformanceid != '') {
echo <<<_END
<p><label>Finish Date</label><input id="fdate" name="fdate" value="{$fd}"><input type="hidden" id="fdatedb" name="fdatedb" value="{$fddb}"></p>
<p><label>Closing Remarks</label><input name="appremarks" size="75" id="appremarks"><input type="button" Value="Approe and Close NC Log" id="abutton"></p>
_END;
self::showLogimages();
}
}
function showRoutecardUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$operator = new Operator();
$operator->createOperatorList();
if ($this->operationid != '' && $this->batchid != '') {
if ($this->operationid == '0') {
$any = new Anylist();
$any->createList('Batch_Commit', 'Batch_ID', $this->batchid);
echo '<table class="tl">
<tr><th>Commitment Date</th><td>';
$sel = new selectlist("Commit_ID", $any->anylist, 'Select Commitment Date', 'Commit_ID', 'Commited_Date', 'class="required"', $this->commitid, '');
echo '</td></tr></table>';
echo '<div id="np"></div>';
$this->displayDispatchRow();
exit;
}
if ($this->operationid == '99999') {
$qd = "SELECT Remarks FROM Routecard WHERE Batch_ID={$this->batchid} AND Operation_ID=99999";
if (!($rd = $cxn->query($qd))) {
exit("error : {$cxn->error}");
}
$n = $rd->num_rows;
if ($n > 0) {
$opn = mysqli_fetch_assoc($rd);
$this->remarks = $opn['Remarks'];
}
echo '<p><label>Batch Notes</label><textarea id="remarks" name="remarks" cols="40" rows="5" class="required">' . $this->remarks . '</textarea></p>';
exit;
}
$this->setOPNotation();
if (in_array($this->opnotation, $this->nonmachining)) {
//
$any = new Anylist();
$any->createList('Batch_Commit', 'Batch_ID', $this->batchid);
echo '<table class="tl">
<tr><th>Commitment Date</th><td>';
$sel = new selectlist("Commit_ID", $any->anylist, 'Select Commitment Date', 'Commit_ID', 'Commited_Date', 'class="required"', $this->commitid, '');
echo '</td></tr></table>';
echo '<div id="np"></div>';
$this->nonProdRow();
} else {
$this->setOperationDetails();
if ($this->batchqty != $this->quantity) {
$c = 'class="r"';
} else {
$c = 'class="g"';
}
echo '<table class="tl">
<tr><th>Machine</th><td>' . $this->machinename;
echo '</td></tr>
<tr><th>Operation Initiated By</th><td>' . $this->operatorname;
echo '</td></tr>
<tr><th>Operation Start Date</th><td>' . $this->startdate . '</td></tr>
<tr><th>Operation End Date</th><td>' . $this->enddate . ' ' . $this->eopratorname . ' : ' . $this->eremarks . '</td></tr>
<tr><th>Quantity Produced</th><td><input id="quantity" name="quantity" value="' . $this->quantity . '" ' . $c . ' ></td></tr>
<tr><th>Accepted Quantity</th><td><input id="acceptedqty" name="acceptedqty" value="' . $this->acceptedqty . '" class="required"></td></tr>
<tr><th>Rejected Quantity</th><td><input id="rejectedqty" name="rejectedqty" value="' . $this->rejectedqty . '">Rejection Remarks<input id="rejrem" name="rejrem" size="50" value="' . $this->rejrem . '"></td></tr>
<tr><th>Non Conforming Quantity</th><td><input id="ncqty" name="ncqty" value="' . $this->ncqty . '">NonConf. Remarks<input id="ncrem" name="ncrem" size="50" value="' . $this->ncrem . '"></td></tr>
<tr><th>Inspected By</th><td>';
echo $this->inspectedbyname ?: 'Not Inspected!!</td></tr>';
if ($this->jobno != '') {
echo ', Job No: ' . $this->jobno;
}
echo '<tr><th>Inspection Date</th><td>';
echo $this->inspdate ?: 'Not Inspected!!</td></tr>';
echo '<tr><th>Re Qualified By</th><td>';
echo $this->approvername ?: 'Not Requalified !!</td></tr>';
echo '<tr><th>Re Qualification Date</th><td>';
echo $this->approvaldate ?: 'Not Inspected !!</td></tr>';
if ($this->appremark != '') {
echo ', Remarks: ' . $this->appremark;
}
if ($this->routecardid != '') {
echo '<tr><td><input type="hidden" name="routecardid" id="routecardid" value="' . $this->routecardid . '"></td></tr>';
}
}
echo '<tr><th>Remarks</th><td><textarea id="remarks" name="remarks" cols="40" rows="5">' . $this->remarks . '</textarea></td></tr>';
if ($this->routecardid != '') {
echo '<tr><td>';
$this->listImages();
echo '</td></tr>';
}
echo '</table>';
} else {
exit("Operation ID or Batch ID Not Set!");
}
}
function showQuestionUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
$any->createList('Training_Catagory');
if ($this->questionid != '') {
$q = "SELECT * FROM Question WHERE Question_ID={$this->questionid}";
if (!($res = $cxn->query($q))) {
exit("error (showQuestionUI): {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->catagoryid = $r['Catagory_ID'];
$this->question = $r['Question'];
}
echo '<fieldset><legend>Question Details</legend>';
if ($this->question != '') {
$sel = new selectlist('ECatagory_ID', $any->anylist, 'Select Catagory', 'Catagory_ID', 'Catagory', 'class="required"', $this->catagoryid, '1');
}
echo '<p><label>Question</label><textarea id="question" name="question" cols="45" rows="5" class="required" maxlength="250">' . $this->question . '</textarea></p>';
if ($this->question != '') {
$this->listQuestionImage();
}
echo '</fieldset>';
}
function showMachineUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$selc = '<option value="1">Yes</option><option value="0">No</option></select>';
if ($this->machineid != '') {
$q = "SELECT *,DATE_FORMAT(Install_Date,'%d-%m-%Y') as id FROM Machine WHERE Machine_ID={$this->machineid}";
if (!($res = $cxn->query($q))) {
exit("error (showMachineUI : {$q}) : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->machinename = $r['Machine_Name'];
$this->machineslno = $r['Machine_SLNO'];
$this->ncserialno = $r['NC_Serial_NO'];
$this->installdatedb = $r['Install_Date'];
$this->installdate = $r['id'];
$this->showinlogentry = $r['Show_In_Logentry'];
$this->supplierid = $r['Supplier_ID'];
$this->machinedesc = $r['Machine_Desc'];
$this->spindletaper = $r['Spindle_Taper'];
$this->atcsize = $r['ATC_Size'];
$this->maxrpm = $r['Max_RPM'];
$this->tablesize = $r['Table_Size'];
$this->stroke = $r['Stroke'];
$this->toolclampingforce = $r['Tool_Clamping_Force'];
$this->torque = $r['Torque'];
$this->typeid = $r['Type_ID'];
if ($this->showinlogentry == 1) {
$selc = '<option value="1" selected >Yes</option><option value="0">No</option></select>';
} else {
$selc = '<option value="1">Yes</option><option value="0" selected>No</option></select>';
}
}
echo '<fieldset><legend>Machine Details</legend>';
$any = new Anylist();
$any->createList('Machine_Type');
$supp = new Supplier();
$supp->createSupplierList();
$sel = new selectlist('Supplier_ID', $supp->getSupplierList(), 'Select Supplier', 'Supplier_ID', 'Supplier_Name', 'class="required"', $this->supplierid, '1');
$sel2 = new selectlist('Type_ID', $any->anylist, 'Select Equipment Type', 'Type_ID', 'Type_Description', 'class="required"', $this->typeid, '1');
echo '<p><label>Machine Name</label><input id="machinename" name="machinename" class="required" value="' . $this->machinename . '"></p>';
echo '<p><label>Machine Description</label><input id="machinedesc" name="machinedesc" class="required" value="' . $this->machinedesc . '"></p>';
echo '<p><label>Machine Serial Number</label><input id="machineslno" name="machineslno" value="' . $this->machineslno . '"></p>';
echo '<p><label>NC Serial Number</label><input id="ncserialno" name="ncserialno" value="' . $this->ncserialno . '"></p>';
echo '<p><label>Spindle Taper</label><input id="spindletaper" name="spindletaper" value="' . $this->spindletaper . '"></p>';
echo '<p><label>ATC Size</label><input id="atcsize" name="atcsize" value="' . $this->atcsize . '"></p>';
echo '<p><label>Maximum RPM</label><input id="maxrpm" name="maxrpm" value="' . $this->maxrpm . '"></p>';
echo '<p><label>Table Size</label><input id="tablesize" name="tablesize" value="' . $this->tablesize . '"></p>';
echo '<p><label>Axis Strokes</label><input id="stroke" name="stroke" value="' . $this->stroke . '"></p>';
echo '<p><label>Tool Clamping force</label><input id="toolclampingforce" name="toolclampingforce" value="' . $this->toolclampingforce . '"></p>';
echo '<p><label>Torque</label><input id="torque" name="torque" value="' . $this->torque . '"></p>';
echo '<p><label>Date OF Installation</label><input id="installdate" name="installdate" value="' . $this->installdate . '"><input id="installdatedb" type="hidden" name="installdatedb" value="' . $this->installdatedb . '"></p>';
echo '<p><label>Show Machine In Log Entry Page?</label><select id="showinlogentry" name="showinlogentry">' . $selc;
echo '</fieldset>';
echo '<input type="submit" class="submit" value="Save Machine Details">';
}
function adminUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
if (isset($_SESSION['operatorid'])) {
$this->operatorid = $_SESSION['operatorid'];
} else {
exit('Not Logged In!!');
}
if (in_array($this->operatorid, $this->admin)) {
self::createOperatorList();
echo '<fieldset><legend>Mark Absent/Leave</legend>';
$sel = new selectlist("Operator_IDab", $this->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '1');
$any = new Anylist();
$any->createList('Att_Status');
$sel = new selectlist('Att_Status_IDab', $any->anylist, 'Select Status', 'Att_Status_ID', 'Status', '', '', '1');
echo '<p><label>Absent/Leave Date</label><input id="absentdate" name="absentdate" class="required" ><input id="absentdatedb" name="absentdatedb" type="hidden"></p>';
echo '<p><label>Remarks</label><input id="remarks" name="remarks"></p>';
echo '<input type="hidden" id="abs" name="abs">';
echo '<p><input type="button" Value="Mark Absent" id="absbutton"></p></fieldset>';
}
}
<?php
require_once 'autoload.php';
$mc = new Machine();
if (isset($_GET['typeid'])) {
$mc->setValue('typeid', $_GET['typeid']);
$mc->showEquipmentList();
}
if (isset($_GET['type'])) {
$any = new Anylist();
$any->createList('Machine_Type');
$sel2 = new selectlist('Type_ID', $any->anylist, 'Select Equipment Type', 'Type_ID', 'Type_Description', 'class="required"', '', '1');
}
?>
function showECNUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$tm = '';
if ($this->ecnid != '') {
$q = "SELECT *,DATE_FORMAT(Request_Date,'%d-%m-%Y') as rdt FROM ECN WHERE ECN_ID={$this->ecnid}";
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
$row = mysqli_fetch_assoc($res);
$this->ecnno = $row['ECN_NO'];
$this->problemdescription = $row['Problem_Description'];
$this->solutionrequirement = $row['Solution_Requirement'];
// $this->requesterid=$row['Requetser_ID'];
$this->requestdate = $row['rdt'];
$this->requestdatedb = $row['Request_Date'];
$this->disposition = $row['Disposition'];
$qop = "SELECT *,DATE_FORMAT(Target_Date,'%d-%m-%Y') as td FROM ECN_Team_Members WHERE ECN_ID={$this->ecnid}";
if (!($resqop = $cxn->query($qop))) {
exit("error : {$cxn->error}");
}
$tm = $resqop->num_rows;
}
$ope = new Operator();
$ope->createOperatorList();
echo '<fieldset><legend>Engineering Change Note Details</legend>';
echo '<p><label>ECN Date</label><input id="ecnd" name="ecnd" class="required" value="' . $this->requestdate . '"><input type="hidden" id="ecnddb" name="ecnddb" value="' . $this->requestdatedb . '"></p>';
echo '<p><label>ECN No</label><input id="ecnno" name="ecnno" class="required" value="' . $this->ecnno . '"></p>';
echo '<p><label>Problem Description/Reason for Change</label><textarea id="problemdescription" name="problemdescription" class="required" rows="5" cols="40">' . $this->problemdescription . '</textarea></p>';
echo '<p><label>Solution Requirement</label><textarea id="solutionrequirement" name="solutionrequirement" class="required" rows="5" cols="40">' . $this->solutionrequirement . '</textarea></p>';
echo '<p><label>Team Members</label><input type="button" id="addmember" value="Add Team Member"></p>';
echo '<table id="tm" width="100%" class="u"><tr><th align="center">Name</th><th align="center">Department</th><th align="center">Work Desc.</th><th align="center">Target Date</th><th align="center">Remarks</th></tr>';
$any = new Anylist();
$any->createList('Department');
if ($tm > 0) {
$i = 0;
while ($rop = mysqli_fetch_assoc($resqop)) {
echo '<tr><td><input type="hidden" id="ecntmid[' . $i . ']" name="ecntmid[' . $i . ']" value="' . $rop['ECN_Team_Member_ID'] . '">';
$sel = new selectlist("teammember[" . $i . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rop['Team_Member_ID'], '');
echo '</td><td>';
$sel = new selectlist("department[" . $i . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', $rop['Department'], '');
// <input id="department['.$i.']" name="department['.$i.']" class="required" value="'.$rop['Department'].'">
echo '</td><td><input id="work[' . $i . ']" name="work[' . $i . ']" class="required" value="' . $rop['Work'] . '" size="75"></td>';
echo '<td><input id="tdate[' . $i . ']" name="tdate[' . $i . ']" class="required" value="' . $rop['td'] . '"></td><td><input id="memberremarks[' . $i . ']" name="memberremarks[' . $i . ']" value="' . $rop['Remarks'] . '"></td>';
echo '<input type="hidden" id="tdatedb[' . $i . ']" name="tdatedb[' . $i . ']" value="' . $rop['Target_Date'] . '"></tr>';
$i++;
}
} else {
echo '<tr><td>';
$sel = new selectlist("teammember[0]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
echo '</td><td>';
$sel = new selectlist("department[0]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', '', '');
echo '</td><td><input id="work[0]" name="work[0]" class="required" size="75"></td>';
echo '<td><input id="tdate[0]" name="tdate[0]" class="required"></td><td><input id="memberremarks[0]" name="memberremarks[0]" size="75"></td>';
echo '<input type="hidden" id="tdatedb[0]" name="tdatedb[0]"></tr>';
}
echo '</table>';
if ($this->ecnid != '') {
echo '<p><label>Closing Remarks</label><input name="appremarks" size="75" id="appremarks"><input type="button" Value="Approve and Close NC Log" id="abutton"></p>';
self::showLogimages();
}
echo '<input class="submit" type="submit" value="Save"/>';
}
function showSPMUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
if ($this->spmid != '') {
$q = "SELECT * FROM Scheduled_PM WHERE SPM_ID={$this->spmid}";
if (!($res = $cxn->query($q))) {
exit("error (showSPMUI) : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->machineid = $r['Machine_ID'];
$this->spmtitle = $r['SPM_Title'];
$this->spmtol = $r['SPM_Tol'];
$this->spminterval = $r['SPM_Interval'];
}
echo '<fieldset><legend>Scheduled Preventive Maintenance Details</legend>';
if ($this->spmid != '') {
$mc = new Machine();
$mc->createMachineList();
$sel = new selectlist('EMachine_ID', $mc->getMachineList(), 'Select Machine', 'Machine_ID', 'mnslno', 'class="required"', $this->machineid, '1');
}
echo '<p><label>Maintenance Title</label><input id="spmtitle" name="spmtitle" class="required" value="' . $this->spmtitle . '"/></p>';
echo '<p><label>Maintenance Interval in Days</label><input id="spminterval" name="spminterval" class="required" value="' . $this->spminterval . '"/></p>';
echo '<p><label>Tolerance in Days</label><input id="spmtol" name="spmtol" class="required" value="' . $this->spmtol . '"/></p>';
echo '<fieldset><legend>Maintanance activites for this Schedule</legend>';
echo '<input type="button" id="addrow" value="Add New Activity"><p/>';
if ($this->spmid != '') {
self::listSPMDesc();
} else {
echo '<table class="pcd" id="spmt">';
echo '<tr><th>Description</th></tr>';
$this->showSPMrow(0);
echo '</table>';
}
echo '</fieldset>';
echo '<fieldset><legend>Geometric Parameters to be Checked</legend>';
echo '<input type="button" id="addgprow" value="Add Selected Parameter to List"><p/>';
$any = new Anylist();
$any->createList('Geometric_Parameter');
$sel = new selectlist('GP_ID', $any->anylist, 'Select Geometric Properties to Check', 'GP_ID', 'Parameter', '', '', '');
echo '<input id="gpidlist" name="gpidlist" type="hidden">';
if ($this->spmid != '') {
$this->listGPIDs();
}
echo '<div id="gplist"></div>';
echo '</fieldset>';
echo '</fieldset>';
echo '<input class="submit" type="submit" value="Save Sechduled Maintenance"/>';
}
function addDimensionRow($data = array())
{
$tf = "0";
$pd1 = "";
$pd0 = "Checked";
$cd1 = "";
$cd0 = "Checked";
$sd1 = '';
$sd0 = 'Checked';
if (isset($data['id'])) {
$i = $data['id'];
} else {
$i = 0;
}
if (isset($data['zone'])) {
$zone = $data['zone'];
} else {
$zone = '';
}
if (isset($data['critical'])) {
$critical = $data['critical'];
} else {
$critical = '';
}
if (isset($data['bno'])) {
$bno = $data['bno'];
} else {
$bno = '';
}
if (isset($data['ddid'])) {
$ddid = $data['ddid'];
} else {
$ddid = '';
}
if (isset($data['instid'])) {
$instid = $data['instid'];
} else {
$instid = '';
}
if (isset($data['bdimn'])) {
$bdimn = $data['bdimn'];
} else {
$bdimn = '';
}
if (isset($data['tl'])) {
$tl = $data['tl'];
} else {
$tl = '';
}
if (isset($data['tu'])) {
$tu = $data['tu'];
} else {
$tu = '';
}
if (isset($data['stgdimn'])) {
if ($data['stgdimn'] == 1) {
$sd1 = "Checked";
$sd0 = '';
}
}
if (isset($data['cdimn'])) {
if ($data['cdimn'] == 1) {
$cd1 = "Checked";
$cd0 = '';
}
}
if (isset($data['prod'])) {
if ($data['prod'] == 1) {
$pd1 = "Checked";
$pd0 = '';
}
}
if (isset($data['did'])) {
$did = '<input type="hidden" id="dimensionid[' . $i . ']" name="dimensionid[' . $i . ']" value="' . $data['did'] . '">';
$del = '<input type="checkbox" name="deldimn[' . $i . ']" id="deldimn[' . $i . ']" value="1" />';
} else {
$did = '';
$del = '';
}
$a = new Anylist();
$a->createList('Dimn_Criticality');
if ($i == null) {
$i = 0;
}
$dd = new DimnDescription();
$dd->createDimnDescList();
$in = new InstrumentType();
$in->createInstrumentTypeList();
echo <<<_END
\t\t<tr><td><input name="baloonno[{$i}]" id="baloonno[{$i}]" class="required" unique="baloonno" size="5" value="{$bno}">{$did}</td>
\t\t<td><input id="zone[{$i}]" name="zone[{$i}]" value="{$zone}"></td><td>
_END;
$sel = new selectlist('dimndesc[' . $i . ']', $dd->getDimnDescList(), 'Select Dimension Comment', 'Desc_ID', 'Dimn_Desc', 'class="required"', $ddid, '');
echo <<<_END
\t\t</td><td><input name="basicdimn[{$i}]" id="basicdimn[{$i}]" class="required" size="7" value="{$bdimn}"></td>
\t\t<td><input name="tollower[{$i}]" id="tollower[{$i}]" size="5" class="number" value="{$tl}"/></td>
\t\t<td><input name="tolupper[{$i}]" id="tolupper[{$i}]" size="5" class="number greaterThan" data-min="tollower\\[{$i}\\]" value="{$tu}"/></td><td>
_END;
$sel = new selectlist('instrumenttypeid[' . $i . ']', $in->getInstrumentTypeList(), 'Select Instrument Type', 'Instrument_Type_ID', 'Instrument', 'class="required"', $instid, '');
echo '</td><td>';
$sel = new selectlist('critical[' . $i . ']', $a->anylist, 'Select Characteristic', 'Criticality_ID', 'Criticality', '', $critical, '');
echo <<<_END
\t\t</td><td><input type="radio" name="stagedimn[{$i}]" value="1" {$sd1}/>Y
\t\t<input type="radio" name="stagedimn[{$i}]" value="0" {$sd0}/>N</td>
\t\t<td><input type="radio" name="proddimn[{$i}]" id="proddimn[{$i}]" value="1" {$pd1}/>Y
\t\t<input type="radio" name="proddimn[{$i}]" id="proddimn[{$i}]" value="0" {$pd0}/>N</td>
\t\t<td><input type="radio" name="compulsary[{$i}]" id="compulsary[{$i}]" value="1" {$cd1} />Y
\t\t<input type="radio" name="compulsary[{$i}]" id="compulsary[{$i}]" value="0" {$cd0}/>N</td><td>{$del}</td></tr>
_END;
}
function showHolderStockUI()
{
if ($this->holderstockid == '') {
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Tool Holder Details</legend>
\t\t\t\t<p>
\t\t\t <label>New Tool Holder Quantity</label>
\t\t\t <input id="qty" name="qty" size="25" class="number"/>
\t\t\t </p>
\t\t\t\t<p>
\t\t\t <label>Price of Each New Holder</label>
\t\t\t <input id="price" name="price" 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 Holder_Stock WHERE Holder_Stock_ID={$this->holderstockid}";
if (!($res = $cxn->query($q))) {
echo "error :", $cxn->error;
} else {
$row = mysqli_fetch_assoc($res);
$any = new Anylist();
echo <<<_END
\t\t\t<fieldset>
\t\t\t\t<legend>Holder Location Details</legend>
\t\t\t <p>
\t\t\t <label>Current Location</label>
_END;
$any->createList('Tool_Storage');
$sel = new selectlist('Tool_Storage_ID', $any->getValue('anylist'), 'Storage Location', 'Tool_Storage_ID', 'Cur_Location', 'class="required"', $row['Cur_Location'], null);
echo <<<_END
\t\t\t </p>
\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\t</fieldset>
\t\t\t <p>
\t\t\t <input class="submit" type="submit" value="Save"/>
\t\t\t </p>
_END;
}
}
}
