List of usage examples for org.apache.poi.xwpf.usermodel XWPFTable createRow
public XWPFTableRow createRow()
From source file:AkashApplications.src.GenerateInvoice.java
public boolean printInvoice(boolean printCommand) throws FileNotFoundException, InvalidFormatException, IOException { XWPFDocument document = new XWPFDocument(); CTSectPr sectPr = document.getDocument().getBody().addNewSectPr(); CTPageMar pageMar = sectPr.addNewPgMar(); pageMar.setLeft(BigInteger.valueOf(720L)); pageMar.setTop(BigInteger.valueOf(460L)); pageMar.setRight(BigInteger.valueOf(720L)); pageMar.setBottom(BigInteger.valueOf(460L)); XWPFParagraph dateP = document.createParagraph(); XWPFRun dateRun = dateP.createRun(); dateRun.addBreak();/*from w ww . j a v a 2 s . co m*/ dateRun.setText(copyType); dateRun.setFontSize(8); dateRun.setItalic(true); dateP.setAlignment(ParagraphAlignment.RIGHT); dateRun.addBreak(); XWPFParagraph title = document.createParagraph(); XWPFRun titleRun = title.createRun(); titleRun.addBreak(); titleRun.setText("Delivery Challan"); titleRun.setBold(true); title.setAlignment(ParagraphAlignment.CENTER); titleRun.addBreak(); //header table XWPFTable productTable = document.createTable(); productTable.setCellMargins(50, 50, 50, 50); productTable.getCTTbl().getTblPr().unsetTblBorders(); productTable.getCTTbl().addNewTblPr().addNewTblW().setW(BigInteger.valueOf(11000)); XWPFTableRow row1 = productTable.getRow(0); XWPFTableCell cellSellerBuyer = row1.getCell(0); cellSellerBuyer.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(5000)); CTTc ctTc = cellSellerBuyer.getCTTc(); CTTcPr tcPr = ctTc.getTcPr(); CTTcBorders border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); // border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph seller = cellSellerBuyer.addParagraph(); XWPFRun sellerRun = seller.createRun(); seller.setAlignment(ParagraphAlignment.LEFT); sellerRun.setText("Buyer :"); sellerRun.addBreak(); String[] ar = buyerAddress.split("\n"); for (String s : ar) { sellerRun.setText(s); sellerRun.addBreak(); } XWPFTableCell cellProductDesc = row1.createCell(); cellProductDesc.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(6000)); ctTc = cellProductDesc.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); //border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph productDesc = cellProductDesc.addParagraph(); productDesc.setAlignment(ParagraphAlignment.LEFT); XWPFRun runInvoice = productDesc.createRun(); // if(table.getRowCount() == 1) // { // runInvoice.addTab(); // runInvoice.addTab(); // runInvoice.addTab(); // String imgLoc = "Barcodes/"+ dtm.getValueAt(0, 6) +".jpg"; // FileInputStream image = new FileInputStream(imgLoc); // runInvoice.addPicture(image, XWPFDocument.PICTURE_TYPE_JPEG,imgLoc, Units.toEMU(200), Units.toEMU(50)); // runInvoice.addBreak(); // runInvoice.addBreak(); // } runInvoice.setText("Delivery Note : "); runInvoice.addTab(); runInvoice.setText(invoiceNote); runInvoice.addBreak(); runInvoice.addBreak(); runInvoice.addBreak(); runInvoice.setText("Date : "); runInvoice.addTab(); runInvoice.setText(date); runInvoice.addBreak(); runInvoice.addBreak(); //document.createParagraph().createRun().addBreak(); XWPFTable productDetails = document.createTable(); productDetails.setCellMargins(50, 50, 50, 50); //productDetails.getCTTbl().getTblPr().addNewJc().setVal(STJc.RIGHT); productDetails.getCTTbl().getTblPr().unsetTblBorders(); productDetails.getCTTbl().addNewTblPr().addNewTblW().setW(BigInteger.valueOf(11000)); XWPFTableRow pDetailHeader = productDetails.getRow(0); XWPFTableCell header0 = pDetailHeader.getCell(0); header0.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); XWPFParagraph headerText = header0.addParagraph(); XWPFRun run = headerText.createRun(); run.setText("Sl. No."); run.setBold(true); ctTc = header0.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFTableCell header1 = pDetailHeader.createCell(); header1.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); XWPFParagraph headerText1 = header1.addParagraph(); XWPFRun run1 = headerText1.createRun(); run1.setText("Description of Goods"); run1.setBold(true); ctTc = header1.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFTableCell header4 = pDetailHeader.createCell(); header4.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); XWPFParagraph headerText4 = header4.addParagraph(); XWPFRun run4 = headerText4.createRun(); run4.setText("Quantity"); run4.setBold(true); ctTc = header4.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); for (int i = 0; i < 1; i++) { XWPFTableRow fTableRow = productDetails.createRow(); for (int j = 0; j < 4; j++) { XWPFTableCell cell = fTableRow.getCell(j); try { ctTc = cell.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); //border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); if (i == 0) border.addNewTop().setVal(STBorder.SINGLE); } catch (Exception e) { System.err.println(e.getMessage()); } switch (j) { case 0: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); break; case 1: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); break; case 2: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); break; } } } int qty = 0; for (int i = 0; i < table.getRowCount(); i++) { XWPFTableRow fTableRow = productDetails.createRow(); for (int j = 0; j < table.getColumnCount() - 1; j++) { XWPFTableCell cell = fTableRow.getCell(j); try { ctTc = cell.getCTTc(); tcPr = ctTc.addNewTcPr(); border = tcPr.addNewTcBorders(); if (i == table.getRowCount() - 1) border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); // border.addNewTop().setVal(STBorder.SINGLE); } catch (Exception e) { System.err.println(e.getMessage()); } switch (j) { case 0: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); break; case 1: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); break; case 2: cell.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); cell.setText(String.valueOf(dtm.getValueAt(i, j))); qty += Integer.parseInt(String.valueOf(dtm.getValueAt(i, j))); break; } } } XWPFTableRow finalRow = productDetails.createRow(); XWPFTableCell fc0 = finalRow.getCell(0); fc0.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(1000)); XWPFTableCell fc3 = finalRow.getCell(1); fc3.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(8000)); XWPFParagraph fp1 = fc3.addParagraph(); XWPFRun fRun1 = fp1.createRun(); fRun1.setBold(true); fRun1.setText("TOTAL"); XWPFTableCell fc4 = finalRow.getCell(2); fc4.getCTTc().addNewTcPr().addNewTcW().setW(BigInteger.valueOf(2000)); XWPFParagraph fp2 = fc4.addParagraph(); XWPFRun fRun2 = fp2.createRun(); fRun2.setBold(true); fRun2.setText(String.valueOf(qty)); ctTc = fc0.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); //border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); ctTc = fc3.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); //border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); ctTc = fc4.getCTTc(); tcPr = ctTc.getTcPr(); border = tcPr.addNewTcBorders(); border.addNewBottom().setVal(STBorder.SINGLE); border.addNewRight().setVal(STBorder.SINGLE); border.addNewLeft().setVal(STBorder.SINGLE); border.addNewTop().setVal(STBorder.SINGLE); XWPFParagraph netPMethod = document.createParagraph(); XWPFRun pMethodRun = netPMethod.createRun(); pMethodRun.addBreak(); pMethodRun.addBreak(); pMethodRun.setItalic(true); pMethodRun.setFontSize(10); pMethodRun.setText("NB. - Goods sold to the above buyer is in " + paymentType + "."); try { File f = new File(filePath); if (!f.exists()) { f.mkdir(); } FileOutputStream outputStream = new FileOutputStream(filePath + File.separator + "Challan" + invoiceNote.replace("/", "_") + copyType.replace("/", "_") + ".docx"); document.write(outputStream); outputStream.close(); new InvoiceNoteManager().setProperty(); if (printCommand) printDocument(); } catch (Exception e) { System.err.println(e.getMessage()); } return true; }
From source file:biz.webgate.dominoext.poi.component.kernel.DocumentProcessor.java
License:Apache License
public static void setDocCellValue(XWPFTable dxTable, int nRow, int nCol, Object objValue, int maxRow, boolean isHeader) { try {// w ww .java 2s . c om if (dxTable.getRow(nRow) == null) { // DEFINIE MAX VALUE! while (dxTable.getRow(nRow) == null && dxTable.getRows().size() < maxRow) { dxTable.createRow(); // rowHasChanged = true; } } if (dxTable.getRow(nRow) != null) { if (dxTable.getRow(nRow).getCell(nCol) == null) { // CHECK MAX COL while (dxTable.getRow(nRow).getCell(nCol) == null && dxTable.getRow(nRow).getTableCells().size() < 50) { dxTable.getRow(nRow).addNewTableCell(); } } // dxTable.getRow(nRow).getCell(nCol).setText("" + // objValue.toString()); for (XWPFParagraph paraCurrent : dxTable.getRow(nRow).getCell(nCol).getParagraphs()) { if (paraCurrent.getRuns().size() == 0) { XWPFRun runCurrent = paraCurrent.createRun(); if (isHeader) runCurrent.setBold(true); runCurrent.setText("" + objValue.toString()); } else { for (XWPFRun runCurrent : paraCurrent.getRuns()) { if (isHeader) runCurrent.setBold(true); runCurrent.setText("" + objValue.toString()); } } } } else { System.out.println("Still null: " + nRow + " MaxRow = " + maxRow); } } catch (Exception e) { e.printStackTrace(); } }
From source file:ch.admin.isb.hermes5.business.word.TranslationWordAdapter.java
License:Apache License
public byte[] write(List<TranslateableText> texts, String lang) { XWPFDocument document = new XWPFDocument(); // insert text into first row XWPFTable table = document.createTable(); table.setCellMargins(0, 100, 0, 100); XWPFTableRow rowOne = table.getRow(0); TranslateableText first = texts.get(0); rowOne.getCell(0).setText(first.getElementIdentifier() + "/ " + first.getTextIdentifier()); rowOne.addNewTableCell().setText(getText(first, lang)); if (isDirty(first, lang)) { rowOne.getCell(1).setColor("FFFF99"); }/*from w ww .j a v a2 s. c o m*/ // add more rows and insert text if (texts.size() > 1) { for (int c = 1; c < texts.size(); c++) { TranslateableText text = texts.get(c); XWPFTableRow row = table.createRow(); row.getCell(0).setText(text.getElementIdentifier() + "/ " + text.getTextIdentifier()); row.getCell(1).setText(getText(text, lang)); if (isDirty(text, lang)) { row.getCell(1).setColor("FFFF99"); } } } try { ByteArrayOutputStream outStream = new ByteArrayOutputStream(); document.write(outStream); return outStream.toByteArray(); } catch (IOException e) { throw new RuntimeException(e); } }
From source file:cn.afterturn.easypoi.word.parse.excel.ExcelEntityParse.java
License:Apache License
/** * List??Cells//from ww w .java 2s. c om * * @param index * @param cellNum * @param obj ? * @param excelParams ?? * @param table ? * @param rowHeight * @throws Exception */ public void createListCells(int index, int cellNum, Object obj, List<ExcelExportEntity> excelParams, XWPFTable table, short rowHeight) throws Exception { ExcelExportEntity entity; XWPFTableRow row; if (table.getRow(index) == null) { row = table.createRow(); row.setHeight(rowHeight); } else { row = table.getRow(index); } for (int k = 0, paramSize = excelParams.size(); k < paramSize; k++) { entity = excelParams.get(k); Object value = getCellValue(entity, obj); if (entity.getType() == 1) { setCellValue(row, value, cellNum++); } } }
From source file:com.bxf.hradmin.testgen.service.impl.DocxTestGenerator.java
License:Open Source License
@Override public void generate(String versionOid, List<QuestionSnapshot> questions) { File docxFile = new File(getRootPath(versionOid), "T-Java.docx"); try (BufferedOutputStream bos = new BufferedOutputStream(new FileOutputStream(docxFile)); InputStream is = TestGenerator.class.getResourceAsStream("/template/questions.docx")) { XWPFDocument doc = new XWPFDocument(is); replaceWordHolder(doc);//from w w w. j a v a 2s . co m XWPFTable table = doc.getTables().get(0); for (QuestionSnapshot question : questions) { XWPFTableRow row = table.createRow(); writeQuestionNo(question.getQuestionNo(), row); writeQuestion(question, row); } // template row table.removeRow(0); // setBorders(table); // doc.write(bos); File[] unzipFiles = { docxFile, new File(getRootPath(versionOid), "A-Java.txt") }; File destination = new File(getRootPath(versionOid), "T-Java-docx.zip"); ZipUtils.zip(destination, true, null, unzipFiles); } catch (IOException e) { log.error(e.getMessage(), e); throw new TestGenException(e.getMessage(), ModuleInfo.TestGenMgr); } }
From source file:com.crimelab.service.PolygraphServiceImpl.java
@Override public XWPFDocument create(Polygraph polygraph, HttpSession session) { XWPFDocument document = null;/* w ww .j av a2 s . c o m*/ //Insert into dbase // polygraphDAO.polygraphInfo(polygraph); try { //Blank Document InputStream inpDocx = session.getServletContext() .getResourceAsStream("/WEB-INF/templates/Polygraph.docx"); document = new XWPFDocument(inpDocx); //create Paragraph XWPFParagraph subjectNo = document.createParagraph(); XWPFRun r1 = subjectNo.createRun(); r1.setText("POLYGRAPH SUBJECT NO: " + polygraph.getSubjectNo()); subjectNo.setAlignment(ParagraphAlignment.CENTER); r1.setBold(true); ; //create table XWPFTable table = document.createTable(); //width CTTbl tableFix = table.getCTTbl(); CTTblPr pr = tableFix.getTblPr(); CTTblWidth tblW = pr.getTblW(); tblW.setW(BigInteger.valueOf(4800)); tblW.setType(STTblWidth.PCT); pr.setTblW(tblW); tableFix.setTblPr(pr); //create first row XWPFTableRow tableRowOne = table.getRow(0); XWPFTableCell headerCell = tableRowOne.getCell(0); XWPFParagraph headerParagraph = headerCell.getParagraphs().get(0); XWPFRun hRun = headerParagraph.createRun(); headerCell.setColor("CDCDB4"); hRun.setText("PERSONAL INFORMATION"); tableRowOne.addNewTableCell().setText(null); headerParagraph.setAlignment(ParagraphAlignment.CENTER); XWPFTableCell photoHeaderCell = tableRowOne.getCell(1); XWPFParagraph photoHeaderParagraph = photoHeaderCell.getParagraphs().get(0); XWPFRun pRun = photoHeaderParagraph.createRun(); photoHeaderCell.setColor("CDCDB4"); pRun.setText("PHOTO"); photoHeaderParagraph.setAlignment(ParagraphAlignment.CENTER); XWPFTableRow tableRowTwo = table.createRow(); XWPFTableCell cell = tableRowTwo.getCell(0); XWPFParagraph personalInfo = cell.getParagraphs().get(0); XWPFRun r2 = personalInfo.createRun(); r2.setText("Name"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getName()); r2.addBreak(); r2.setText("Gender"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getGender()); r2.addBreak(); r2.setText("Age"); r2.addTab(); r2.addTab(); r2.setText(": " + polygraph.getAge()); r2.addBreak(); r2.setText("Date of Birth"); r2.addTab(); r2.setText(": " + polygraph.getBirthdate()); r2.addBreak(); r2.setText("Civil Status"); r2.addTab(); r2.setText(": " + polygraph.getCivilStatus()); r2.addBreak(); r2.setText("ID Presented"); r2.addTab(); r2.setText(": " + polygraph.getIdPresented()); r2.addBreak(); r2.setText("Address"); r2.addTab(); r2.setText(": " + polygraph.getAddress()); //Adding the picture XWPFTableCell pictureCell = tableRowTwo.getCell(1); XWPFParagraph pictureHolder = pictureCell.getParagraphs().get(0); XWPFRun pictureRun = pictureHolder.createRun(); FileInputStream getPhoto = new FileInputStream(polygraph.getPhotoLocation()); FileInputStream getImage = new FileInputStream(polygraph.getPhotoLocation()); ImageInputStream imageInput = ImageIO.createImageInputStream(getPhoto); BufferedImage bi = ImageIO.read(imageInput); pictureHolder.setAlignment(ParagraphAlignment.RIGHT); pictureRun.addPicture(getImage, XWPFDocument.PICTURE_TYPE_JPEG, null, Units.toEMU(120), Units.toEMU(120)); XWPFParagraph spacing = document.createParagraph(); XWPFRun spacingRun = spacing.createRun(); //create table XWPFTable otherTable = document.createTable(); //width CTTbl tableFixTwo = otherTable.getCTTbl(); CTTblPr prTwo = tableFixTwo.getTblPr(); CTTblWidth tblWTwo = prTwo.getTblW(); tblWTwo.setW(BigInteger.valueOf(4800)); tblWTwo.setType(STTblWidth.PCT); prTwo.setTblW(tblWTwo); tableFixTwo.setTblPr(prTwo); XWPFTableRow examInfoHeader = otherTable.createRow(); XWPFTableCell cellInfo = examInfoHeader.getCell(0); XWPFParagraph examInfo = cellInfo.getParagraphs().get(0); XWPFRun r3 = examInfo.createRun(); cellInfo.setColor("CDCDB4"); r3.setText("EXAM INFORMATION"); examInfo.setAlignment(ParagraphAlignment.CENTER); XWPFTableRow examInfoRow = otherTable.createRow(); XWPFTableCell cellRowInfo = examInfoRow.getCell(0); XWPFParagraph examInfoRowP = cellRowInfo.getParagraphs().get(0); XWPFRun examRun = examInfoRowP.createRun(); examRun.setText("Case Number"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getCaseNo()); examRun.addBreak(); examRun.setText("Requesting Party"); examRun.addTab(); examRun.setText(": " + polygraph.getRequestingParty()); examRun.addBreak(); examRun.setText("Time/Date Received"); examRun.addTab(); examRun.setText(": " + polygraph.getTimeDateReceived()); examRun.addBreak(); examRun.setText("Nature of Case"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getNatureOfCase()); examRun.addBreak(); examRun.setText("Exam Location"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getExamLocation()); examRun.addBreak(); examRun.setText("Exam Date"); examRun.addTab(); examRun.addTab(); examRun.setText(": " + polygraph.getExamDate()); otherTable.removeRow(0); XWPFParagraph purposeOfExamination = document.createParagraph(); XWPFRun r4 = purposeOfExamination.createRun(); r4.setUnderline(UnderlinePatterns.SINGLE); r4.addBreak(); r4.setText("SECTION 1: PURPOSE OF EXAMINATION"); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); r4.addTab(); XWPFParagraph purposeOfExaminationContents = document.createParagraph(); XWPFRun r4Contents = purposeOfExaminationContents.createRun(); r4Contents.setText(polygraph.getPurpose()); XWPFParagraph preTestInterview = document.createParagraph(); XWPFRun r5 = preTestInterview.createRun(); r5.setUnderline(UnderlinePatterns.SINGLE); r5.setText("SECTION 2: PRE-TEST INTERVIEW"); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); r5.addTab(); XWPFParagraph preTestInterviewContents = document.createParagraph(); XWPFRun r5Contents = preTestInterviewContents.createRun(); r5Contents.setText(polygraph.getPreTest()); XWPFParagraph inTestPhase = document.createParagraph(); XWPFRun r6 = inTestPhase.createRun(); r6.setUnderline(UnderlinePatterns.SINGLE); r6.setText("SECTION 3: IN-TEST PHASE"); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); r6.addTab(); XWPFParagraph inTestPhaseContents = document.createParagraph(); XWPFRun r6Contents = inTestPhaseContents.createRun(); r6Contents.setText(polygraph.getInTest()); XWPFParagraph result = document.createParagraph(); XWPFRun r7 = result.createRun(); r7.setUnderline(UnderlinePatterns.SINGLE); r7.setText("SECTION 4: RESULT"); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); r7.addTab(); XWPFParagraph resultContents = document.createParagraph(); XWPFRun r7Contents = resultContents.createRun(); r7Contents.setText(polygraph.getResult()); XWPFParagraph postTestInterview = document.createParagraph(); XWPFRun r8 = postTestInterview.createRun(); r8.setUnderline(UnderlinePatterns.SINGLE); r8.setText("SECTION 5: POST-TEST INTERVIEW"); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); r8.addTab(); XWPFParagraph postTestInterviewContents = document.createParagraph(); XWPFRun r8Contents = postTestInterviewContents.createRun(); r8Contents.setText(polygraph.getPostTest()); XWPFParagraph remarks = document.createParagraph(); XWPFRun r9 = remarks.createRun(); r9.setUnderline(UnderlinePatterns.SINGLE); r9.setText("REMARKS:"); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); r9.addTab(); XWPFParagraph remarksContents = document.createParagraph(); XWPFRun r9Contents = remarksContents.createRun(); r9Contents.setText(polygraph.getRemarks()); XWPFParagraph timeDateCompleted = document.createParagraph(); XWPFRun r10 = timeDateCompleted.createRun(); r10.setUnderline(UnderlinePatterns.SINGLE); r10.setText("TIME AND DATE COMPLETED:"); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); r10.addTab(); XWPFParagraph timeDateCompletedContents = document.createParagraph(); XWPFRun r10Contents = timeDateCompletedContents.createRun(); r10Contents.setText(polygraph.getTimeDateCompleted()); XWPFParagraph examinedBy = document.createParagraph(); XWPFRun r11 = examinedBy.createRun(); r11.setUnderline(UnderlinePatterns.SINGLE); r11.setText("EXAMINED BY:"); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); r11.addTab(); XWPFParagraph examinedByContents = document.createParagraph(); XWPFRun r11Contents = examinedByContents.createRun(); r11Contents.setText(polygraph.getExaminerName()); r11Contents.addBreak(); r11Contents.setText(polygraph.getExaminerRank()); r11Contents.addBreak(); r11Contents.setText(polygraph.getExaminerPosition()); XWPFParagraph approvedBy = document.createParagraph(); XWPFRun r12 = approvedBy.createRun(); r12.setUnderline(UnderlinePatterns.SINGLE); r12.setText("APPROVED BY:"); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); r12.addTab(); XWPFParagraph approvedByContents = document.createParagraph(); XWPFRun r12Contents = approvedByContents.createRun(); // r12Contents.setText(polygraph.getApprovedName()); // r12Contents.addBreak(); // r12Contents.setText(polygraph.getApprovedRank()); // r12Contents.addBreak(); // r12Contents.setText(polygraph.getApprovedPosition()); // r12Contents.addBreak(); XWPFParagraph notedBy = document.createParagraph(); XWPFRun r13 = notedBy.createRun(); r13.setUnderline(UnderlinePatterns.SINGLE); r13.setText("NOTED BY:"); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); r13.addTab(); XWPFParagraph notedByContents = document.createParagraph(); XWPFRun r13Contents = notedByContents.createRun(); r13Contents.setText(polygraph.getNotedName()); r13Contents.addBreak(); r13Contents.setText(polygraph.getNotedRank()); r13Contents.addBreak(); r13Contents.setText(polygraph.getNotedPosition()); r13Contents.addBreak(); table.setInsideVBorder(XWPFTable.XWPFBorderType.NIL, 0, 0, "white"); document.getXWPFDocument(); } catch (Exception e) { e.printStackTrace(); } return document; }
From source file:com.dexter.fms.mbean.FleetMBean.java
License:Open Source License
@SuppressWarnings("unchecked") public void generateWorkOrderWordDoc(long id) { try {/*from w ww .ja va 2 s .co m*/ setSelectedWorkOrder(null); for (WorkOrder w : getRountineWorkOrders()) { if (w.getId().longValue() == id) { setSelectedWorkOrder(w); break; } } if (getSelectedWorkOrder() != null) { GeneralDAO gDAO = new GeneralDAO(); FacesContext context = FacesContext.getCurrentInstance(); XWPFDocument document = new XWPFDocument(); XWPFParagraph paragraphOne = document.createParagraph(); paragraphOne.setAlignment(ParagraphAlignment.LEFT); /*paragraphOne.setBorderBottom(Borders.SINGLE); paragraphOne.setBorderTop(Borders.SINGLE); paragraphOne.setBorderRight(Borders.SINGLE); paragraphOne.setBorderLeft(Borders.SINGLE); paragraphOne.setBorderBetween(Borders.SINGLE); */ XWPFRun paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Work Order No. - " + getSelectedWorkOrder().getWorkOrderNumber()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Type - " + getSelectedWorkOrder().getWorkOrderType()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText( "Prepared by - " + getSelectedWorkOrder().getCreatedBy().getPersonel().getFirstname() + " " + getSelectedWorkOrder().getCreatedBy().getPersonel().getLastname()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Prepared on - " + getSelectedWorkOrder().getCrt_dt()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne .setText("Description - " + getSelectedWorkOrder().getSummaryDetailsOfWorkOrder()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Status - " + getSelectedWorkOrder().getStatus()); paragraphOneRunOne.addBreak(); if ((getSelectedWorkOrder().getStatus().equalsIgnoreCase("IN-PROGRESS") || getSelectedWorkOrder().getStatus().equalsIgnoreCase("COMPLETED"))) { paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); if (getSelectedWorkOrder().getVendor() != null) paragraphOneRunOne.setText("Vendor - " + getSelectedWorkOrder().getVendor().getName()); else paragraphOneRunOne.setText("Vendor - N/A"); paragraphOneRunOne.addBreak(); } XWPFParagraph paragraph2 = document.createParagraph(); paragraph2.setAlignment(ParagraphAlignment.CENTER); XWPFRun paragraph2Run = paragraph2.createRun(); paragraph2Run.setBold(true); paragraph2Run.setItalic(true); paragraph2Run.setUnderline(UnderlinePatterns.DOUBLE); paragraph2Run.setText("Vehicles"); paragraph2Run.addBreak(); double totalCost = 0; for (WorkOrderVehicle v : getSelectedWorkOrder().getVehicles()) { VehicleRoutineMaintenance vrm = null; if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("IN-PROGRESS") || getSelectedWorkOrder().getStatus().equalsIgnoreCase("COMPLETED")) { Hashtable<String, Object> params = new Hashtable<String, Object>(); params.put("vehicle", v.getVehicle()); params.put("workOrder", getSelectedWorkOrder()); Object vrmObj = gDAO.search("VehicleRoutineMaintenance", params); if (vrmObj != null) { Vector<VehicleRoutineMaintenance> list = (Vector<VehicleRoutineMaintenance>) vrmObj; vrm = list.get(0); } } XWPFParagraph paragraph = document.createParagraph(); paragraph.setAlignment(ParagraphAlignment.LEFT); XWPFRun paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Registration Number: " + v.getVehicle().getRegistrationNo()); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Model: " + v.getVehicle().getModel().getName() + "[" + v.getVehicle().getModel().getYear() + "]"); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Work Required: " + v.getDetailsOfWork()); paragraphRun.addBreak(); if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("IN-PROGRESS") && vrm != null) { paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Start Date: " + vrm.getStart_dt()); paragraphRun.addBreak(); } else if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("COMPLETED") && vrm != null) { paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Start Date: " + vrm.getStart_dt()); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Close Date: " + vrm.getClose_dt()); paragraphRun.addBreak(); } paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("NEW")) paragraphRun.setText("Vendor Cost: "); else if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("IN-PROGRESS")) { if (vrm != null) { paragraphRun.setText("Vendor Cost: " + NumberFormat.getInstance().format(vrm.getInitial_amount().doubleValue())); totalCost += vrm.getInitial_amount().doubleValue(); } else paragraphRun.setText("Vendor Cost: "); } else if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("COMPLETED")) { if (vrm != null) { paragraphRun.setText("Vendor Cost: " + NumberFormat.getInstance().format(vrm.getClosed_amount().doubleValue())); totalCost += vrm.getClosed_amount().doubleValue(); } else paragraphRun.setText("Vendor Cost: "); } paragraphRun.addBreak(); XWPFTable table = paragraph.getDocument().createTable(); XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Item", true); addHeaderCell(tableRowOne, "Type", false); addHeaderCell(tableRowOne, "Action", false); addHeaderCell(tableRowOne, "Count", false); if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("NEW")) { addHeaderCell(tableRowOne, "Vendor Cost", false); addHeaderCell(tableRowOne, "Comment", false); } for (WorkOrderItem itm : v.getItems()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(itm.getItem().getName()); tableRow.getCell(1).setText(itm.getItem().getType().getName()); tableRow.getCell(2).setText(itm.getAction()); tableRow.getCell(3).setText(String.valueOf(itm.getCount())); if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("NEW")) { tableRow.getCell(4).setText(""); tableRow.getCell(5).setText(""); } } } gDAO.destroy(); if (getSelectedWorkOrder().getStatus().equalsIgnoreCase("IN-PROGRESS") || getSelectedWorkOrder().getStatus().equalsIgnoreCase("COMPLETED")) { XWPFParagraph paragraph = document.createParagraph(); paragraph.setAlignment(ParagraphAlignment.LEFT); XWPFRun paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Total Cost: " + NumberFormat.getInstance().format(totalCost)); } ByteArrayOutputStream baos = new ByteArrayOutputStream(); document.write(baos); String fileName = getSelectedWorkOrder().getWorkOrderNumber() + ".docx"; writeFileToResponse(context.getExternalContext(), baos, fileName, "application/vnd.openxmlformats-officedocument.wordprocessingml.document"); context.responseComplete(); } else { msg = new FacesMessage(FacesMessage.SEVERITY_ERROR, "Failed: ", "No work order selected!"); FacesContext.getCurrentInstance().addMessage(null, msg); } } catch (Exception ex) { ex.printStackTrace(); msg = new FacesMessage(FacesMessage.SEVERITY_ERROR, "ERROR: ", ex.getMessage()); FacesContext.getCurrentInstance().addMessage(null, msg); } }
From source file:com.dexter.fms.mbean.FleetMBean.java
License:Open Source License
private byte[] generateWorkOrderWordDoc(WorkOrder workder, Vendor vendor) { byte[] data = null; try {//from w w w. j ava2 s . c o m if (workder != null) { GeneralDAO gDAO = new GeneralDAO(); XWPFDocument document = new XWPFDocument(); XWPFParagraph paragraphOne = document.createParagraph(); paragraphOne.setAlignment(ParagraphAlignment.LEFT); /*paragraphOne.setBorderBottom(Borders.SINGLE); paragraphOne.setBorderTop(Borders.SINGLE); paragraphOne.setBorderRight(Borders.SINGLE); paragraphOne.setBorderLeft(Borders.SINGLE); paragraphOne.setBorderBetween(Borders.SINGLE); */ XWPFRun paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Work Order No. - " + workder.getWorkOrderNumber()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Type - " + workder.getWorkOrderType()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Prepared by - " + workder.getCreatedBy().getPersonel().getFirstname() + " " + workder.getCreatedBy().getPersonel().getLastname()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Prepared on - " + workder.getCrt_dt()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Description - " + workder.getSummaryDetailsOfWorkOrder()); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Status - BIDDING"); paragraphOneRunOne.addBreak(); paragraphOneRunOne = paragraphOne.createRun(); paragraphOneRunOne.setBold(true); paragraphOneRunOne.setItalic(true); paragraphOneRunOne.setText("Vendor - " + vendor.getName()); paragraphOneRunOne.addBreak(); XWPFParagraph paragraph2 = document.createParagraph(); paragraph2.setAlignment(ParagraphAlignment.CENTER); XWPFRun paragraph2Run = paragraph2.createRun(); paragraph2Run.setBold(true); paragraph2Run.setItalic(true); paragraph2Run.setUnderline(UnderlinePatterns.DOUBLE); paragraph2Run.setText("Vehicles"); paragraph2Run.addBreak(); for (WorkOrderVehicle v : workder.getVehicles()) { XWPFParagraph paragraph = document.createParagraph(); paragraph.setAlignment(ParagraphAlignment.LEFT); XWPFRun paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Registration Number: " + v.getVehicle().getRegistrationNo()); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Model: " + v.getVehicle().getModel().getName() + "[" + v.getVehicle().getModel().getYear() + "]"); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Work Required: " + v.getDetailsOfWork()); paragraphRun.addBreak(); paragraphRun = paragraph.createRun(); paragraphRun.setBold(true); paragraphRun.setItalic(true); paragraphRun.setText("Vendor Cost: <please fill your cost here>"); paragraphRun.addBreak(); XWPFTable table = paragraph.getDocument().createTable(); XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Item", true); addHeaderCell(tableRowOne, "Type", false); addHeaderCell(tableRowOne, "Action", false); addHeaderCell(tableRowOne, "Count", false); addHeaderCell(tableRowOne, "Vendor Cost", false); addHeaderCell(tableRowOne, "Comment", false); for (WorkOrderItem itm : v.getItems()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(itm.getItem().getName()); tableRow.getCell(1).setText(itm.getItem().getType().getName()); tableRow.getCell(2).setText(itm.getAction()); tableRow.getCell(3).setText(String.valueOf(itm.getCount())); tableRow.getCell(4).setText(""); tableRow.getCell(5).setText(""); } } gDAO.destroy(); ByteArrayOutputStream baos = new ByteArrayOutputStream(); document.write(baos); data = baos.toByteArray(); } } catch (Exception ex) { ex.printStackTrace(); } return data; }
From source file:com.dexter.fms.mbean.ReportsMBean.java
private void exportWordTable(int type, XWPFDocument document) { XWPFTable table = document.createTable(); switch (type) { case 1: // all users report {//from w w w .j a v a 2s. co m XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "User name", true); addHeaderCell(tableRowOne, "Full name", false); addHeaderCell(tableRowOne, "Email", false); addHeaderCell(tableRowOne, "Department", false); addHeaderCell(tableRowOne, "Region", false); addHeaderCell(tableRowOne, "Phone", false); addHeaderCell(tableRowOne, "Position", false); if (getAllUsers() != null) { for (PartnerUser e : getAllUsers()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getUsername()); tableRow.getCell(1) .setText(e.getPersonel().getFirstname() + " " + e.getPersonel().getLastname()); tableRow.getCell(2).setText(e.getPersonel().getEmail()); tableRow.getCell(3) .setText((e.getPersonel().getDepartment() != null) ? e.getPersonel().getDepartment().getName() : "N/A"); tableRow.getCell(4).setText( (e.getPersonel().getRegion() != null) ? e.getPersonel().getRegion().getName() : "N/A"); tableRow.getCell(5).setText(e.getPersonel().getPhone()); tableRow.getCell(6).setText(e.getPersonel().getPosition()); } } break; } case 2: // due driver's license { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Full Name", true); addHeaderCell(tableRowOne, "Dept", false); addHeaderCell(tableRowOne, "Region", false); addHeaderCell(tableRowOne, "Phone", false); addHeaderCell(tableRowOne, "Position", false); addHeaderCell(tableRowOne, "License Due Date", false); if (getDueDriversLic() != null) { for (DriverLicense e : getDueDriversLic()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getDriver().getPersonel().getFirstname() + " " + e.getDriver().getPersonel().getLastname()); tableRow.getCell(1) .setText(e.getDriver().getPersonel().getDepartment() != null ? e.getDriver().getPersonel().getDepartment().getName() : "N/A"); tableRow.getCell(2) .setText(e.getDriver().getPersonel().getRegion() != null ? e.getDriver().getPersonel().getRegion().getName() : "N/A"); tableRow.getCell(3).setText(e.getDriver().getPersonel().getPhone()); tableRow.getCell(4).setText(e.getDriver().getPersonel().getPosition()); tableRow.getCell(5).setText(e.getLic_end_dt().toLocaleString()); } } break; } case 3: // accidents { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Accident Date", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Driver", false); addHeaderCell(tableRowOne, "Driver Comment", false); addHeaderCell(tableRowOne, "Police Officer", false); addHeaderCell(tableRowOne, "Police Station", false); addHeaderCell(tableRowOne, "Police Comment", false); if (getVehicleAccidents() != null) { for (VehicleAccident e : getVehicleAccidents()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getAccident_dt().toLocaleString()); tableRow.getCell(2).setText(e.getAccidentDescription()); tableRow.getCell(3).setText(e.getDriver_name()); tableRow.getCell(4).setText(e.getDriverComment()); tableRow.getCell(5).setText(e.getPoliceOfficer()); tableRow.getCell(6).setText(e.getPoliceStation()); tableRow.getCell(7).setText(e.getPoliceComment()); } } break; } case 4: // vehicles by brand { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Make", true); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "Year", false); addHeaderCell(tableRowOne, "Reg No.", false); if (getVehiclesByBrand() != null) { for (Vehicle e : getVehiclesByBrand()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getModel().getMaker().getName()); tableRow.getCell(1).setText(e.getModel().getName()); tableRow.getCell(2).setText(e.getModel().getYear()); tableRow.getCell(3).setText(e.getRegistrationNo()); } } break; } case 5: // routine maintenance { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Requester", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Start Date", false); addHeaderCell(tableRowOne, "Initial Cost", false); addHeaderCell(tableRowOne, "Status", false); addHeaderCell(tableRowOne, "Close Date", false); addHeaderCell(tableRowOne, "Final Cost", false); if (getRmaints() != null) { for (VehicleRoutineMaintenance e : getRmaints()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getCreatedBy().getPersonel().getFirstname() + " " + e.getCreatedBy().getPersonel().getLastname()); tableRow.getCell(2).setText(e.getDescription()); tableRow.getCell(3).setText(e.getStart_dt().toLocaleString()); tableRow.getCell(4).setText(e.getInitial_amount().toPlainString()); tableRow.getCell(5).setText(e.getStatus()); tableRow.getCell(6).setText(e.getClose_dt().toLocaleString()); tableRow.getCell(7).setText(e.getClosed_amount().toPlainString()); } } break; } case 6: // ad hoc maintenance { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Requester", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Start Date", false); addHeaderCell(tableRowOne, "Initial Cost", false); addHeaderCell(tableRowOne, "Status", false); addHeaderCell(tableRowOne, "Close Date", false); addHeaderCell(tableRowOne, "Final Cost", false); if (getAdhocmaints() != null) { for (VehicleAdHocMaintenance e : getAdhocmaints()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getCreatedBy().getPersonel().getFirstname() + " " + e.getCreatedBy().getPersonel().getLastname()); tableRow.getCell(2).setText(e.getDescription()); tableRow.getCell(3).setText(e.getStart_dt().toLocaleString()); tableRow.getCell(4).setText(e.getInitial_cost().toPlainString()); tableRow.getCell(5).setText(e.getStatus()); tableRow.getCell(6).setText(e.getClose_dt().toLocaleString()); tableRow.getCell(7).setText(e.getClosed_cost().toPlainString()); } } break; } case 7: // active accidents { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Accident Date", false); addHeaderCell(tableRowOne, "Description", false); addHeaderCell(tableRowOne, "Driver Name", false); addHeaderCell(tableRowOne, "Driver Comment", false); addHeaderCell(tableRowOne, "Police Name", false); addHeaderCell(tableRowOne, "Station Name", false); addHeaderCell(tableRowOne, "Police Comment", false); if (getActiveAccidents() != null) { for (VehicleAccident e : getActiveAccidents()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getAccident_dt().toLocaleString()); tableRow.getCell(2).setText(e.getAccidentDescription()); tableRow.getCell(3).setText(e.getDriver_name()); tableRow.getCell(4).setText(e.getDriverComment()); tableRow.getCell(5).setText(e.getPoliceOfficer()); tableRow.getCell(6).setText(e.getPoliceStation()); tableRow.getCell(7).setText(e.getPoliceComment()); } } break; } case 8: // coporate trips { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Requester", true); addHeaderCell(tableRowOne, "Department", false); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Departure Location", false); addHeaderCell(tableRowOne, "Arrival Location", false); addHeaderCell(tableRowOne, "Departure Date and Time", false); addHeaderCell(tableRowOne, "Est. Arrival Date and Time", false); addHeaderCell(tableRowOne, "Act. Arrival Date and Time", false); addHeaderCell(tableRowOne, "Status", false); if (getCorTrips() != null) { for (CorporateTrip e : getCorTrips()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getStaff().getFirstname() + " " + e.getStaff().getLastname()); tableRow.getCell(1) .setText((e.getStaff().getDepartment() != null) ? e.getStaff().getDepartment().getName() : "N/A"); tableRow.getCell(2) .setText(e.getVehicle() != null ? e.getVehicle().getRegistrationNo() : "N/A"); tableRow.getCell(3).setText(e.getDepartureLocation()); tableRow.getCell(4).setText(e.getArrivalLocation()); tableRow.getCell(5).setText(e.getDepartureDateTime().toLocaleString()); tableRow.getCell(6).setText(e.getEstimatedArrivalDateTime().toLocaleString()); tableRow.getCell(7) .setText(e.getCompleteRequestDateTime() != null ? e.getCompleteRequestDateTime().toLocaleString() : "N/A"); tableRow.getCell(8).setText(e.getTripStatus()); } } break; } case 9: // expense report { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Type", true); addHeaderCell(tableRowOne, "Date", false); addHeaderCell(tableRowOne, "Amount", false); addHeaderCell(tableRowOne, "Detail", false); if (getExpenses() != null) { for (Expense e : getExpenses()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getType().getName()); tableRow.getCell(0).setText(e.getExpense_dt().toLocaleString()); tableRow.getCell(0).setText("" + e.getAmount()); tableRow.getCell(0).setText(e.getRemarks()); } } break; } case 10: // vehicle ages { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Make", true); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "Year", false); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Date of Purchase", false); addHeaderCell(tableRowOne, "Age (in years)", false); if (getVehiclesAges() != null) { for (Vehicle e : getVehiclesAges()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0) .setText(e.getModel().getMaker() != null ? e.getModel().getMaker().getName() : "N/A"); tableRow.getCell(1).setText(e.getModel() != null ? e.getModel().getName() : "N/A"); tableRow.getCell(2).setText(e.getModel() != null ? e.getModel().getYear() : "N/A"); tableRow.getCell(3).setText(e.getRegistrationNo()); tableRow.getCell(4) .setText(e.getPurchaseDate() != null ? e.getPurchaseDate().toLocaleString() : "N/A"); tableRow.getCell(5).setText("" + e.getAge()); } } break; } case 11: // vehicle fuelings { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Date", true); addHeaderCell(tableRowOne, "Reg No.", false); addHeaderCell(tableRowOne, "Litres", false); addHeaderCell(tableRowOne, "Amount", false); addHeaderCell(tableRowOne, "Source", false); if (getFuelings() != null) { for (VehicleFueling e : getFuelings()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getCaptured_dt().toLocaleString()); tableRow.getCell(1).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(2).setText("" + e.getLitres()); tableRow.getCell(3).setText("" + e.getAmt()); tableRow.getCell(4).setText(e.getSource()); } } break; } case 12: // due vehicle licenses { XWPFTableRow tableRowOne = table.getRow(0); addHeaderCell(tableRowOne, "Reg No.", true); addHeaderCell(tableRowOne, "Fleet", false); addHeaderCell(tableRowOne, "Make", false); addHeaderCell(tableRowOne, "Model", false); addHeaderCell(tableRowOne, "License Due Date", false); if (getDueVehicleLicenses() != null) { for (VehicleLicense e : getDueVehicleLicenses()) { XWPFTableRow tableRow = table.createRow(); tableRow.getCell(0).setText(e.getVehicle().getRegistrationNo()); tableRow.getCell(1).setText(e.getVehicle().getFleet().getName()); tableRow.getCell(2) .setText(e.getVehicle().getModel() != null ? e.getVehicle().getModel().getMaker().getName() : "N/A"); tableRow.getCell(3).setText( e.getVehicle().getModel() != null ? e.getVehicle().getModel().getName() : "N/A"); tableRow.getCell(4).setText(e.getLic_end_dt().toLocaleString()); } } break; } } }
From source file:com.foc.vaadin.gui.layouts.validationLayout.FVValidationLayout.java
License:Apache License
private void createWordTableRows() { try {/*from www . j av a 2s.c om*/ XWPFDocument document = new XWPFDocument(); XWPFTable tableOne = document.createTable(); XWPFTableRow row = null; for (int i = 0; i < 10; i++) { row = tableOne.createRow(); row.getCell(0).setText("Row Number: " + i); } FileOutputStream outStream = new FileOutputStream( "C://Users//user//Desktop//POI Word Doc Sample Table 1.docx"); document.write(outStream); outStream.close(); } catch (Exception ex) { Globals.logException(ex); } }