function showUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
$any->createlist('Information_Catagory');
if ($this->infoid != '') {
$q = "SELECT * FROM Gen_Info WHERE Info_ID={$this->infoid}";
if (!($res = $cxn->query($q))) {
exit("error (saveGenInfo): {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->infodesc = $r['Info_Description'];
$this->catagoryid = $r['Catagory_ID'];
}
echo '<fieldset><legend>General Information File Details</legend>';
if ($this->infoid != '') {
$sel = new selectlist('Catagory_ID', $any->anylist, 'Select Information Type', 'Catagory_ID', 'Catagory', 'class="required"', $this->catagoryid, '1');
}
echo '<p><label>Information Description</label><input id="infodesc" name="infodesc" class="required" size="50" value="' . $this->infodesc . '"></p>';
if ($this->infoid != '') {
$this->listGenInfoFiles();
}
echo '</fieldset>';
}
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();
}
}
print "{$message}";
} 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();
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 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 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;
}
//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 = '';
}
$l->createQMSTitleList();
$sel = new selectlist('QMS_Sch_ID', $l->getQMSTitleList(), 'Select QMS Activity', 'QMS_Sch_ID', 'QMS_Title', 'class="required"', $id, '1');
break;
case 'qmsdesc':
//machine list
$any = new Anylist();
if (isset($_GET['qmsdescid'])) {
$qmsdescid = $_GET['qmsdescid'];
} else {
$qmsdescid = '';
}
$any->createAnyGrid('QMS_Desc', 'QMS_Desc', 'QMS_Desc_ID', $qmsdescid, 'QMS_Sch_ID', $_GET['qmsschid']);
break;
default:
# code...
break;
}
}
if (isset($_GET['ui'])) {
if (isset($_GET['poid'])) {
$po->setValue('poid', $_GET['poid']);
}
$po->setValue('supplierid', $_GET['sid']);
$po->showPurchaseOrderUI();
}
if (isset($_GET['newtmrow'])) {
$po->addItemRow($_GET['id']);
}
if (isset($_GET['getlist'])) {
$po->setValue('supplierid', $_GET['sid']);
$po->getSuppliedItemList();
}
if (isset($_GET['scope'])) {
$any = new Anylist();
$any->createlist('Supplier_Scope');
$sel = new selectlist("Scope_ID", $any->anylist, 'Select Supply Scope', 'Scope_ID', 'Scope', '', '', '1');
}
if (isset($_GET['pregister'])) {
if (isset($_GET['sid'])) {
$po->setValue('supplierid', $_GET['sid']);
}
if (isset($_GET['scopeid'])) {
$po->setValue('scopeid', $_GET['scopeid']);
}
$po->listPurchases();
}
if (isset($_GET['mlist'])) {
if (isset($_GET['poid'])) {
$po->setValue('poid', $_GET['poid']);
function showSpareUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
if ($this->spareid != '') {
$q = "SELECT * FROM Spare WHERE Spare_ID={$this->spareid}";
if (!($res = $cxn->query($q))) {
exit("error (showSpareUI) : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->description = $r['Description'];
$this->supppartno = $r['Supplier_Part_NO'];
$this->mfgpartno = $r['Mfg_Part_NO'];
$this->machineid = $r['Machine_ID'];
}
echo '<fieldset><legend>Enter Spare Details</legend>';
echo '<p><label>Description</label><input id="description" name="description" class="required" value="' . $this->description . '">';
echo '<p><label>Supplier Part No</label><input id="supppartno" name="supppartno" class="required" value="' . $this->supppartno . '">';
echo '<p><label>Manufacturres\'s Part No</label><input id="mfgpartno" name="mfgpartno" value="' . $this->mfgpartno . '">';
echo '<fieldset><legend>Select Machines This Spare is Used For</legend>';
$any->createAnyGrid('Machine', 'Machine_Name', 'Machine_ID', $this->machineid);
echo '</fieldset>';
}
function showInstrumentUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$ity = new InstrumentType();
$ity->createInstrumentTypeList();
$islno = $idesc = $caldate = $calfreq = $make = $range = $error = $lc = $rem = $ityid = $caldatedb = $cloc = '';
if ($this->instrumentid != '') {
$q = "SELECT * FROM Instrument WHERE Instrument_ID={$this->instrumentid}";
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
$row = mysqli_fetch_assoc($res);
$islno = $row['Instrument_SLNO'];
$idesc = $row['Instrument_Description'];
$calfreq = $row['Calibration_Frequency'];
$make = $row['Make'];
$range = $row['Instrument_Range'];
$error = $row['Acceptable_Error'];
$lc = $row['Least_Count'];
$rem = $row['Remarks'];
$ityid = $row['Instrument_Type_ID'];
$cloc = $row['Current_Location'];
$qc = "SELECT *,DATE_FORMAT(Calibration_Date,'%d-%m-%Y') as cd FROM Calibration_History WHERE Instrument_ID={$this->instrumentid}";
if (!($rcd = $cxn->query($qc))) {
exit("error : {$cxn->error}");
}
$n = $rcd->num_rows;
}
$any = new Anylist();
$any->Createlist('Instrument_Location');
echo <<<_END
\t\t\t<label>Instrument Type</label>
_END;
$sel = new selectlist('Instrument_Type_ID', $ity->getInstrumentTypeList(), 'Select Instrument Type', 'Instrument_Type_ID', 'Instrument', 'class="required"', $ityid, '');
echo <<<_END
\t\t\t<p>
\t\t\t<label>Instrument Serial NO</label>
\t\t\t<input id="slno" name="slno" value="{$islno}">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Instrument Description</label>
\t\t\t<input id="instrumentdesc" name="instrumentdesc" value="{$idesc}" class="required">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Calibration Frequency</label>
\t\t\t<input id="frequency" name="frequency" value="{$calfreq}">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Instrument Make</label>
\t\t\t<input id="make" name="make" value="{$make}" class="required">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Instrument Range</label>
\t\t\t<input id="range" name="range" value="{$range}" >
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Acceptable Error</label>
\t\t\t<input id="acceptableerror" name="acceptableerror" value="{$error}" >
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Instrument Least Count</label>
\t\t\t<input id="leastcount" name="leastcount" value="{$lc}">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Remarks</label>
\t\t\t<input id="remarks" name="remarks" value="{$rem}">
\t\t\t</p>
\t\t\t<p>
\t\t\t<label>Current Location</label>
_END;
$sel = new selectlist('Location_ID', $any->anylist, 'Select Instrument Location', 'Location_ID', 'Location', 'class="required"', $cloc, '');
echo '<p><label>Calibration Date</label><input id="calibrationdate" name="calibrationdate" ><input type="hidden" id="caldatedb" name="caldatedb"></p>';
echo '<p><label>Calibration Certificate No</label><input id="certno" name="certno"></p>';
echo '<p><label>Calibration Remarks</label><input id="calremarks" name="calremarks"></p>';
if (isset($n)) {
echo '<p><label>Calibration History</label>';
echo '<table class="tl"><tr><th>Calibration Date</th><th>Certificate No.</th><th>Remarks</th></tr>';
while ($rc = mysqli_fetch_assoc($rcd)) {
echo '<tr><td>' . $rc['cd'] . '</td><td>' . $rc['Certificate_NO'] . '</td><td>' . $rc['Remarks'] . '</td></tr>';
}
echo '</table>';
}
echo '</p>';
}
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"/>';
}
$supplier->setValue('supratingid', $_POST['supratingid']);
}
$supplier->saveRating();
} else {
if (isset($_GET['ui'])) {
if (isset($_GET['cid'])) {
$cid = $_GET['cid'];
$supplier->setSID($cid);
}
$supplier->showSupplierUI();
}
if (isset($_GET['newscrow'])) {
$id = $_GET['id'];
$any = new Anylist();
$any->createlist('Supplier_Scope');
$anys = new Anylist();
$anys->createlist('Supplier_Status');
echo '<tr><td>';
$sel = new selectlist("Scope_ID[" . $id . "]", $any->anylist, 'Select Supply Scope', 'Scope_ID', 'Scope', 'class="required"', '', '');
echo '</td><td><input id="appdate[' . $id . ']" name="appdate[' . $id . ']" class="required" >';
echo '<input type="hidden" id="appdatedb[' . $id . ']" name="appdatedb[' . $id . ']" ></td><td>';
$sel = new selectlist("Status_ID[" . $id . "]", $anys->anylist, 'Select Status', 'Status_ID', 'Status', 'class="required"', '', '');
echo '</td><td><input id="sremarks[' . $id . ']" name="sremarks[' . $id . ']"></td></tr>';
}
if (isset($_GET['rating'])) {
$supplier->setSID($_GET['cid']);
$supplier->listSupplierRating();
}
if (isset($_GET['sid'])) {
$supplier->setValue('id', $_GET['sid']);
$supplier->showScopeList();
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 showPurchaseOrderUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$any = new Anylist();
if ($this->poid != '') {
$q = "SELECT *,DATE_FORMAT(PO_Date,'%d-%m-%Y') as pod,DATE_FORMAT(Supp_Ref_Date,'%d-%m-%Y') as srd,DATE_FORMAT(Required_Date,'%d-%m-%Y') as rdate,DATE_FORMAT(Not_Later_Date,'%d-%m-%Y') as nldate FROM Purchase_Order WHERE PO_ID={$this->poid}";
if (!($res = $cxn->query($q))) {
exit("error (showPurchaseOrderUI) {$q} : {$cxn->error}");
}
$r = mysqli_fetch_assoc($res);
$this->pono = $r['PO_NO'];
$this->supplierid = $r['Supplier_ID'];
$this->podatedb = $r['PO_Date'];
$this->podate = $r['pod'];
$this->suppref = $r['Supp_Ref'];
$this->supprefdatedb = $r['Supp_Ref_Date'];
$this->supprefdate = $r['srd'];
$this->potermid = $r['Terms_ID'];
$this->currency = $r['Currency'];
$this->notes = $r['Notes'];
$this->requireddatedb = $r['Required_Date'];
$this->requireddate = $r['rdate'];
$this->notlaterdatedb = $r['Not_Later_Date'];
$this->notlaterdate = $r['nldate'];
$qi = "SELECT * FROM PO_Item WHERE PO_ID={$this->poid}";
if (!($res2 = $cxn->query($qi))) {
exit("error (showPurchaseOrderUI2) {$qi} : {$cxn->error}");
}
$desc = array();
$i = 0;
while ($ri = mysqli_fetch_assoc($res2)) {
$desc[$i] = ['poitemid' => $ri['PO_Item_ID'], 'desc' => $ri['Description'], 'qty' => $ri['Item_Qty'], 'price' => $ri['Unit_Price'], 'discount' => $ri['Discount']];
$i++;
}
}
echo '<fieldset><legend>Enter Purchase Order Details</legend>';
echo '<p><label>Purchase Order No</label><input id="pono" name="pono" class="required" value="' . $this->pono . '">';
echo '<p><label>Purchase Order Date</label><input id="podate" name="podate" class="required" value="' . $this->podate . '"><input id="podatedb" name="podatedb" type="hidden" value="' . $this->podatedb . '">';
echo '<p><label>Supplier Ref No</label><input id="suppref" name="suppref" value="' . $this->suppref . '">';
echo '<p><label>Supplier Ref Date</label><input id="supprefdate" name="supprefdate" class="required" value="' . $this->supprefdate . '"><input id="supprefdatedb" name="supprefdatedb" type="hidden" value="' . $this->supprefdatedb . '">';
echo '<p><label>Currency</label><input id="currency" name="currency" value="' . $this->currency . '">';
echo '<p><label>Notes</label><input id="notes" name="notes" value="' . $this->notes . '" size="100">';
echo '<p><label>Required Date</label><input id="requireddate" name="requireddate" class="required" value="' . $this->requireddate . '"><input id="requireddatedb" name="requireddatedb" type="hidden" value="' . $this->requireddatedb . '">';
echo '<p><label>Not Later Then Date</label><input id="notlaterdate" name="notlaterdate" class="required" value="' . $this->notlaterdate . '"><input id="notlaterdatedb" name="notlaterdatedb" type="hidden" value="' . $this->notlaterdatedb . '">';
echo '<p><label>Purchase Order Item Details</label><input type="button" id="additem" value="Add One More Item">';
echo '<table class="pcd" id="item"><tr><th>Sl No</th><th>Description</th><th>Quantity</th><th>Unit Price</th><th>Discount</th></tr>';
if ($this->poid != '') {
if (isset($desc[0]['poitemid'])) {
$i = 0;
$j = count($desc);
while ($i < $j) {
$slno = $i + 1;
echo '<tr><td><input id="poitemid[' . $i . ']" name="poitemid[' . $i . ']" value="' . $desc[$i]['poitemid'] . '" type="hidden">' . $slno . '</td><td><input id="description[' . $i . ']" name="description[' . $i . ']" class="required" value="' . $desc[$i]['desc'] . '"></td>';
echo '<td><input i="itemqty[' . $i . ']" name="itemqty[' . $i . ']" class="required" value="' . $desc[$i]['qty'] . '"></td>';
echo '<td><input i="price[' . $i . ']" name="price[' . $i . ']" class="required" value="' . $desc[$i]['price'] . '"></td>';
echo '<td><input i="discount[' . $i . ']" name="discount[' . $i . ']" value="' . $desc[$i]['discount'] . '"></td></tr>';
$i++;
}
} else {
$this->addItemRow('0');
}
} else {
$this->addItemRow('0');
}
echo '</table>';
echo '<fieldset><legend>Select Terms and Condition</legend>';
$any->createAnyGrid('PO_Terms', 'Term', 'PO_Term_ID', $this->potermid);
echo '<input type="button" id="preview" value="Preview PO">';
echo '<input type="checkbox" id="previewok" name="previewok" value="1">PreView Checked OK';
echo '</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 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;
}
}
}
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 listSupplierScope()
{
$any = new Anylist();
$any->createlist('Supplier_Scope');
$anys = new Anylist();
$anys->createlist('Supplier_Status');
echo '<p><label>Supplier Scope</label><table class="tt" id="tscope"><tr><td><input type="button" id="addscoperow" value="Add One More Row"></td></tr>';
echo '<tr><th>Scope</th><th>Date of Approval</th><th>Approval Status</th><th>Remarks</th></tr>';
if (isset($this->scopeid[0])) {
$i = 0;
$j = count($this->scopeid);
while ($i < $j) {
echo '<tr><td><input type="hidden" id="supscopeid[' . $i . ']" name="supscopeid[' . $i . ']" value="' . $this->supscopeid[$i] . '">';
$sel = new selectlist("Scope_ID[{$i}]", $any->anylist, 'Select Supply Scope', 'Scope_ID', 'Scope', 'class="required"', $this->scopeid[$i], '');
echo '</td><td><input id="appdate[' . $i . ']" name="appdate[' . $i . ']" class="required" value="' . $this->appdate[$i] . '">';
echo '<input type="hidden" id="appdatedb[' . $i . ']" name="appdatedb[' . $i . ']" value="' . $this->appdatedb[$i] . '"></td><td>';
$sel = new selectlist("Status_ID[{$i}]", $anys->anylist, 'Select Status', 'Status_ID', 'Status', 'class="required"', $this->appstatus[$i], '');
echo '</td><td><input id="sremarks[' . $i . ']" name="sremarks[' . $i . ']" value="' . $this->sremarks[$i] . '"></td></tr>';
$i++;
}
} else {
echo '<tr><td>';
$sel = new selectlist("Scope_ID[0]", $any->anylist, 'Select Supply Scope', 'Scope_ID', 'Scope', 'class="required"', '', '');
echo '</td><td><input id="appdate[0]" name="appdate[0]" class="required" >';
echo '<input type="hidden" id="appdatedb[0]" name="appdatedb[0]" ></td><td>';
$sel = new selectlist("Status_ID[0]", $anys->anylist, 'Select Status', 'Status_ID', 'Status', 'class="required"', '', '');
echo '</td><td><input id="sremarks[0]" name="sremarks[0]"></td></tr>';
}
echo '</table>';
}
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>';
}
}
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 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;
}
}
}
