Subversion Repositories SmartDukaan

import com.spice.profitmandi.common.model.SchemeModel;

	    	workbook.close();

	    }catch(IOException ioException){

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

	    }

	}

	public static void writeSchemeModels(List<SchemeModel> schemeModels, OutputStream outputStream){

		SXSSFWorkbook workbook = new SXSSFWorkbook();

		//CreationHelper createHelper = workbook.getCreationHelper();

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

		sheet.trackAllColumnsForAutoSizing();

	    Row rowHeader = sheet.createRow(0);

	    Cell cellSchemeIdHeader = rowHeader.createCell(0);

		cellSchemeIdHeader.setCellValue("Scheme Id");

		Cell cellNameHeader = rowHeader.createCell(1);

		cellNameHeader.setCellValue("Name");

		Cell cellDescriptionHeader = rowHeader.createCell(2);

		cellDescriptionHeader.setCellValue("Description");

		Cell cellSchemeTypeHeader = rowHeader.createCell(3);

		cellSchemeTypeHeader.setCellValue("Scheme Type");

		Cell cellAmountTypeHeader = rowHeader.createCell(4);

		cellAmountTypeHeader.setCellValue("Amount Type");

		Cell cellAmountHeader = rowHeader.createCell(5);

		cellAmountHeader.setCellValue("Amount");

		Cell cellStartDateTimeHeader = rowHeader.createCell(6);

		cellStartDateTimeHeader.setCellValue("Start Date Time");

		Cell cellEndDateTimeHeader = rowHeader.createCell(7);

		cellEndDateTimeHeader.setCellValue("End Date Time");

		Cell cellCreatedAtHeader = rowHeader.createCell(8);

		cellCreatedAtHeader.setCellValue("Created At");

		Cell cellActiveHeader = rowHeader.createCell(9);

		cellActiveHeader.setCellValue("Active");

		Cell cellExpireHeader = rowHeader.createCell(10);

		cellExpireHeader.setCellValue("Expire");

		Cell cellCreatedByHeader = rowHeader.createCell(11);

		cellCreatedByHeader.setCellValue("Created By");

		Cell cellItemIdsHeader = rowHeader.createCell(12);

		cellItemIdsHeader.setCellValue("Item Ids");

		Cell cellRetailerIdsHeader = rowHeader.createCell(13);

		cellRetailerIdsHeader.setCellValue("Retailer Ids");

		//Row rowQuantityRateValue = sheet.createRow(1);

		/*for(int index = 6; index < 18; index = index + 3){

			Cell cellQuantityHeader = rowQuantityRateValue.createCell(index);

			cellQuantityHeader.setCellValue("Quantity");

			Cell cellRateHeader = rowQuantityRateValue.createCell(index + 1);

			cellRateHeader.setCellValue("Rate");

			Cell cellValueHeader = rowQuantityRateValue.createCell(index + 2);

			cellValueHeader.setCellValue("Value");

			sheet.addMergedRegion(new CellRangeAddress(0, 0, index, index + 2));

		}*/

		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 < schemeModels.size(); index++){

			SchemeModel schemeModel = schemeModels.get(index);

			//ItemCompleteLedgerModel itemCompleteLedgerModel = itemCompleteLedgerModels.get(index);

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

	    	Cell cellSchemeId = rowValues.createCell(0);

			cellSchemeId.setCellValue(schemeModel.getSchemeId());

			Cell cellName = rowValues.createCell(1);

			cellName.setCellValue(schemeModel.getName());

			Cell cellDescription = rowValues.createCell(2);

			cellDescription.setCellValue(schemeModel.getDescription());

			Cell cellSchemeType = rowValues.createCell(3);

			cellSchemeType.setCellValue(schemeModel.getSchemeType());

			Cell cellAmountType = rowValues.createCell(4);

			cellAmountType.setCellValue(schemeModel.getAmountType());

			Cell cellAmount = rowValues.createCell(5);

			cellAmount.setCellValue(schemeModel.getAmount());

			Cell cellStartDateTime = rowValues.createCell(6);

			cellStartDateTime.setCellValue(schemeModel.getStartDateTime());

			Cell cellEndDateTime = rowValues.createCell(7);

			cellEndDateTime.setCellValue(schemeModel.getEndDateTime());

			Cell cellCreatedAt = rowValues.createCell(8);

			cellCreatedAt.setCellValue(schemeModel.getCreateTimestamp());

			Cell cellActive = rowValues.createCell(9);

			if(schemeModel.getActiveTimestamp() !=null){

				cellActive.setCellValue(schemeModel.getActiveTimestamp());

			}else{

				cellActive.setCellValue("False");

			}

			Cell cellExpire = rowValues.createCell(10);

			if(schemeModel.getExpireTimestamp() != null){

				cellExpire.setCellValue(schemeModel.getExpireTimestamp());

			}else{

				cellExpire.setCellValue("False");

			}

			Cell cellCreatedBy = rowValues.createCell(11);

			cellCreatedBy.setCellValue(schemeModel.getCreatedBy());

			Cell cellItemIds = rowValues.createCell(12);

			cellItemIds.setCellValue(schemeModel.getItemIdsString());

			Cell cellRetailerIds = rowValues.createCell(13);

			cellRetailerIds.setCellValue(schemeModel.getRetailerIdsString());

			int maxHeight = Math.max(schemeModel.getItemIds().size(), schemeModel.getRetailerIds().size());

			if(maxHeight > 1){

				rowValues.setHeight((short)(maxHeight * 240));

			}

	    }

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

			sheet.autoSizeColumn(index);

		}

	    try{

			workbook.write(outputStream);