case 'approval': //machine list $app = new Approval(); $app->setValue('skillgroup', $_GET['sgid']); $app->createApprovarList(); $sel = new selectlist('Approver_ID', $app->getApprovarList(), 'Select Approver', 'Operator_ID', 'Operator_Name', '', '', '1'); break; case 'idle': //machine list $act = new Activitylog(); $act->createReasonList(); $sel = new selectlist('Idle_ID', $act->getReasonList(), 'Select Idle Reason', 'Idle_ID', 'Idle_Reason', 'class="required"', '', '1'); break; case 'nclog': //machine list $ncl = new NCLog(); if (isset($_GET['class'])) { $class = 'class="required"'; } else { $class = ''; } if (isset($_GET['showall'])) { $ncl->setValue('showall', 1); } if (isset($_GET['nclt'])) { $ncl->setValue('nctypeid', $_GET['nclt']); } $ncl->createNCList(); $sel = new selectlist('NonConformance_ID', $ncl->getNCList(), 'Select NC Log', 'NonConformance_ID', 'pd', $class, '', '1'); break; case 'notation':
function showPartConfiguration() { $this->setPartDetails(); echo '<table><tr>'; foreach ($this->partimagepath as $key => $value) { echo '<td><a href="' . $value . '"><img src="' . $value . '" width="200"></a></td>'; } echo '</tr></table>'; echo '<p>Record format Ref DEW-PR-R-09, Rev: Nil, Issue Date 01-12-2015<p/>'; echo '<table class="pc"><tr><th>Part Name</th><td>' . $this->partname . '</td><th>Part Number</th><td>' . $this->partno . '</td><th>Part Rev</th><td>' . $this->partrevision . '</td> <th>Drawing No</th><td>' . $this->drawingno . '</td><th>Rev</th><td>' . $this->drawingrevision . '</td><th>Customer Drawing No</th><td>' . $this->custdrwinggno . '</td></tr></table>'; echo '<table class="pc"><tr><th>Part Drawings</th><th>Process Sheets</th></tr>'; echo '<tr><td class="pc">'; $i = 0; $j = count($this->partdrawings); while ($i < $j) { if ($this->partdrawings[$i]['path'] != '') { if ($this->partdrawings[$i]['bup'] == '1') { echo $this->partdrawings[$i]['path'] . ' Rev: ' . $this->partdrawings[$i]['rev']; } else { echo '<a href="partdrawings/' . $this->partdrawings[$i]['path'] . '">' . $this->partdrawings[$i]['path'] . '</a> Rev: ' . $this->partdrawings[$i]['rev']; } } else { echo 'No Drawings Uploaded for This Part!'; } $i++; } echo '</td><td>'; if (isset($this->processsheets[0])) { $i = 0; $j = count($this->processsheets); while ($i < $j) { if ($this->processsheets[$i]['path'] != '') { if ($this->processsheets[$i]['bup'] == '1') { if ($this->showbackups != '') { echo $this->processsheets[$i]['path'] . ' Rev: ' . $this->processsheets[$i]['rev']; } } else { echo '<a href="processsheets/' . $this->processsheets[$i]['path'] . '">' . $this->processsheets[$i]['path'] . '</a> Rev: ' . $this->processsheets[$i]['rev']; } } $i++; } } else { echo 'No Process Sheets Uploaded for This Part!'; } echo '</td></tr></table>'; echo '<br>'; echo '<table class="pcd"><tr><th>Operation</th><th>Description</th><th>Rev No</th><th>NC Program</th><th>Fixtures Used</th><th>Alternate Fixture</th><th>Tool List</th><th>Notes</th><th>Operation Images</th><tr>'; $i = 0; $j = count($this->operations); while ($i < $j) { if ($this->operations[$i]['bup'] == '1') { if ($this->showbackups != '') { echo '<tr><td>' . $this->operations[$i]['path'] . '</td><td>' . $this->operations[$i]['odesc'] . '</td><td>' . $this->operations[$i]['rev'] . '</td><td></td></tr>'; } } else { if ($this->operations[$i]['path'] != '') { $opd = '<a href="operationdrawings/' . $this->operations[$i]['path'] . '">' . $this->operations[$i]['onot'] . '</a>'; } else { $opd = $this->operations[$i]['onot']; } echo '<tr><td>' . $opd . '</td><td>' . $this->operations[$i]['odesc'] . '</td><td> ' . $this->operations[$i]['rev'] . '</td><td>'; if ($this->operations[$i]['ncpath'] != '') { if ($this->operations[$i]['pno'] != 'NA') { echo '<a href="' . $this->operations[$i]['ncpath'] . $this->operations[$i]['pno'] . '">' . $this->operations[$i]['pno'] . '</a>'; } else { echo $this->operations[$i]['pno']; } } else { echo $this->operations[$i]['pno']; } echo '</td><td>' . $this->operations[$i]['fxt'] . '</td><td>' . $this->operations[$i]['af'] . '</td><td>' . $this->operations[$i]['tl'] . '</td><td>' . $this->operations[$i]['notes'] . '</td>'; if ($this->operations[$i]['opi'] != '') { $k = 0; $l = explode(',', $this->operations[$i]['opi']); $m = count($l); echo '<td><table><tr>'; while ($k < $m) { echo '<td><a href="opeimages/' . $l[$k] . '"><img src="opeimages/' . $l[$k] . '" width="50"></a></td>'; $k++; } echo '</tr></table></td>'; } else { echo '<td></td>'; } echo '</tr>'; } $i++; } echo '</table>'; echo '<table class="pc"><tr><th>Part Material</th><td>' . $this->partmaterial . '</td><th>Material Code</th><td>', $this->materialcode . '</td></tr></table>'; echo '<table class="pc"><tr><th>Raw Material Size</th><td>' . $this->rawmaterialsize . '</td><th>Premachining Size</th><td>' . $this->premachinedsize . '</td> <th>Finish Size</th><td>' . $this->finishsize . '</td><th>Weight Difference</th><td>' . $this->scrapeweight . '</td></tr></table>'; $db = Database::getInstance(); $cxn = $db->getConnection(); ///gage list for machining operations echo '<p><label>Gage Details for Part</label><p/>'; $qmo = "SELECT Operation_ID,Operation_Desc,Operation_Notation FROM Operation WHERE In_Op_List=1 AND In_Tool_List=1 AND Drawing_ID={$this->partid}"; if (!($resom = $cxn->query($qmo))) { exit("error : {$cxn->error}"); } while ($rmo = mysqli_fetch_assoc($resom)) { $qgage = "SELECT g.Gage_ID,Gage_Desc FROM Gage as g INNER JOIN Operation_Gage as og ON og.Gage_ID=g.Gage_ID \n\t\tWHERE Operation_ID={$rmo['Operation_ID']};"; if (!($rgqge = $cxn->query($qgage))) { exit("error (gage1) {$qgage} : {$cxn->error}"); } print "<p>{$rmo['Operation_Desc']}<p/>"; if ($rgqge->num_rows > 0) { echo '<table class="pcd">'; print "<tr><th>Gage Description</th><th>Qty</th><th>Gage Type</th></tr>"; while ($row6 = mysqli_fetch_assoc($rgqge)) { $q7 = "SELECT COUNT(Gage_Type)as qty,Gage_Type FROM Gage_SlNo WHERE Gage_ID={$row6['Gage_ID']} GROUP BY Gage_Type;"; if (!($r7 = $cxn->query($q7))) { exit("error (gage2) {$q7} : {$cxn->error}"); } if ($r7->num_rows > 0) { while ($row7 = mysqli_fetch_assoc($r7)) { print "<tr><td>{$row6['Gage_Desc']}</td><td>{$row7['qty']}</td><td>{$row7['Gage_Type']}</td></tr>"; } } else { print "<tr><td>{$row6['Gage_Desc']}</td><td colspan=\"2\"><label3>No gages in stock!!</label3></td></tr>"; } } print "</table>"; } else { print '<p class="v">No Gages Required For This Stage<p/>'; } } $ecn = new ECN(); $ecn->listPartECN($this->partid); $nc = new NCLog(); $nc->listPartNC($this->partid); }
<?php require_once 'autoload.php'; $nc = new NCLog(); if (isset($_POST['problemdescription'])) { print_r($_POST); //print_r($_FILES); if (isset($_POST['NonConformance_ID'])) { $nc->setValue('nonconformanceid', $_POST['NonConformance_ID']); $ncid = $_POST['NonConformance_ID']; } if (isset($_POST['NC_Type_ID'])) { $nc->setValue('nctypeid', $_POST['NC_Type_ID']); $nctypeid = $_POST['NC_Type_ID']; } $nc->setValue('ncdate', $_POST['ncddb']); if (isset($_POST['Batch_ID'])) { $nc->setValue('batchid', $_POST['Batch_ID']); } $nc->setValue('ncqty', $_POST['quantity']); $nc->setValue('ncnumber', $_POST['ncnumber']); $nc->setValue('problemdescription', $_POST['problemdescription']); $nc->setValue('correctiveaction', $_POST['correctiveaction']); $nc->setValue('correction', $_POST['correction']); $nc->setValue('containment', $_POST['containment']); $why = $_POST['why']; $reason = $_POST['reason']; $nc->setValue('stage', $_POST['stage']); $nc->setValue('effectiveness', $_POST['effectiveness']); $targetdate = $_POST['tdatedb']; $department = $_POST['department'];
<?php require_once 'autoload.php'; $_SESSION['LAST_ACTIVITY'] = time(); require_once '../tcpdf/tcpdf.php'; date_default_timezone_set('Asia/Kolkata'); $nc = new NCLog(); if (isset($_POST['NonConformance_ID'])) { //print_r($_POST); $nclid = $_POST['NonConformance_ID']; $reverified = ''; $nc->setValue('nonconformanceid', $nclid); class PDF_SKN extends TCPDF { // Page header function Header() { $nclid = $GLOBALS['nclid']; // $this->SetY(10); // $this->Image('logo.png',8,10,10); $this->SetFont('helvetica', '', 12); $this->Cell(65, 20, 'Divya Engineering Works (P) Ltd', 1, 0, 'C'); $this->Cell(73, 20, 'Corrective / Preventive Action Report', 1, 0, 'C'); $this->SetFont('helvetica', '', 10); $this->Cell(50, 5, ' Rec. For REF: DEW-QA-R-12', 'TBR', 2, 'L'); $this->Cell(50, 5, ' Rev No : A', 'BR', 2, 'L'); $this->Cell(50, 5, ' Issue Date: 31-12-2015', 'BR', 2, 'L'); $this->Cell(50, 5, ' NC Report ID: ' . $nclid, 'B R', 0, 'L'); $this->ln(); } function Footer()