WebSVN – SmartDukaan – Diff – /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java

 package com.spice.profitmandi.common.util;
 import java.io.IOException;
 import java.io.InputStream;
 import java.io.OutputStream;
+import java.time.LocalDate;
 import java.time.LocalDateTime;
+import java.time.LocalTime;
 import java.time.ZoneId;
 import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.Date;
 import java.util.LinkedHashMap;
 import java.util.List;
 import java.util.Map;
 import java.util.Set;
 import com.spice.profitmandi.common.model.PartnerTargetModel;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
 import com.spice.profitmandi.common.model.SchemeModel;
 import com.spice.profitmandi.common.model.TagListingModel;
+import in.shop2020.model.v1.order.WalletReferenceType;
 public class ExcelUtils {
 	private static final String TAG_ID = "Tag Id";
 	private static final String TAG_LABEL = "Tag Label";
 	private static final String ITEM_ID = "Item Id";
 	private static final String BRAND = "Brand";
 	private static final String FOFO_ID = "fofoId";
 	private static final String STORE_NAME = "storeName";
 	private static final String EMAIL = "email";
 	private static final String TARGET_VALUE = "targetValue";
+	private static final List<WalletReferenceType> BULK_WALLET_REFERENCES = Arrays.asList(
+			WalletReferenceType.BRAND_FEE, WalletReferenceType.FESTIVE_OFFER, WalletReferenceType.GOODWILL_GESTURE,
+			WalletReferenceType.EOL, WalletReferenceType.ACTIVATION_SCHEME, WalletReferenceType.BRAND_PAYOUT,
+			WalletReferenceType.SALES_MARKETING_SUPPORT, WalletReferenceType.INVESTMENT_PAYOUT,
+			WalletReferenceType.CATEGORY_SPL_PAYOUT, WalletReferenceType.REFERRAL_INCENTIVES
+	);
 	private static final Logger LOGGER = LogManager.getLogger(ExcelUtils.class);
 	public static void main(String[] args) throws Throwable {
 		// List<Integer> intervals = Arrays.asList(5, 10, 15, 20, 25);
 		// writeInventoryItemAgingModels(inventoryItemAgingModels, intervals);
 		sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
 		sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
 		sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
 		sheet.addMergedRegion(new CellRangeAddress(0, 1, 4, 4));
 		sheet.addMergedRegion(new CellRangeAddress(0, 1, 5, 5));
 		int rowIndex = 0;
 		Row rowHeader = sheet.createRow(rowIndex++);
 		Row rowPriceQuantity = sheet.createRow(rowIndex++);
-		int i=0;
+		int i = 0;
-		if(showPartner) {
+		if (showPartner) {
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 6, 6));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 7, 7));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 8, 8));
+		}
 		sheet.trackAllColumnsForAutoSizing();
-		if(showPartner) {
+		if (showPartner) {
 			Cell cellFofoIdHeader = rowHeader.createCell(i++);
 			cellFofoIdHeader.setCellValue("Partner Id");
 			Cell cellStoreCodeHeader = rowHeader.createCell(i++);
 			cellStoreCodeHeader.setCellValue("Store Code");
 			Cell cellStoreNameHeader = rowHeader.createCell(i++);
 			} else if (index < intervals.size()) {
 				cellHeader.setCellValue(intervals.get(index - 1) + " - " + intervals.get(index) + " Days");
 			} else {
 				cellHeader.setCellValue("More Than " + intervals.get(index - 1) + " Days");
+			}
-			sheet.addMergedRegion(new CellRangeAddress(0, 0, i-1, i));
+			sheet.addMergedRegion(new CellRangeAddress(0, 0, i - 1, i));
 			rowHeader.createCell(i++);
-			Cell cellPrice = rowPriceQuantity.createCell(i-2);
+			Cell cellPrice = rowPriceQuantity.createCell(i - 2);
 			cellPrice.setCellValue("Price");
-			Cell cellQuantity = rowPriceQuantity.createCell(i-1);
+			Cell cellQuantity = rowPriceQuantity.createCell(i - 1);
 			cellQuantity.setCellValue("Quantity");
+		}
 		Font font = workbook.createFont();
 		font.setBold(true);
 		CellStyle cellStyle = workbook.createCellStyle();
 		cellStyle.setFont(font);
-		for (int j = 0; j < nonValueColumns + ((intervals.size()+1)) * 2; j++) {
+		for (int j = 0; j < nonValueColumns + ((intervals.size() + 1)) * 2; j++) {
 			rowHeader.getCell(j).setCellStyle(cellStyle);
 			if (rowPriceQuantity.getCell(j) != null) {
 				rowPriceQuantity.getCell(j).setCellStyle(cellStyle);
+			}
+		}
 		for (InventoryItemAgingModel inventoryItemAgingModel : inventoryItemAgingModels) {
-			i=0;
+			i = 0;
 			Row rowValues = sheet.createRow(rowIndex++);
-			if(showPartner) {
+			if (showPartner) {
 				rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getFofoId());
 				rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreCode());
 				rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getStoreName());
+			}
 			rowValues.createCell(i++).setCellValue(inventoryItemAgingModel.getItemId());
 					rowValues.createCell(i++).setCellValue("-");
