List of usage examples for org.apache.poi.xwpf.usermodel UnderlinePatterns DOUBLE
UnderlinePatterns DOUBLE
To view the source code for org.apache.poi.xwpf.usermodel UnderlinePatterns DOUBLE.
Click Source Link
From source file:com.dexter.fms.mbean.FleetMBean.java
License:Open Source License
@SuppressWarnings("unchecked") public void generateWorkOrderWordDoc(long id) { try {//from www. j a v a2 s. c o 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 {/* ww w . j ava2s .com*/ 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:UserInterface.SalesSpecialistWorkArea.SalesSpecialistWorkAreaJPanel.java
private void generateInvoice(SalesSpecialistWorkRequest salesRequest) { double invoiceAmount = 0; order = salesRequest.getOrder();/* ww w .ja v a 2 s . c om*/ XWPFDocument document = new XWPFDocument(); XWPFParagraph paragraph1 = document.createParagraph(); XWPFRun run1 = paragraph1.createRun(); run1.setText("Invoice Report"); run1.setBold(true); run1.setUnderline(UnderlinePatterns.DOUBLE); run1.setFontSize(30); paragraph1.setAlignment(ParagraphAlignment.CENTER); for (OrderItem orderItem : salesRequest.getOrder().getOrderItem()) { invoiceAmount = invoiceAmount + (orderItem.getQuantity() * orderItem.getDevice().getUnitPrice()); } XWPFParagraph paragraph3 = document.createParagraph(); XWPFRun run3 = paragraph3.createRun(); run3.setText("Invoice Amount : " + invoiceAmount); run3.setBold(true); run3.setUnderline(UnderlinePatterns.DOUBLE); run3.setFontSize(30); paragraph3.setAlignment(ParagraphAlignment.LEFT); XWPFParagraph paragraph2 = document.createParagraph(); XWPFRun run2 = paragraph2.createRun(); int count = 0; for (OrderItem orderItem : order.getOrderItem()) { run2.addBreak(); run2.addBreak(); count++; run2.setText("OrderItem " + count); run2.addBreak(); Device device = orderItem.getDevice(); run2.setText("Device Name : " + device.getDeviceName()); run2.addBreak(); run2.setText("Device Type : " + device.getDeviceType()); run2.addBreak(); run2.setText("Company Name : " + device.getCompanyName()); run2.addBreak(); run2.setText("Unit Price : " + device.getUnitPrice()); run2.addBreak(); run2.setText("Country of Origin : " + device.getCountryOfOrigin()); run2.addBreak(); run2.setText("Manufactured Date : " + device.getManufacuredDate()); run2.addBreak(); run2.setText("Quantity : " + orderItem.getQuantity()); run2.addBreak(); run2.setText("The unique identifiers for " + orderItem.getQuantity() + " device are listed below"); run2.addBreak(); for (String uID : orderItem.getuIDList()) { run2.setText(uID); run2.addBreak(); } } run2.setFontSize(30); paragraph2.setAlignment(ParagraphAlignment.LEFT); try { //Next 3 lines are to create a word file FileOutputStream output = new FileOutputStream("Invoice_Report.docx"); document.write(output); //XWPFWordExtractor extract = new XWPFWordExtractor(document); output.close(); Runtime.getRuntime().exec("rundll32 url.dll, FileProtocolHandler " + "C:\\Users\\Tushar\\Google Drive\\NetBeansProjects\\Word\\Invoice_Report.docx"); } catch (Exception e) { e.printStackTrace(); } }