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