Subversion Repositories SmartDukaan

	public static void writePurchaseInvoicesReport(List<PurchaseInvoiceModel> purchaseInvoiceModels, OutputStream outputStream) {

		SXSSFWorkbook workbook = new SXSSFWorkbook();

		// CreationHelper createHelper = workbook.getCreationHelper();

		SXSSFSheet sheet = workbook.createSheet("PurchaseInvoicesReport");

		sheet.trackAllColumnsForAutoSizing();

		Row rowHeader = sheet.createRow(0);

		Cell cellPoIdHeader = rowHeader.createCell(0);

		cellPoIdHeader.setCellValue("PoId");

		Cell cellPoDateHeader = rowHeader.createCell(1);

		cellPoDateHeader.setCellValue("PoDate");

		Cell cellGrnNoHeader = rowHeader.createCell(2);

		cellGrnNoHeader.setCellValue("GRN_No");

		Cell cellGrnDateHeader = rowHeader.createCell(3);

		cellGrnDateHeader.setCellValue("GRN_Date");

		Cell cellSupplierNameHeader = rowHeader.createCell(4);

		cellSupplierNameHeader.setCellValue("Supplier_Name");

		Cell cellSupplierEmailHeader = rowHeader.createCell(5);

		cellSupplierEmailHeader.setCellValue("Supplier_Email");

		Cell cellSupplierContactNumberHeader = rowHeader.createCell(6);

		cellSupplierContactNumberHeader.setCellValue("Supplier_Contact_Number");

		Cell cellInvoiceNumberHeader = rowHeader.createCell(7);

		cellInvoiceNumberHeader.setCellValue("Invoice_Number");

		Cell cellInvoiceDateHeader = rowHeader.createCell(8);

		cellInvoiceDateHeader.setCellValue("Invoice_Date");

		Cell cellReceivedFromHeader = rowHeader.createCell(9);

		cellReceivedFromHeader.setCellValue("Received_From");

		Cell cellItemIdHeader = rowHeader.createCell(10);

		cellItemIdHeader.setCellValue("Item_Id");

		Cell cellBrandHeader = rowHeader.createCell(11);

		cellBrandHeader.setCellValue("Brand");

		Cell cellModelNameHeader = rowHeader.createCell(12);

		cellModelNameHeader.setCellValue("Model_Name");

		Cell cellModelNumberHeader = rowHeader.createCell(13);

		cellModelNumberHeader.setCellValue("Model_Number");

		Cell cellColorHeader = rowHeader.createCell(14);

		cellColorHeader.setCellValue("Color");

		Cell cellUnitPriceHeader = rowHeader.createCell(15);

		cellUnitPriceHeader.setCellValue("Unit_Price");

		Cell cellSGSTHeader = rowHeader.createCell(16);

		cellSGSTHeader.setCellValue("SGST%");

		Cell cellSGSTAmountHeader = rowHeader.createCell(17);

		cellSGSTAmountHeader.setCellValue("SGST_Amount");

		Cell cellCGSTHeader = rowHeader.createCell(18);

		cellCGSTHeader.setCellValue("CGST%");

		Cell cellCGSTAmountHeader = rowHeader.createCell(19);

		cellCGSTAmountHeader.setCellValue("CGST_Amount");

		Cell cellIGSTHeader = rowHeader.createCell(20);

		cellIGSTHeader.setCellValue("IGST%");

		Cell cellIGSTAmountHeader = rowHeader.createCell(21);

		cellIGSTAmountHeader.setCellValue("IGST_Amount");

		Cell cellQuantityHeader = rowHeader.createCell(22);

		cellQuantityHeader.setCellValue("Quantity");

		Cell cellAmountHeader = rowHeader.createCell(23);

		cellAmountHeader.setCellValue("Amount");

		Cell cellWarehouseHeader = rowHeader.createCell(24);

		cellWarehouseHeader.setCellValue("Warehouse_Address");

		Font font = workbook.createFont();

		CellStyle cellStyle = workbook.createCellStyle();

		font.setBold(true);

		cellStyle.setAlignment(HorizontalAlignment.CENTER);

		// font.setFontHeight((short)16);

		cellStyle.setFont(font);

		for (int i = 0; i < 14; i++) {

			if (rowHeader.getCell(i) != null) {

				rowHeader.getCell(i).setCellStyle(cellStyle);

			}

		}

		for (int index = 0; index < purchaseInvoiceModels.size(); index++) {

			PurchaseInvoiceModel purchaseInvoiceModel = purchaseInvoiceModels.get(index);

			Row rowValues = sheet.createRow(index + 1);

			Cell cellPoId = rowValues.createCell(0);

			cellPoId.setCellValue(purchaseInvoiceModel.getPoId());

			Cell cellPoDate = rowValues.createCell(1);

			cellPoDate.setCellValue(String.valueOf(purchaseInvoiceModel.getPoDate()));

			Cell cellGRNNo = rowValues.createCell(2);

			cellGRNNo.setCellValue(purchaseInvoiceModel.getGrnNo());

			Cell cellGRNDate = rowValues.createCell(3);

			cellGRNDate.setCellValue(String.valueOf(purchaseInvoiceModel.getGrnDate()));

			Cell cellSupplierName = rowValues.createCell(4);

			cellSupplierName.setCellValue(purchaseInvoiceModel.getSupplierName());

			Cell cellSupplierContactEmail = rowValues.createCell(5);

			cellSupplierContactEmail.setCellValue(purchaseInvoiceModel.getSupplierContactEmail());

			Cell cellSupplierContactPhone = rowValues.createCell(6);

			cellSupplierContactPhone.setCellValue(purchaseInvoiceModel.getSupplierContactPhone());

			Cell cellInvoiceNumber = rowValues.createCell(7);

			cellInvoiceNumber.setCellValue(purchaseInvoiceModel.getInvoiceNumber());

			Cell cellInvoiceDate = rowValues.createCell(8);

			cellInvoiceDate.setCellValue(String.valueOf(purchaseInvoiceModel.getInvoiceDate()));

			Cell cellReceivedFrom = rowValues.createCell(9);

			cellReceivedFrom.setCellValue(purchaseInvoiceModel.getReceivedFrom());

			Cell cellItemId = rowValues.createCell(10);

			cellItemId.setCellValue(purchaseInvoiceModel.getItemId());

			Cell cellBrand = rowValues.createCell(11);

			cellBrand.setCellValue(purchaseInvoiceModel.getBrand());

			Cell cellModelName = rowValues.createCell(12);

			cellModelName.setCellValue(purchaseInvoiceModel.getModelName());

			Cell cellModelNumber = rowValues.createCell(13);

			cellModelNumber.setCellValue(purchaseInvoiceModel.getModelNumber());

			Cell cellColor = rowValues.createCell(14);

			cellColor.setCellValue(purchaseInvoiceModel.getColor());

			Cell cellUnitPrice = rowValues.createCell(15);

			cellUnitPrice.setCellValue(purchaseInvoiceModel.getUnitPrice());

			Cell cellSGSTPercent = rowValues.createCell(16);

			cellSGSTPercent.setCellValue(purchaseInvoiceModel.getSgstRate());

			Cell cellSGSTAmount = rowValues.createCell(17);

			cellSGSTAmount.setCellValue(purchaseInvoiceModel.getSgstAmount());

			Cell cellCGSTPercent = rowValues.createCell(18);

			cellCGSTPercent.setCellValue(purchaseInvoiceModel.getCgstRate());

			Cell cellCGSTAmount = rowValues.createCell(19);

			cellCGSTAmount.setCellValue(purchaseInvoiceModel.getCgstAmount());

			Cell cellIGSTPercent = rowValues.createCell(20);

			cellIGSTPercent.setCellValue(purchaseInvoiceModel.getIgstRate());

			Cell cellIGSTAmount = rowValues.createCell(21);

			cellIGSTAmount.setCellValue(purchaseInvoiceModel.getIgstAmount());

			Cell cellQuantity = rowValues.createCell(22);

			cellQuantity.setCellValue(purchaseInvoiceModel.getQuantity());

			Cell cellAmount = rowValues.createCell(23);

			cellAmount.setCellValue(purchaseInvoiceModel.getAmount());

			Cell cellWarehouseAddress = rowValues.createCell(24);

			cellWarehouseAddress.setCellValue(purchaseInvoiceModel.getWarehouseAddress());

		}

		for (int index = 0; index < 14; index++) {

			sheet.autoSizeColumn(index);

		}

		try {

			workbook.write(outputStream);

			workbook.close();

		} catch (IOException ioException) {

			LOGGER.error("Unable to generate excel file", ioException);

		}

	}