function showMeetingUI() { $db = Database::getInstance(); $cxn = $db->getConnection(); $operator = new Operator(); $operator->createOperatorList(); if ($this->meetingid != '') { $q = "SELECT *,DATE_FORMAT(Meeting_Date,'%d-%m-%Y') as mdt,Participants FROM Meeting\n\tWHERE Meeting_ID={$this->meetingid}"; if (!($res = $cxn->query($q))) { exit("error (showMeetingUI): {$cxn->error}"); } $n = $res->num_rows; if ($n > 0) { $r = mysqli_fetch_assoc($res); $this->conductedby = $r['Conductedby']; $this->meetingdatedb = $r['Meeting_Date']; $this->participants = $r['Participants']; $this->meetingdatedb = $r['Meeting_Date']; $this->meetingdate = $r['mdt']; $this->agenda = $r['Agenda']; $this->participants = $r['Participants']; $qp = "SELECT * FROM Meeting_Points WHERE Meeting_ID={$this->meetingid}"; if (!($resp = $cxn->query($qp))) { exit("error (showMeetingUI2) {$qp}: {$cxn->error}"); } $i = 0; while ($rr = mysqli_fetch_assoc($resp)) { $this->pointsdiscussed[$i] = $rr['Point_Discussed']; $this->meetingpointid[$i] = $rr['Meeting_Point_ID']; $i++; } } } echo '<fieldset><legend>Meeting Details</legend>'; $sel = new selectlist("Conductedby", $operator->getOperatorList(), 'Meeting Conducted By', 'Operator_ID', 'Operator_Name', 'class="required"', $this->conductedby, '1'); echo '<p><label>Meeting Date</label><input id="meetingdate" name="meetingdate" class="required" value="' . $this->meetingdate . '"><input id="meetingdatedb" name="meetingdatedb" type="hidden" value="' . $this->meetingdatedb . '"></p>'; echo '<p><label>Meeting Agenda</label><textarea id="agenda" name="agenda" cols="45" rows="5" class="required">' . $this->agenda . '</textarea></p>'; echo '<p><label>Meeting Participants</label></p>'; $operator->createOperatorGrid($this->participants); echo '</fieldset>'; echo '<table id="points" width="100%" class="u"><tr><th align="center">Points Discussed</th><th>'; echo '<th><input type="button" id="addpoint" value="Add Row"></th></tr>'; if (isset($this->meetingpointid)) { $i = 0; $j = count($this->pointsdiscussed); while ($i < $j) { echo '<tr><td colspan="2"><textarea id="pointsdiscussed[' . $i . ']" name="pointsdiscussed[' . $i . ']" rows="3" cols="40" class="required">' . $this->pointsdiscussed[$i] . '</textarea></td> <input type="hidden" id="meetingpointid[' . $i . ']" name="meetingpointid[' . $i . ']" value="' . $this->meetingpointid[$i] . '"></tr>'; $i++; } } else { echo '<tr><td colspan="2"><textarea id="pointsdiscussed[0]" name="pointsdiscussed[0]" rows="3" cols="40" class="required"></textarea></td></tr>'; } echo '</table>'; }
$id = 'Drawing_ID'; } $sel = new selectlist($id, $part->getPartList(), 'Select Part No', 'Drawing_ID', 'name', $req, ''); break; case 'operator': $operator = new Operator(); if (isset($_GET['insp'])) { $operator->setInsp(); } if (isset($_GET['class'])) { $class = "class=required"; } else { $class = ''; } if (isset($_GET['method'])) { $operator->createOperatorList(); if ($_GET['method'] == 'grid') { $operator->createOperatorGrid(); } } else { $operator->createOperatorList(); $sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', $class, '', '1'); } break; case 'operation': $ope = new Operation(); if (isset($_GET['req'])) { $req = 'class=required'; } else { $req = ''; }
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(); } }
$message = '<p>' . $upload->upload_success() . '</p>'; 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'])) {
function showTrainingPlanUI() { $db = Database::getInstance(); $cxn = $db->getConnection(); $operator = new Operator(); $operator->createOperatorList(); $qu = new Question(); if ($this->planid != '') { $q = "SELECT *,DATE_FORMAT(Training_Start_Date,'%d-%m-%Y') as sdt,DATE_FORMAT(Training_End_Date,'%d-%m-%Y') as edt,\n\t(SELECT GROUP_CONCAT(Trainee_ID) FROM Plan_Trainee as pt WHERE pt.Training_Plan_ID={$this->planid}) as trainees FROM Training_Plan as tp \n\tWHERE Training_Plan_ID={$this->planid}"; if (!($res = $cxn->query($q))) { exit("error (showTrainingPlanUI): {$cxn->error}"); } $n = $res->num_rows; if ($n > 0) { $r = mysqli_fetch_assoc($res); $this->trainer = $r['Trainer_Name']; $this->startdatedb = $r['Training_Start_Date']; $this->startdate = $r['sdt']; $this->enddatedb = $r['Training_End_Date']; $this->enddate = $r['edt']; $this->trainees = $r['trainees']; $this->plandesc = $r['Training_Desc']; $this->questionid = $r['Question_ID']; $this->evaluaterid = $r['Evaluater_ID']; } } echo '<fieldset><legend>Training Details</legend>'; echo '<p><label>Trainer Name</label><input id="trainer" name="trainer" class="required" value="' . $this->trainer . '"></p>'; $sel = new selectlist("Evaluater_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->evaluaterid, '1'); echo '<p><label>Training Start Date</label><input id="startdate" name="startdate" class="required" value="' . $this->startdate . '"><input id="startdatedb" name="startdatedb" type="hidden" value="' . $this->startdatedb . '"></p>'; echo '<p><label>Training End Date</label><input id="enddate" name="enddate" class="required" value="' . $this->enddate . '"><input id="enddatedb" name="enddatedb" type="hidden" value="' . $this->enddatedb . '"></p>'; echo '<p><label>Training Description</label><textarea id="plandesc" name="plandesc" cols="45" rows="5" class="required">' . $this->plandesc . '</textarea></p>'; echo '</fieldset>'; echo '<fieldset><legend>Select Trainees</legend>'; $operator->createOperatorGrid($this->trainees); echo '</fieldset>'; }
function showActivityUI() { $db = Database::getInstance(); $cxn = $db->getConnection(); if ($this->activitylogid == '') { $qm = "SELECT DATE_FORMAT(End_Date_Time,'%d-%m-%Y %h:%i%p') as edtt,End_Date_Time FROM ActivityLog WHERE Machine_ID={$this->machineid} AND Activity_ID NOT IN(10,15) ORDER By End_Date_Time DESC LIMIT 1"; if (!($resm = $cxn->query($qm))) { exit("error (showActivityUI) {$qm} : {$cxn->error}"); } $rowm = mysqli_fetch_assoc($resm); if ($this->activityid == 8) { echo <<<_END \t \t\t\t\t<p> \t \t\t\t\t<label>Start Date and Time</label> \t \t\t\t\t<input id="sdt" name="sdt" class="required" value="{$rowm['edtt']}"/> \t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowm['End_Date_Time']}"> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>End Date and Time</label> \t \t\t\t\t<input id="edt" name="edt" class="required"/> \t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden"> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Remarks</label> \t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300"> </textarea> \t \t\t\t\t</p> \t \t\t\t\t</fieldset> \t\t\t\t <input class="submit" type="submit" value="Save"/> _END; exit; } $q = "SELECT Batch_Remarks FROM Batch_NO as bn \n\t\t\t\tINNER JOIN BNo_MI_Challans as bmc ON bmc.Batch_ID=bn.Batch_ID\n\t\t\t\tINNER JOIN MI_Drg_Qty as midq ON midq.Mi_Drg_Qty_ID=bmc.Mi_Drg_Qty_ID\n\t\t\t\tWHERE bn.Batch_ID={$this->batchid}"; if (!($res = $cxn->query($q))) { echo "error (showActivityUI2) {$q} :", $cxn->error; exit; } $row = mysqli_fetch_assoc($res); if (in_array($this->activityid, $this->production)) { echo <<<_END \t\t\t\t\t<p>Batch Remarks {$row['Batch_Remarks']}</p> \t\t\t\t\t<fieldset> \t\t\t\t\t\t<legend>Activity Details</legend> \t \t\t\t\t<p> \t \t\t\t\t<label>Start Date and Time</label> \t \t\t\t\t<input id="sdt" name="sdt" class="required" value="{$rowm['edtt']}"/> \t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowm['End_Date_Time']}"> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>End Date and Time</label> \t \t\t\t\t<input id="edt" name="edt" class="required"/> \t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden"> \t \t\t\t\t</p> _END; if ($this->operationid != '') { $qo = "SELECT Program_NO FROM Operation WHERE Operation_ID={$this->operationid}"; if (!($reso = $cxn->query($qo))) { echo "error (showActivityUI3) {$qo} :", $cxn->error; exit; } $rowo = mysqli_fetch_assoc($reso); $this->programno = $rowo['Program_NO']; } echo <<<_END \t \t\t\t\t<p> \t \t\t\t\t<label>Program No</label> \t \t\t\t\t<input id="programno" name="programno" class="required" value="{$this->programno}"/> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Quantity</label> \t \t\t\t\t<input id="quantity" name="quantity" class="required number"/> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Remarks</label> \t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300"> </textarea> \t \t\t\t\t</p> \t \t\t\t\t</fieldset> _END; } if (in_array($this->activityid, $this->nonproduction)) { echo <<<_END \t\t\t\t\t<p>Batch Remarks {$row['Batch_Remarks']}</p> \t\t\t\t\t<fieldset> \t\t\t\t\t<legend>Activity Details</legend> \t \t\t\t\t<p> \t \t\t\t\t<label>Operation Details</label> \t \t\t\t\t<input id="operationdesc" name="operationdesc" class="required"/> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Start Date and Time</label> \t \t\t\t\t<input id="sdt" name="sdt" class="required" value="{$rowm['edtt']}"/> \t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowm['End_Date_Time']}"> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>End Date and Time</label> \t \t\t\t\t<input id="edt" name="edt" class="required"/> \t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden"> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Program No</label> \t \t\t\t\t<input id="programno" name="programno" class="required"/> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Quantity</label> \t \t\t\t\t<input id="quantity" name="quantity" class="required number"/> \t \t\t\t\t</p> \t \t\t\t\t<p> \t \t\t\t\t<label>Remarks</label> \t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300"> </textarea> \t \t\t\t\t</p> \t \t\t\t\t</fieldset> _END; } } else { $q = "SELECT Activity_ID,Operator_ID FROM ActivityLog WHERE Activity_Log_ID={$this->activitylogid}"; if (!($res = $cxn->query($q))) { echo "error :", $cxn->error; exit; } $row = mysqli_fetch_assoc($res); $this->activityid = $row['Activity_ID']; if ($_SESSION['operatorid'] != $row['Operator_ID'] && !in_array($_SESSION['operatorid'], $this->editauth)) { print "Error You Can Edit only Your Log!!"; exit; } if (in_array($this->activityid, $this->production)) { $qe = "SELECT cust.Customer_ID,Machine_ID,comp.Drawing_ID,ope.Operation_ID,Batch_ID,Operator_ID,prod.Program_NO,Quantity,Remarks,actl.Activity_ID,\n\t\t\t\t\t\tDATE_FORMAT(Start_Date_Time,'%d-%m-%Y %h:%i%p') as sdte,Start_Date_Time,DATE_FORMAT(End_Date_Time,'%d-%m-%Y %h:%i%p') as edte,End_Date_Time FROM ActivityLog as actl \n\t\t\t\t\t\tINNER JOIN Production AS prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\n\t\t\t\t\t\tINNER JOIN Operation as ope ON ope.Operation_ID=prod.Operation_ID\n\t\t\t\t\t\tINNER JOIN Component as comp ON comp.Drawing_ID=ope.Drawing_ID\n\t\t\t\t\t\tINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID WHERE actl.Activity_Log_ID={$this->activitylogid}"; //print("<br>$qe"); if (!($rese = $cxn->query($qe))) { echo "error :", $cxn->error; exit; } $rowe = mysqli_fetch_assoc($rese); $ac = new Activity(); $ac->setActivityID($rowe['Activity_ID']); $ac->createActivityList(); $sel = new selectlist('Activity_ID', $ac->getActivityList(), 'Select Activity', 'Activity_ID', 'Activity_Name', 'class="required"', $rowe['Activity_ID'], '1'); $mc = new Machine(); $mc->createMachineList(); $sel = new selectlist('Machine_ID', $mc->getMachineList(), 'Select Machine', 'Machine_ID', 'mnslno', 'class="required"', $rowe['Machine_ID'], '1'); $cust = new Customer(); $cust->createCustomerList(); $sel = new selectlist('Customer_ID', $cust->getCustomerList(), 'Select Customer', 'Customer_ID', 'Customer_Name_Short', 'class="required"', $rowe['Customer_ID'], '1'); $part = new Part(); $part->createPartList($rowe['Customer_ID']); $req = 'class=required'; echo '<div id="drawe">'; $selc = new selectlist('Drawing_ID', $part->getPartList(), 'Select Drawing', 'Drawing_ID', 'name', 'class="required"', $rowe['Drawing_ID'], '1'); echo '</div>'; $ope = new Operation(); $ope->createOperationList($rowe['Drawing_ID']); echo '<div id="operatione">'; $sel = new selectlist('Operation_ID', $ope->getOperationList(), 'Select Operation', 'Operation_ID', 'Operation_Desc', 'class="required"', $rowe['Operation_ID'], '1'); echo '</div>'; $operator = new Operator(); $operator->createOperatorList(); $sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rowe['Operator_ID'], '1'); $bn = new Batch(); $bn->setPartID($rowe['Drawing_ID']); $bn->createBatchList(); echo '<div id="batche">'; $sel = new selectlist('Batch_ID', $bn->getBatchList(), 'Select Batch', 'Batch_ID', 'Mfg_Batch_NO', 'class="required"', $rowe['Batch_ID'], '1'); echo '</div>'; echo <<<_END \t\t\t\t\t\t<fieldset> \t\t\t\t\t\t<legend>Activity Details</legend> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Start Date and Time</label> \t\t \t\t\t\t<input id="sdt" name="sdt" rclass="equired" value="{$rowe['sdte']}"/> \t\t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowe['Start_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>End Date and Time</label> \t\t \t\t\t\t<input id="edt" name="edt" class="required" value="{$rowe['edte']}"/> \t\t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden" value="{$rowe['End_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Program No</label> \t\t \t\t\t\t<input id="programno" name="programno" class="required" value="{$rowe['Program_NO']}"/> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Quantity</label> \t\t \t\t\t\t<input id="quantity" name="quantity" class="required number" value="{$rowe['Quantity']}"/> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Remarks</label> \t\t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300">{$rowe['Remarks']}</textarea> \t\t \t\t\t\t</p> \t\t \t\t\t\t</fieldset> _END; } if (in_array($this->activityid, $this->nonproduction)) { $qe = "SELECT cust.Customer_ID,Machine_ID,comp.Drawing_ID,Operation_Description,Batch_ID,Operator_ID,prod.Program_NO,Quantity,Remarks,actl.Activity_ID,\n\t\t\t\t\t\tDATE_FORMAT(Start_Date_Time,'%d-%m-%Y %h:%i%p') as sdte,Start_Date_Time,DATE_FORMAT(End_Date_Time,'%d-%m-%Y %h:%i%p') as edte,End_Date_Time FROM ActivityLog as actl \n\t\t\t\t\t\tINNER JOIN NonProduction AS prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\n\t\t\t\t\t\tINNER JOIN Component as comp ON comp.Drawing_ID=prod.Drawing_ID\n\t\t\t\t\t\tINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID WHERE actl.Activity_Log_ID={$this->activitylogid}"; //print("<br>$qe"); if (!($rese = $cxn->query($qe))) { echo "error :", $cxn->error; exit; } $rowe = mysqli_fetch_assoc($rese); $ac = new Activity(); $ac->setActivityID($rowe['Activity_ID']); $ac->createActivityList(); $sel = new selectlist('Activity_ID', $ac->getActivityList(), 'Select Activity', 'Activity_ID', 'Activity_Name', 'class="required"', $rowe['Activity_ID']); $mc = new Machine(); $mc->createMachineList(); $sel = new selectlist('Machine_ID', $mc->getMachineList(), 'Select Machine', 'Machine_ID', 'mnslno', 'class="required"', $rowe['Machine_ID']); $cust = new Customer(); $cust->createCustomerList(); $sel = new selectlist('Customer_ID', $cust->getCustomerList(), 'Select Customer', 'Customer_ID', 'Customer_Name_Short', 'class="required"', $rowe['Customer_ID']); $part = new Part(); $part->createPartList($rowe['Customer_ID']); $req = 'class=required'; echo '<div id="drawe">'; $selc = new selectlist('Drawing_ID', $part->getPartList(), 'Select Drawing', 'Drawing_ID', 'name', 'class="required"', $rowe['Drawing_ID']); echo '</div>'; $operator = new Operator(); $operator->createOperatorList(); $sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rowe['Operator_ID']); $bn = new Batch(); $bn->setPartID($rowe['Drawing_ID']); $bn->createBatchList(); echo '<div id="batche">'; $sel = new selectlist('Batch_ID', $bn->getBatchList(), 'Select Batch', 'Batch_ID', 'Mfg_Batch_NO', 'class="required"', $rowe['Batch_ID']); echo '</div>'; echo <<<_END \t\t\t\t\t\t<fieldset> \t\t\t\t\t\t<legend>Activity Details</legend> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Operation Details</label> \t\t \t\t\t\t<input id="operationdesc" name="operationdesc" class="required" value="{$rowe['Operation_Description']}"/> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Start Date and Time</label> \t\t \t\t\t\t<input id="sdt" name="sdt" rclass="equired" value="{$rowe['sdte']}"/> \t\t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowe['Start_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>End Date and Time</label> \t\t \t\t\t\t<input id="edt" name="edt" class="required" value="{$rowe['edte']}"/> \t\t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden" value="{$rowe['End_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Program No</label> \t\t \t\t\t\t<input id="programno" name="programno" class="required" value="{$rowe['Program_NO']}"/> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Quantity</label> \t\t \t\t\t\t<input id="quantity" name="quantity" class="required number" value="{$rowe['Quantity']}"/> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Remarks</label> \t\t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300">{$rowe['Remarks']}</textarea> \t\t \t\t\t\t</p> \t\t \t\t\t\t</fieldset> _END; } if ($this->activityid == 8) { $qe = "SELECT Remarks,actl.Activity_ID,Machine_ID,Operator_ID,Idle_ID,\n\t\t\t\t\t\tDATE_FORMAT(Start_Date_Time,'%d-%m-%Y %h:%i%p') as sdte,Start_Date_Time,DATE_FORMAT(End_Date_Time,'%d-%m-%Y %h:%i%p') as edte,End_Date_Time FROM ActivityLog as actl \n\t\t\t\t\t\tINNER JOIN NonProduction AS prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\n\t\t\t\t\t\tWHERE actl.Activity_Log_ID={$this->activitylogid}"; //print("<br>$qe"); if (!($rese = $cxn->query($qe))) { echo "error :", $cxn->error; exit; } $rowe = mysqli_fetch_assoc($rese); $ac = new Activity(); $ac->setActivityID($rowe['Activity_ID']); $ac->createActivityList(); $sel = new selectlist('Activity_ID', $ac->getActivityList(), 'Select Activity', 'Activity_ID', 'Activity_Name', 'class="required"', $rowe['Activity_ID']); $mc = new Machine(); $mc->createMachineList(); $sel = new selectlist('Machine_ID', $mc->getMachineList(), 'Select Machine', 'Machine_ID', 'mnslno', 'class="required"', $rowe['Machine_ID']); self::createReasonList(); $sel = new selectlist('Idle_ID', self::getReasonList(), 'Select Idle Reason', 'Idle_ID', 'Idle_Reason', 'class="required"', $rowe['Idle_ID'], '1'); $operator = new Operator(); $operator->createOperatorList(); $sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rowe['Operator_ID']); echo <<<_END \t\t\t\t\t\t<fieldset> \t\t\t\t\t\t<legend>Activity Details</legend> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Start Date and Time</label> \t\t \t\t\t\t<input id="sdt" name="sdt" rclass="equired" value="{$rowe['sdte']}"/> \t\t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowe['Start_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>End Date and Time</label> \t\t \t\t\t\t<input id="edt" name="edt" class="required" value="{$rowe['edte']}"/> \t\t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden" value="{$rowe['End_Date_Time']}"> \t\t \t\t\t\t</p> \t\t \t\t\t\t<p> \t\t \t\t\t\t<label>Remarks</label> \t\t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300">{$rowe['Remarks']}</textarea> \t\t \t\t\t\t</p> \t\t \t\t\t\t</fieldset> _END; } self::showLogimages(); } echo <<<_END \t\t\t\t <input class="submit" type="submit" value="Save"/> _END; }
function nonProdRow() { $db = Database::getInstance(); $cxn = $db->getConnection(); if ($this->commitid != '') { $q = "SELECT *,DATE_FORMAT(Start_Date_Time,'%d-%m-%Y') as sdt,DATE_FORMAT(End_Date_Time,'%d-%m-%Y') as edt,DATE_FORMAT(Qualification_Date,'%d-%m-%Y') as qdt,DATE_FORMAT(Done_Date,'%d-%m-%Y') as ddt\n\t FROM Routecard WHERE Batch_ID={$this->batchid} AND Commit_ID={$this->commitid} AND Operation_ID={$this->operationid}"; if (!($res = $cxn->query($q))) { exit("error (nonprodrow) {$q} : {$cxn->error}"); } //print("<br>$q"); if ($res->num_rows > 0) { $r = mysqli_fetch_assoc($res); $this->startdate = $r['sdt']; $this->enddate = $r['edt']; $this->startdatedb = $r['Start_Date_Time']; $this->enddatedb = $r['End_Date_Time']; $this->acceptedqty = $r['Accepted_Qty']; $this->rejectedqty = $r['Rejected_Qty']; $this->ncqty = $r['NC_Qty']; $this->inspectedby = $r['Done_BY']; $this->inspdatedb = $r['Done_Date']; $this->approvaldate = $r['qdt']; $this->approvaldatedb = $r['Qualification_Date']; $this->approverid = $r['Qualified_BY']; $this->ncrem = $r['NC_Remarks']; $this->rejrem = $r['Rej_Remarks']; $this->remarks = $r['Remarks']; $this->routecardid = $r['Routecard_ID']; } $this->displayCommitedQty(); $ope = new Operator(); $ope->createOperatorList(); echo '<table class="tl"> <tr><th>Operation Start Date</th><td><input id="sdt" name="sdt" value="' . $this->startdate . '"><input id="sdtdb" name="sdtdb" type="hidden" value="' . $this->startdatedb . '"></td></tr> <tr><th>Operation End Date</th><td><input id="edt" name="edt" value="' . $this->enddate . '"><input id="edtdb" name="edtdb" type="hidden" value="' . $this->enddatedb . '"></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"></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"></td></tr> <tr><th>Done By</th><td>'; $sel = new selectlist("doneby", $ope->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->inspectedby, ''); echo '</td></tr> <tr><th>Re Qualified By</th><td>'; $sel = new selectlist("qualifiedby", $ope->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->approverid, ''); echo '</td></tr>'; echo '<tr><th>Re Qualification Date</th><td><input id="approvaldate" name="approvaldate" value="' . $this->approvaldate . '"><input id="approvaldatedb" name="approvaldatedb" type="hidden" value="' . $this->approvaldatedb . '">'; echo '</td></tr>'; if ($this->routecardid != '') { echo '<tr><td><input type="hidden" name="routecardid" id="routecardid" value="' . $this->routecardid . '"></td></tr>'; } echo '</table>'; } }
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"/>'; }