function generateExcel($data = array())
{
if (isset($data['did']) && $data['did'] != '') {
$did = $data['did'];
}
if (isset($data['bid']) && $data['bid'] != '') {
$bid = $data['bid'];
}
if (isset($data['jobno']) && $data['jobno'] != '') {
$jobno = $data['jobno'];
}
if (isset($data['fairno']) && $data['fairno'] != '') {
$fairno = $data['fairno'];
}
if (isset($data['inch']) && $data['inch'] != '') {
$inch = $data['inch'];
}
if ($inch == 1) {
$this->inch = 25.4;
}
$db = Database::getInstance();
$cxn = $db->getConnection();
$part = new Part();
$part->setValue('partid', $did);
$part->setPartDetails();
$qz = "SELECT Mfg_Batch_NO FROM Batch_NO WHERE Batch_ID={$bid}";
if (!($rz = $cxn->query($qz))) {
exit("error (generateExcel 0) {$qz} : {$cxn->error}");
}
$rez = mysqli_fetch_assoc($rz);
$mfgbatchno = $rez['Mfg_Batch_NO'];
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setTitle("FAIR");
///form 1
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setTitle("Form 1");
$objPHPExcel->getActiveSheet()->mergeCells('A1:B1');
$objPHPExcel->getActiveSheet()->SetCellValue('A1', '1. Part Number');
$objPHPExcel->getActiveSheet()->mergeCells('A2:B2');
$objPHPExcel->getActiveSheet()->SetCellValue('A2', $part->getValue('partno'));
$objPHPExcel->getActiveSheet()->mergeCells('C1:D1');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', '2. Part Name');
$objPHPExcel->getActiveSheet()->mergeCells('C2:D2');
$objPHPExcel->getActiveSheet()->SetCellValue('C2', $part->getValue('partname'));
$objPHPExcel->getActiveSheet()->mergeCells('E1:F1');
$objPHPExcel->getActiveSheet()->SetCellValue('E1', '3. Serial Number');
$objPHPExcel->getActiveSheet()->mergeCells('E2:F2');
$objPHPExcel->getActiveSheet()->mergeCells('G1:H1');
$objPHPExcel->getActiveSheet()->SetCellValue('G1', '4. FAIR Number');
$objPHPExcel->getActiveSheet()->mergeCells('G2:H2');
$objPHPExcel->getActiveSheet()->SetCellValue('G2', $fairno);
$objPHPExcel->getActiveSheet()->mergeCells('A3:B3');
$objPHPExcel->getActiveSheet()->SetCellValue('A3', '5. Part Revision Level');
$objPHPExcel->getActiveSheet()->mergeCells('A4:B4');
$objPHPExcel->getActiveSheet()->SetCellValue('A4', $part->getValue('partrevision'));
$objPHPExcel->getActiveSheet()->mergeCells('C3:D3');
$objPHPExcel->getActiveSheet()->SetCellValue('C3', '6. Drawing Number');
$objPHPExcel->getActiveSheet()->mergeCells('C4:D4');
$objPHPExcel->getActiveSheet()->SetCellValue('C4', $part->getValue('drawingno'));
$objPHPExcel->getActiveSheet()->mergeCells('E3:F3');
$objPHPExcel->getActiveSheet()->SetCellValue('E3', '7. Drawing Revision Level');
$objPHPExcel->getActiveSheet()->mergeCells('E4:F4');
$objPHPExcel->getActiveSheet()->SetCellValue('E4', $part->getValue('drawingrevision'));
$objPHPExcel->getActiveSheet()->mergeCells('G3:H3');
$objPHPExcel->getActiveSheet()->SetCellValue('G3', '8. Additional Changes');
$objPHPExcel->getActiveSheet()->mergeCells('G4:H4');
$objPHPExcel->getActiveSheet()->mergeCells('A5:B5');
$objPHPExcel->getActiveSheet()->SetCellValue('A5', '9. Manufactiring Process Reference');
$objPHPExcel->getActiveSheet()->mergeCells('A6:B6');
$objPHPExcel->getActiveSheet()->SetCellValue('A6', $mfgbatchno);
$objPHPExcel->getActiveSheet()->mergeCells('C5:D5');
$objPHPExcel->getActiveSheet()->SetCellValue('C5', '10. Organization Name');
$objPHPExcel->getActiveSheet()->mergeCells('C5:D5');
$objPHPExcel->getActiveSheet()->SetCellValue('C5', 'Divya Engineering Works (P) Ltd');
$objPHPExcel->getActiveSheet()->mergeCells('E5:F5');
$objPHPExcel->getActiveSheet()->SetCellValue('E5', '11. Supplier Code');
$objPHPExcel->getActiveSheet()->mergeCells('E6:F6');
$objPHPExcel->getActiveSheet()->SetCellValue('E6', '');
$objPHPExcel->getActiveSheet()->mergeCells('G5:H5');
$objPHPExcel->getActiveSheet()->SetCellValue('G5', '12. P.O. Number');
$objPHPExcel->getActiveSheet()->mergeCells('G6:H6');
$objPHPExcel->getActiveSheet()->SetCellValue('G6', '');
$objPHPExcel->getActiveSheet()->mergeCells('A7:B7');
$objPHPExcel->getActiveSheet()->SetCellValue('A7', '13. Detail Part');
$objPHPExcel->getActiveSheet()->mergeCells('A8:B9');
$objPHPExcel->getActiveSheet()->SetCellValue('A8', 'Assembly FAI:');
$objPHPExcel->getActiveSheet()->mergeCells('C7:H7');
$objPHPExcel->getActiveSheet()->SetCellValue('C7', '14. Fill FAI: Partial FAI:');
$objPHPExcel->getActiveSheet()->mergeCells('C8:H8');
$objPHPExcel->getActiveSheet()->SetCellValue('C8', 'Baseline Part Number (including revision level):');
$objPHPExcel->getActiveSheet()->mergeCells('C9:H9');
$objPHPExcel->getActiveSheet()->SetCellValue('C9', 'Reason for Partial FAI:');
$objPHPExcel->getActiveSheet()->mergeCells('A10:H10');
$objPHPExcel->getActiveSheet()->SetCellValue('A10', 'a) If above part number is a detail part only, go to field 19.');
$objPHPExcel->getActiveSheet()->mergeCells('A11:H11');
$objPHPExcel->getActiveSheet()->SetCellValue('A11', 'b) If above part number is an assembly, go to the "INDEX" section below.');
$objPHPExcel->getActiveSheet()->mergeCells('A12:H12');
$objPHPExcel->getActiveSheet()->SetCellValue('A12', 'INDEX of part numbers or sub-assembly numbers required to make the assembly noted above.');
$objPHPExcel->getActiveSheet()->mergeCells('A13:B13');
$objPHPExcel->getActiveSheet()->SetCellValue('A13', '15. Part Number:');
$objPHPExcel->getActiveSheet()->mergeCells('C13:D13');
$objPHPExcel->getActiveSheet()->SetCellValue('C13', '16. Part Name:');
$objPHPExcel->getActiveSheet()->mergeCells('E13:F13');
$objPHPExcel->getActiveSheet()->SetCellValue('E13', '17. Part Serial Number:');
$objPHPExcel->getActiveSheet()->mergeCells('G13:H13');
$objPHPExcel->getActiveSheet()->SetCellValue('G13', '18. FAIR Number:');
$ir = 14;
while ($ir < 31) {
$objPHPExcel->getActiveSheet()->mergeCells('A' . $ir . ':B' . $ir);
$objPHPExcel->getActiveSheet()->mergeCells('C' . $ir . ':D' . $ir);
$objPHPExcel->getActiveSheet()->mergeCells('E' . $ir . ':F' . $ir);
$objPHPExcel->getActiveSheet()->mergeCells('G' . $ir . ':H' . $ir);
$ir++;
}
$objPHPExcel->getActiveSheet()->mergeCells('A31:B32');
$objPHPExcel->getActiveSheet()->SetCellValue('A31', '19. Signature');
$objPHPExcel->getActiveSheet()->mergeCells('C31:D32');
$objPHPExcel->getActiveSheet()->SetCellValue('C31', 'FAI Complete');
$objPHPExcel->getActiveSheet()->mergeCells('E31:F32');
$objPHPExcel->getActiveSheet()->SetCellValue('E31', 'FAI Not Complete');
$objPHPExcel->getActiveSheet()->mergeCells('G31:H32');
$objPHPExcel->getActiveSheet()->SetCellValue('G31', '20. Date:');
$objPHPExcel->getActiveSheet()->mergeCells('A33:F33');
$objPHPExcel->getActiveSheet()->SetCellValue('A33', '21. Reviewed By');
$objPHPExcel->getActiveSheet()->mergeCells('G33:H33');
$objPHPExcel->getActiveSheet()->SetCellValue('G33', '22. Date:');
$objPHPExcel->getActiveSheet()->mergeCells('A34:F34');
$objPHPExcel->getActiveSheet()->SetCellValue('A34', '23. Customer Approval');
$objPHPExcel->getActiveSheet()->mergeCells('G34:H34');
$objPHPExcel->getActiveSheet()->SetCellValue('G34', '24. Date:');
///form 2
$objPHPExcel->createSheet(1);
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle("Form 2");
$objPHPExcel->getActiveSheet()->mergeCells('A1:H2');
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'FORM 2 - Product Accountability - Materials, Special Processes, and Functional Testing');
$objPHPExcel->getActiveSheet()->mergeCells('A2:B2');
$objPHPExcel->getActiveSheet()->SetCellValue('A2', '1. Part Number');
$objPHPExcel->getActiveSheet()->mergeCells('A3:B3');
$objPHPExcel->getActiveSheet()->SetCellValue('A3', '');
$objPHPExcel->getActiveSheet()->mergeCells('C2:D2');
$objPHPExcel->getActiveSheet()->SetCellValue('C2', '2. Part Name');
$objPHPExcel->getActiveSheet()->mergeCells('C3:D3');
$objPHPExcel->getActiveSheet()->SetCellValue('C3', '');
$objPHPExcel->getActiveSheet()->mergeCells('E2:F2');
$objPHPExcel->getActiveSheet()->SetCellValue('E2', '3. Serial Number');
$objPHPExcel->getActiveSheet()->mergeCells('E3:F3');
$objPHPExcel->getActiveSheet()->mergeCells('G2:H2');
$objPHPExcel->getActiveSheet()->SetCellValue('G2', '4. FAIR Number');
$objPHPExcel->getActiveSheet()->mergeCells('G3:H3');
$objPHPExcel->getActiveSheet()->SetCellValue('G3', '');
$objPHPExcel->getActiveSheet()->mergeCells('A4:B4');
$objPHPExcel->getActiveSheet()->SetCellValue('A4', '5. Material or Process Name:');
$objPHPExcel->getActiveSheet()->mergeCells('A5:B5');
$objPHPExcel->getActiveSheet()->SetCellValue('A5', '');
$objPHPExcel->getActiveSheet()->SetCellValue('C4', '6. Specification Number:');
$objPHPExcel->getActiveSheet()->SetCellValue('C5', '');
$objPHPExcel->getActiveSheet()->SetCellValue('D4', '7. Code:');
$objPHPExcel->getActiveSheet()->SetCellValue('D5', '');
$objPHPExcel->getActiveSheet()->SetCellValue('E4', '8. Supplier:');
$objPHPExcel->getActiveSheet()->SetCellValue('E5', '');
$objPHPExcel->getActiveSheet()->SetCellValue('G4', '9. Customer Approval Verification:');
$objPHPExcel->getActiveSheet()->SetCellValue('G5', '');
$objPHPExcel->getActiveSheet()->SetCellValue('H4', '10. Certificate of Conformance Number:');
$objPHPExcel->getActiveSheet()->SetCellValue('H5', '');
$ir = 6;
while ($ir < 20) {
$objPHPExcel->getActiveSheet()->mergeCells('A' . $ir . ':B' . $ir);
$ir++;
}
$objPHPExcel->getActiveSheet()->mergeCells('A21:D21');
$objPHPExcel->getActiveSheet()->SetCellValue('A21', '11. Functional Test Procedure Number:');
$objPHPExcel->getActiveSheet()->mergeCells('E21:H21');
$objPHPExcel->getActiveSheet()->SetCellValue('E21', '12. Acceptance Report Number:');
$ir = 22;
while ($ir < 29) {
$objPHPExcel->getActiveSheet()->mergeCells('A' . $ir . ':D' . $ir);
$objPHPExcel->getActiveSheet()->mergeCells('E' . $ir . ':H' . $ir);
$ir++;
}
$objPHPExcel->getActiveSheet()->mergeCells('A29:H30');
$objPHPExcel->getActiveSheet()->SetCellValue('A29', '13. Comments:');
$objPHPExcel->getActiveSheet()->mergeCells('A31:F32');
$objPHPExcel->getActiveSheet()->SetCellValue('A31', '14. Signature:');
$objPHPExcel->getActiveSheet()->mergeCells('G31:H32');
$objPHPExcel->getActiveSheet()->SetCellValue('G31', '15. Date:');
//form 3
$objPHPExcel->createSheet(2);
$objPHPExcel->setActiveSheetIndex(2);
$objPHPExcel->getActiveSheet()->setTitle("Form 3");
$objPHPExcel->getActiveSheet()->mergeCells('A1:C3');
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Divya Engineering Works (P) Ltd');
$objPHPExcel->getActiveSheet()->mergeCells('D1:F3');
$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'First Article Inspection Report');
$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Record Format Ref: DEW-QA-R-04');
$objPHPExcel->getActiveSheet()->SetCellValue('G2', 'Rev: Nil');
$objPHPExcel->getActiveSheet()->SetCellValue('G3', 'Issue Date: 01-12-2015');
$styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => '000000'), 'size' => 12, 'name' => 'Verdana'));
$objPHPExcel->getActiveSheet()->getStyle('A1:G3')->applyFromArray($styleArray);
$objPHPExcel->getActiveSheet()->getStyle('A1:G3')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1:G3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->mergeCells('A4:B4');
$objPHPExcel->getActiveSheet()->SetCellValue('A4', 'Part Name:' . $part->getValue('partname'));
$objPHPExcel->getActiveSheet()->mergeCells('C4:D4');
$objPHPExcel->getActiveSheet()->SetCellValue('C4', 'Part No and Rev:' . $part->getValue('partno') . ' : ', $part->getValue('partrevision'));
$styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => '8470ff'), 'size' => 12, 'name' => 'Verdana'));
$objPHPExcel->getActiveSheet()->getStyle('A4:D4')->applyFromArray($styleArray);
$q1 = "SELECT DISTINCT(op.Operation_ID),Operation_Notation,Operation_Desc,Ope_Drawing_ID FROM Operation as op \n\tINNER JOIN Ope_Drawing as od on od.Link_ID=op.Operation_ID \n\tINNER JOIN Dimn_Observation as do on do.Ope_Rev_ID=od.Ope_Drawing_ID WHERE op.Drawing_ID={$did} AND do.Batch_ID={$bid} AND In_Tool_List=1";
if (!($r1 = $cxn->query($q1))) {
exit("error (generateExcel) {$q1} : {$cxn->error}");
}
$r = 5;
while ($ro1 = mysqli_fetch_assoc($r1)) {
$this->operationid = $ro1['Operation_ID'];
$this->opedrawingid = $ro1['Ope_Drawing_ID'];
$this->getDimensionsforOperation();
$objPHPExcel->getActiveSheet()->mergeCells('A' . $r . ':D' . $r);
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $r, 'Operation: ' . $ro1['Operation_Notation'] . ' ' . $ro1['Operation_Desc']);
$cc = PHPExcel_Cell::stringFromColumnIndex(5 + count($jobno));
$objPHPExcel->getActiveSheet()->mergeCells('G' . $r . ':' . $cc . $r);
$objPHPExcel->getActiveSheet()->SetCellValue('G' . $r, 'Observed Dimensions');
$r++;
$hr = $r;
//store row number to output headings
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $hr, 'Baloon No');
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $hr, 'Zone');
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $hr, 'Characteristic');
$objPHPExcel->getActiveSheet()->SetCellValue('D' . $hr, 'Description');
$objPHPExcel->getActiveSheet()->SetCellValue('E' . $hr, 'Basic Dimension');
$objPHPExcel->getActiveSheet()->SetCellValue('F' . $hr, 'Tolerance');
$objPHPExcel->getActiveSheet()->SetCellValue('G' . $hr, 'Instrument');
$styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => '000080'), 'size' => 12, 'name' => 'Verdana'));
$objPHPExcel->getActiveSheet()->getStyle('A' . $hr . ':G' . $hr)->applyFromArray($styleArray);
$r++;
$rm1 = $r;
// var_dump($this->lrows);
$z = 0;
$y = 0;
while ($y < count($this->lrows)) {
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $r, $this->lrows[$z][0]);
$objPHPExcel->getActiveSheet()->SetCellValue('B' . $r, $this->lrows[$z][1]);
$objPHPExcel->getActiveSheet()->SetCellValue('C' . $r, $this->lrows[$z][2]);
$objPHPExcel->getActiveSheet()->SetCellValue('D' . $r, $this->lrows[$z][3]);
$objPHPExcel->getActiveSheet()->SetCellValue('E' . $r, $this->lrows[$z][4]);
$objPHPExcel->getActiveSheet()->SetCellValue('F' . $r, $this->lrows[$z][5]);
$objPHPExcel->getActiveSheet()->SetCellValue('G' . $r, $this->lrows[$z][6]);
$styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => '696969'), 'size' => 11, 'name' => 'Verdana'));
$objPHPExcel->getActiveSheet()->getStyle('A' . $r . ':G' . $r)->applyFromArray($styleArray);
$r++;
$y++;
$z++;
}
$cn = 7;
///column H
//var_dump($jobno);
foreach ($jobno as $key => $value) {
$q2 = "SELECT Dimn_Observation_ID FROM Dimn_Observation WHERE Batch_ID={$bid} AND Ope_Rev_ID={$this->opedrawingid} AND Job_NO={$value}";
if (!($r2 = $cxn->query($q2))) {
exit("error (generateExcel) {$q2} : {$cxn->error}");
}
$ro2 = mysqli_fetch_assoc($r2);
$qry = "SELECT dimn.Dimension_ID, dimn.Operation_ID,DATE_FORMAT(Insp_Date,'%d/%m/%y') as sdt,Operator_Name,Instrument_SLNO,\n\t\t\tBasic_Dimn, ob.Dimn_Observation_ID, Batch_ID,Baloon_NO,ob.Remarks,\n\t\t\tJob_NO, Observed_Dimn,ob.Comment_ID,Comment FROM Observations as ob\n\t\t\tINNER JOIN Dimn_Observation as do ON do.Dimn_Observation_ID=ob.Dimn_Observation_ID\n\t\t\tLEFT OUTER JOIN Dimn_Comment AS dc ON dc.Comment_ID=ob.Comment_ID \n\t\t\tINNER JOIN Operator as ope ON ope.Operator_ID=do.Operator_ID \n\t\t\tINNER JOIN Instrument as ins ON ins.Instrument_ID=ob.Instrument_ID\n\t\t\tRIGHT OUTER JOIN Dimension as dimn ON dimn.Dimension_ID = ob.Dimension_ID \n\t\t\tAND do.Dimn_Observation_ID={$ro2['Dimn_Observation_ID']} AND do.Job_NO={$value}\n\t\t\tWHERE dimn.Ope_Drawing_ID = {$this->opedrawingid} ORDER BY Baloon_NO ASC";
// print("$qry<br>");
if (!($rest = $cxn->query($qry))) {
exit("error (generateExcel 3) {$qry} : {$cxn->error}");
}
$x = 0;
$rm2 = $rm1;
while ($row = mysqli_fetch_assoc($rest)) {
$inst = '';
if (strpos($row['Observed_Dimn'], '|')) {
$gonogo = explode('|', $row['Observed_Dimn']);
$go = ', Go: ' . $gonogo[0] . ', No Go: ' . $gonogo[1];
} else {
$go = '';
}
if ($row['Comment'] == '') {
$obt = explode('/', $row['Observed_Dimn']);
$o = '';
$ii = 0;
$jj = count($obt);
while ($ii < $jj) {
$o .= round($obt[$ii] / $this->inch, 4);
if (isset($obt[$ii + 1])) {
$o .= '/';
}
$ii++;
}
if ($o == '0') {
$o = '';
}
if ($row['Instrument_SLNO'] != '') {
$inst = ' Instrument: ' . $row['Instrument_SLNO'];
}
$ob = $o;
} else {
$ob = $row['Comment'] . $go;
}
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($cn, $hr, 'Part No:' . $value);
$styleArray = array('font' => array('bold' => true, 'color' => array('rgb' => '00bfff'), 'size' => 12, 'name' => 'Verdana'));
$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($cn, $hr)->applyFromArray($styleArray);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($cn, $rm2, $ob . $inst . $row['Remarks']);
$rm2++;
$this->rrows[$z][$x] = $ob . $inst . $row['Remarks'];
$this->name[$z] = $row['Operator_Name'];
$x += 1;
}
$cn++;
}
$r++;
}
foreach (range('A', $cc) as $columnID) {
$objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
ob_end_clean();
$fair = $did . '-FAIR.xlsx';
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename={$fair}");
// Write file to the browser
$objWriter->save('php://output');
}
$pdf->AddPage();
$pdf->setY(56);
$r = 1;
}
$pdf->SetFont('helvetica', '', 10);
//body font
if ($r) {
$pdf->Cell(20, 8, $k, 0, 0, 'C');
///print serial no
} else {
$pdf->Cell(20, 8, '', 0, 0, 'C');
//no serial no
}
$part = new Part();
$part->setPartID($dq_list[$j][0]);
$part->setPartDetails();
$pdf->MultiCell(80, 8, $part->getPartName() . " " . $part->getDrawingNO() . ' Rev No: ' . $part->getPartRevision(), 0, 'L', 0, 0, '', '', true, 0, false, true, 8, 'M', true);
//part name and drawing no
$pdf->Cell(35, 8, $dq_list[$j][1], 0, 0, 'C');
//total quantity
$pdf->Cell(50, 8, $dq_list[$j][2], 0, 1, 'L');
//remarks for each part
///print material receipt details
if ($cqr_list[$j][0] != '') {
$t = 0;
while ($t < $dq_list[$j][1]) {
$t += $cqr_list[$l][2];
$pdf->SetFont('helvetica', 'I', 8);
//body font
$pma = new PartMaterial();
$pma->setMIDQID($cqr_list[$l][1]);
} else {
$message = $upload->show_errors();
print "{$message}";
}
}
} else {
if (isset($_POST['save']) && $_POST['save'] == '2') {
$rou->setValue('batchid', $_POST['Batch_ID']);
$c = new Part();
if (isset($_POST['Drawing_ID'])) {
$did = $_POST['Drawing_ID'];
} else {
$did = $_POST['drawing'];
}
$c->setValue('partid', $did);
$c->setPartDetails();
$rou->setBatchDetails();
$cname = $c->getValue('partname');
$partno = $c->getValue('partno');
$heatcode = $rou->getValue('heatcode');
$materialcode = $rou->getValue('materialcode');
$batchdesc = $rou->getValue('batchdesc');
$bremark = $rou->getValue('bremark');
$bqty = $rou->getValue('batchqty');
$dewid = $c->getValue('dewpartid');
class PDF_SKN extends TCPDF
{
// Page header
function Header()
{
$cname = $GLOBALS['cname'];
function generateLabels($data = array())
{
if (isset($data['did']) && $data['did'] != '') {
$did = $data['did'];
}
if (isset($data['bid']) && $data['bid'] != '') {
$bid = $data['bid'];
$this->batchid = $bid;
}
if (isset($data['sno']) && $data['sno'] != '') {
$sno = $data['sno'];
} else {
$sno = 1;
}
// if(isset($data['eno'])&&$data['eno']!=''){$eno=$data['eno'];}else{$eno=1;}
$db = Database::getInstance();
$cxn = $db->getConnection();
$part = new Part();
$part->setValue('partid', $did);
$part->setPartDetails();
$qz = "SELECT Mfg_Batch_NO FROM Batch_NO WHERE Batch_ID={$bid}";
if (!($rz = $cxn->query($qz))) {
exit("error (generateExcel 0) {$qz} : {$cxn->error}");
}
$rez = mysqli_fetch_assoc($rz);
$mfgbatchno = $rez['Mfg_Batch_NO'];
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setTitle("Labels");
///form 1
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT);
$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$rh = 20;
///row height
$cw = 33;
///column width
$objPHPExcel->getActiveSheet()->getPageMargins()->setTop(0.5);
$objPHPExcel->getActiveSheet()->getPageMargins()->setRight(0.5);
$objPHPExcel->getActiveSheet()->getPageMargins()->setLeft(0.02);
$objPHPExcel->getActiveSheet()->getPageMargins()->setBottom(0.5);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth($cw);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth($cw);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth($cw);
$objPHPExcel->getActiveSheet()->setTitle("Form 1");
$cs = 0;
$rs = 1;
$n = 0;
$jn = $sno;
while ($n < $this->getBatchQty()) {
$rs1 = $rs + 1;
$rs2 = $rs + 2;
$rs3 = $rs + 3;
$objPHPExcel->getActiveSheet()->getRowDimension($rs)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('0', $rs, $part->getValue('partname'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs1)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('0', $rs1, 'DEW ID: ' . $part->getValue('dewpartid'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs2)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('0', $rs2, 'Batch: ' . $mfgbatchno);
$objPHPExcel->getActiveSheet()->getRowDimension($rs3)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('0', $rs3, 'Job Serial No:' . $jn);
$n++;
$jn++;
$objPHPExcel->getActiveSheet()->getRowDimension($rs)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('1', $rs, $part->getValue('partname'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs1)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('1', $rs1, 'DEW PART ID: ' . $part->getValue('dewpartid'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs2)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('1', $rs2, 'Batch No:' . $mfgbatchno);
$objPHPExcel->getActiveSheet()->getRowDimension($rs3)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('1', $rs3, 'Job Serial No:' . $jn);
$n++;
$jn++;
$objPHPExcel->getActiveSheet()->getRowDimension($rs)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('2', $rs, $part->getValue('partname'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs1)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('2', $rs1, 'DEW PART ID: ' . $part->getValue('dewpartid'));
$objPHPExcel->getActiveSheet()->getRowDimension($rs2)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('2', $rs2, 'Batch No:' . $mfgbatchno);
$objPHPExcel->getActiveSheet()->getRowDimension($rs3)->setRowHeight($rh);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow('2', $rs3, 'Job Serial No:' . $jn);
$n++;
$jn++;
$rs += 5;
}
// foreach(range('A1','B1') as $columnID)
// {
// $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);
// }
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
ob_end_clean();
$fair = $did . '-labels.xlsx';
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename={$fair}");
// Write file to the browser
$objWriter->save('php://output');
}
function showToolList($div = null)
{
$db = Database::getInstance();
$cxn = $db->getConnection();
if ($this->opedrawingid != '') {
$qp = "SELECT comp.Drawing_ID FROM Component as comp inner join Operation as op on op.Drawing_ID=comp.Drawing_ID\n\t\tinner join Ope_Drawing as od on od.Link_ID=op.Operation_ID WHERE Ope_Drawing_ID={$this->opedrawingid}";
if (!($resp = $cxn->query($qp))) {
exit("error (showToolList) {$qp} : {$cxn->error}");
}
$rp = mysqli_fetch_assoc($resp);
$drawingid = $rp['Drawing_ID'];
if ($div != null) {
$class = '"tl"';
} else {
$class = '"tt"';
}
$query = 'SELECT Ope_Tool_ID,Ope_Tool_OH,Ope_Tool_Desc,Tool_ID_1,Ope_Tool_Life,Cutting_Mins,Image_Path,Operator_Name,DATE_FORMAT(App_Date_Time,"%d-%m-%Y") as apd,App_Remarks,
(SELECT CONCAT(Tool_Desc," ( ",Mfg_Part_NO," )") FROM Tool WHERE Tool_ID=ot.Tool_ID_1) as td1,
(SELECT CONCAT(Tool_Desc," ( ",Mfg_Part_NO," )") FROM Tool WHERE Tool_ID=ot.Tool_ID_2)as td2,
(SELECT CONCAT(Mfg_Part_NO," ",Tool_Desc) FROM ToolBody WHERE ToolBody_ID=ot.ToolBody_ID_1) as i1,
(SELECT CONCAT(Mfg_Part_NO," ",Tool_Desc) FROM ToolBody WHERE ToolBody_ID=ot.ToolBody_ID_2) as i2,
(SELECT Brand_Description FROM Tool_Brand as tb INNER JOIN Tool as t1 ON t1.Brand_ID=tb.Brand_ID WHERE t1.Tool_ID=ot.Tool_ID_1) as tb1,
(SELECT Brand_Description FROM Tool_Brand as tb2 INNER JOIN Tool as t2 ON t2.Brand_ID=tb2.Brand_ID WHERE t2.Tool_ID=ot.Tool_ID_2) as tb2,
(SELECT Holder_Description FROM Holder as h1 WHERE Holder_ID=ot.Holder_ID_1) as hd1,
(SELECT Holder_Description FROM Holder as h2 WHERE Holder_ID=ot.Holder_ID_2) as hd2
FROM Ope_Tool AS ot
LEFT OUTER JOIN Ope_Tool_Image as oti ON oti.Link_ID=ot.Ope_Tool_ID
INNER JOIN Ope_Tool_Approval as ota ON ota.Ope_Drawing_ID=ot.Ope_Drawing_ID
INNER JOIN Operator as ope on ope.Operator_ID=ota.Approved_BY WHERE ot.Ope_Drawing_ID=' . $this->opedrawingid . ' AND Deleted=0';
if ($div != null) {
$query .= ' AND ota.Approved_BY!=0';
}
// print($q);
if (!($res = $cxn->query($query))) {
exit("error (showToolList) {$query}: {$cxn->error}");
} else {
if ($res->num_rows > 0) {
echo '<h2>Tool List</h2>Record Format Ref DEW-WI-T-02, Rev: Nil,Issue Date 01-12-2015';
echo '<p class="gr">WI No: DEW-WI-T-' . $drawingid . '-' . $this->opedrawingid;
$p = new Part();
$p->setValue('partid', $drawingid);
$p->setPartDetails();
$dewid = $p->getValue('dewpartid');
print "<p>DEW ID: {$dewid}</p>";
print "<p>Tools Aded To this Operation</p>";
print "<table class={$class}>";
print "<tr>";
if ($div != null) {
print "<th>Details</th>";
}
print "<th>Preferred Tool and Insert</th><th>Alternate Tool and Insert</th><th>Description</th><th>Preffered Holder</th>\n\t\t\t\t\t\t\t\t<th>Alternate Holder</th><th>Tool Overhang</th><th>Cutting Mins</th><th>Tool Life</th><th>Tool Images</th></tr>";
$i = 0;
while ($row = mysqli_fetch_assoc($res)) {
$appby = 'Approved By : ' . $row['Operator_Name'] . ' On ' . $row['apd'] . ', Remarks:' . $row['App_Remarks'];
if ($row['Image_Path'] != '') {
$otpath = 'opetoolimages/' . $row['Image_Path'];
$img = '<a href="' . $otpath . '" target=\\"_NEW\\">Tool Image</a>';
} else {
$img = '';
}
if ($row['Ope_Tool_Life'] != 0) {
$tl = $row['Ope_Tool_Life'];
} else {
$tl = '';
}
if ($row['td2'] != '') {
$t2 = '<font color=\\"green\\">' . $row['tb2'] . ' Make ' . $row['td2'] . ' ' . $row['i2'] . '</font>';
} else {
$t2 = '';
}
print "<tr>";
if ($div != null) {
print "<td><input type=\"radio\" name=\"tinfo\" class=\"tinfo\" id=\"tinfo[{$i}]\" value=\"{$row['Tool_ID_1']}\"></input></td>";
}
print "<td>{$row['tb1']} Make {$row['td1']} {$row['i1']}</td><td>{$t2}</td><td>{$row['Ope_Tool_Desc']}</td>\n\t\t\t\t\t\t<td>{$row['hd1']}</td><td>{$row['hd2']}</td><td>{$row['Ope_Tool_OH']} mm</td><td>{$row['Cutting_Mins']}</td><td>{$row['Ope_Tool_Life']}</td>";
if ($div != null) {
print "<td>{$img}</td></tr><tr><tr><td colspan=\"12\"><div id=\"{$i}\"></div></td></tr>";
} else {
print "</tr>";
}
$i++;
}
print "</table>";
echo '<p>' . $appby . '<p/>';
} else {
print "No Tools Added for this Operation Or Tool List is Not Approved";
}
}
}
}
