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()