+				}
+			}
+		}
-		for (int index = 0; index < nonValueColumns + ((intervals.size()+1) * 2); index++) {
+		for (int index = 0; index < nonValueColumns + ((intervals.size() + 1) * 2); index++) {
 			sheet.autoSizeColumn(index);
+		}
 		try {
 			workbook.write(outputStream);
 		} catch (IOException ioException) {
 			LOGGER.error("Unable to generate excel file", ioException);
+		}
+	}
+	public static List<WalletHistoryModel> parseWalletBulkCredit(InputStream inputStream) throws Exception {
+		List<WalletHistoryModel> walletHistoryModels = new ArrayList<>();
+		try (XSSFWorkbook myWorkBook = new XSSFWorkbook(inputStream)) {
+			myWorkBook.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);
+			// Return first sheet from the XLSX workbook
+			XSSFSheet mySheet = myWorkBook.getSheetAt(0);
+			LOGGER.info("rowCellNum {}", mySheet.getLastRowNum());
+			for (int rowNumber = 1; rowNumber <= mySheet.getLastRowNum(); rowNumber++) {
+				XSSFRow row = mySheet.getRow(rowNumber);
+				LOGGER.info("row {}", row);
+				WalletHistoryModel walletHistoryModel = new WalletHistoryModel();
+				if (row.getCell(1) != null && row.getCell(1).getCellTypeEnum() == CellType.NUMERIC) {
+					walletHistoryModel.setFofoId((int) row.getCell(1).getNumericCellValue());
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Fofo Id", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(2) != null && row.getCell(2).getCellTypeEnum() == CellType.STRING) {
+					WalletReferenceType referenceType = WalletReferenceType
+							.valueOf(row.getCell(2).getStringCellValue());
+					if (!BULK_WALLET_REFERENCES.contains(referenceType)) {
+						throw new ProfitMandiBusinessException("Invalid Reference type", "row number " + rowNumber,
+								"row number " + rowNumber);
+					}
+					walletHistoryModel
+							.setWalletReferenceType(WalletReferenceType.valueOf(row.getCell(2).getStringCellValue()));
+				} else {
+					throw new ProfitMandiBusinessException("Invalid ReferenceType", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(3) != null && row.getCell(3).getCellTypeEnum() == CellType.NUMERIC) {
+					Date businessDate = row.getCell(3).getDateCellValue();
+					LocalDateTime businessDateTime = LocalDateTime.of(
+							LocalDate.of(businessDate.getYear(), businessDate.getMonth(), businessDate.getDate()),
+							LocalTime.MIDNIGHT);
+					walletHistoryModel.setBusinessDate(businessDateTime);
+					;
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Business Date", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(4) != null && row.getCell(4).getCellTypeEnum() == CellType.NUMERIC) {
+					Date businessDate = row.getCell(4).getDateCellValue();
+					LocalDateTime businessDateTime = LocalDateTime.of(
+							LocalDate.of(businessDate.getYear(), businessDate.getMonth(), businessDate.getDate()),
+							LocalTime.MIDNIGHT);
+					walletHistoryModel.setBusinessDate(businessDateTime);
+					;
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Business Date", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(5) != null && row.getCell(5).getCellTypeEnum() == CellType.NUMERIC) {
+					double amount = row.getCell(5).getNumericCellValue();
+					if (amount < 0) {
+						throw new ProfitMandiBusinessException("Invalid Amount, only positive values",
+								"row number " + rowNumber, "row number " + rowNumber);
+					}
+					walletHistoryModel.setAmount(amount);
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Amount", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(6) != null && row.getCell(6).getCellTypeEnum() == CellType.STRING) {
+					String transactionType = row.getCell(6).getStringCellValue().toLowerCase();
+					if (transactionType.equals("dr")) {
+						walletHistoryModel.setAmount(-walletHistoryModel.getAmount());
+					} else if (!transactionType.equals("cr")) {
+						throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
+								"row number " + rowNumber);
+					}
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				if (row.getCell(7) != null && row.getCell(7).getCellTypeEnum() == CellType.STRING) {
+					String description = row.getCell(7).getStringCellValue().toLowerCase();
+					walletHistoryModel.setDescription(description);
+				} else {
+					throw new ProfitMandiBusinessException("Invalid Transaction Type", "row number " + rowNumber,
+							"row number " + rowNumber);
+				}
+				walletHistoryModels.add(walletHistoryModel);
+			}
+			return walletHistoryModels;
+		}
+	}
+}

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java – Rev 26983 → 27064