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; } } }